Is my data in the right format?
Before you can build a model, you need your data in the right format. Data cleaning is 60% of the job: time to learn how to do it!
Based on Experience
Vetted industry professionals, that have experience working with these companies and others, consulted in an advisory capacity to ensure the content of this course was realistic.
This is a work of fiction. Unless otherwise indicated, all the names, characters, businesses, places, events and incidents in this course are either the product of the author's imagination or used in a fictitious manner. Any resemblance to actual persons, living or dead, or actual events is purely coincidental.
How do you answer the question "Is my data in the right format?" – learn how Data Cleaning can help you find the answer!
Before you start modeling, you need to get your model in the right format. Data cleaning is the process of manipulating your data to get it ready to go. Read More
1 hour, 11 minutes
|1. Clean data, clear mind||You've been asked to get data ready for a big modeling exercise, but what format do you need it in? What does clean data look like?||6|
|2. All your spend in one place||First we need to collect our media spend, and get it all in one place, categorized by campaign in tabular format.||21|
|3. Importing 3rd party data||Market trends, and global events like COVID have an impact on sales, so how do we include them? The key is getting the data in a usable format.||14|
|4. Making dummies for dates||Holidays and other important dates need to be incorporated, and to do so we need dummy variables – 1s and 0s.||14|
Frequently Asked Questions
Learn about Data Cleaning today.
Discover how to solve this problem: Is my data in the right format?