Data Quality: Getting Data Preparation Right is Key! Here’s How
Some 80% of work on data projects is data preparation. Yet, most people pay little attention to it, jumping straight to analysis.
Using poor quality data or poorly understood data leads to poor data analysis.
Or, to quote an old industry adage, “garbage in, garbage out”.
This video addresses this issue by raising awareness and providing general data preparation guidelines, so you have top-notch data quality.
Let’s jump right in!
LIST OF RESOURCES ____________________________________________
Resources mentioned in the Video: https://hubs.la/Q012KXYV0
____________________________________________
Data quality is so important in analytics that there’s an adage for it: “garbage in, garbage out!”. In spite of this, dirty data seems to be a prevalent problem.
We reduced the data prep process to three main dimensions: Data Understanding Data Preparation, and Statistical Preprocessing
1) Data Understanding
First things first, you need to familiarise yourself with the data. The main things to consider are the data source, biases, and missing data.
2) Data Preparation
If there are some obvious mistyped entries, try to fix them first. For the missing data, see if you can fill it in.
There’s no one-size-fits-all when it comes to dealing with missing data - what’s key is that your choices are backed by strong logical reasoning, and all your assumptions are noted down.
3) Statistical Preprocessing
This can range from simple applications, like replacing a missing value with the average, to advanced statistical methods.
__________________________________
Documentation is a critical component of good quality data. To put a stop to the bad-data cycle, you‘ll need to document all of the transformations in a data dictionary.
If the above sounds like a lot, that’s because it is. It is estimated that somewhere between 50 and 90% of the time taken to complete an analytics project is spent on preparing the data.
That’s a lot! But without it, you risk performing a flawed analysis - remember? Garbage in, garbage out!
Getting data preparation right is key to high data quality and high-quality data analysis.
____________________________________________ We hope this video will help you and your team with accessing and preparing the data for analysis.
Hit like, subscribe and share any comments.
And don’t forget to download our Data Preparation Guide - link above!
-------------------------------------------------------
Did you know that if you are in the Netherlands, and an EU citizen you can get €1,000 towards a course? Meaning you can learn with Growth Tribe for free.
For more info and to apply → https://grow.ac/STAP-YouTube
Or find out more about our on-demand courses → https://grow.ac/learn-with-growthtribe → Digital Marketing Certificate → Growth Marketing Certificate → Growth Strategies Certificate (Live) → Conversion Rate Optimisation → Data Fundamentals Certificate → Business Analytics Certificate → Data Visualisation & Storytelling Certificate → Digital Leadership Certificate → Project Management Certificate → Crypto & Web3 Foundations Certificate → Design Thinking Certificate
Ready to train your team? Here are our corporate solutions for growth, innovation and data capabilities. → https://grow.ac/train-my-team
Check out our blog for articles, reports, resources and webinars. → https://grow.ac/growthtribe-blog
You can also follow us on Social Media here for even more learning materials: LinkedIn: https://www.linkedin.com/school/growth-tribe/ Instagram: https://www.instagram.com/growthtribe/ Facebook: https://www.facebook.com/GrowthTribeIO Twitter: https://twitter.com/GrowthTribe
Video URL: https://youtu.be/j15EbiYL78A
#netflix #newonnetflix #netflix2022 #netflixeducation #netflixmovies #hbomax #disneyplus __________
Using poor quality data or poorly understood data leads to poor data analysis.
Or, to quote an old industry adage, “garbage in, garbage out”.
This video addresses this issue by raising awareness and providing general data preparation guidelines, so you have top-notch data quality.
Let’s jump right in!
LIST OF RESOURCES ____________________________________________
Resources mentioned in the Video: https://hubs.la/Q012KXYV0
____________________________________________
Data quality is so important in analytics that there’s an adage for it: “garbage in, garbage out!”. In spite of this, dirty data seems to be a prevalent problem.
We reduced the data prep process to three main dimensions: Data Understanding Data Preparation, and Statistical Preprocessing
1) Data Understanding
First things first, you need to familiarise yourself with the data. The main things to consider are the data source, biases, and missing data.
2) Data Preparation
If there are some obvious mistyped entries, try to fix them first. For the missing data, see if you can fill it in.
There’s no one-size-fits-all when it comes to dealing with missing data - what’s key is that your choices are backed by strong logical reasoning, and all your assumptions are noted down.
3) Statistical Preprocessing
This can range from simple applications, like replacing a missing value with the average, to advanced statistical methods.
__________________________________
Documentation is a critical component of good quality data. To put a stop to the bad-data cycle, you‘ll need to document all of the transformations in a data dictionary.
If the above sounds like a lot, that’s because it is. It is estimated that somewhere between 50 and 90% of the time taken to complete an analytics project is spent on preparing the data.
That’s a lot! But without it, you risk performing a flawed analysis - remember? Garbage in, garbage out!
Getting data preparation right is key to high data quality and high-quality data analysis.
____________________________________________ We hope this video will help you and your team with accessing and preparing the data for analysis.
Hit like, subscribe and share any comments.
And don’t forget to download our Data Preparation Guide - link above!
-------------------------------------------------------
Did you know that if you are in the Netherlands, and an EU citizen you can get €1,000 towards a course? Meaning you can learn with Growth Tribe for free.
For more info and to apply → https://grow.ac/STAP-YouTube
Or find out more about our on-demand courses → https://grow.ac/learn-with-growthtribe → Digital Marketing Certificate → Growth Marketing Certificate → Growth Strategies Certificate (Live) → Conversion Rate Optimisation → Data Fundamentals Certificate → Business Analytics Certificate → Data Visualisation & Storytelling Certificate → Digital Leadership Certificate → Project Management Certificate → Crypto & Web3 Foundations Certificate → Design Thinking Certificate
Ready to train your team? Here are our corporate solutions for growth, innovation and data capabilities. → https://grow.ac/train-my-team
Check out our blog for articles, reports, resources and webinars. → https://grow.ac/growthtribe-blog
You can also follow us on Social Media here for even more learning materials: LinkedIn: https://www.linkedin.com/school/growth-tribe/ Instagram: https://www.instagram.com/growthtribe/ Facebook: https://www.facebook.com/GrowthTribeIO Twitter: https://twitter.com/GrowthTribe
Video URL: https://youtu.be/j15EbiYL78A
#netflix #newonnetflix #netflix2022 #netflixeducation #netflixmovies #hbomax #disneyplus __________
Related videos
