Understand why and how imputing missing values supports an accurate analysis.
Replace missing data with three simple imputation methods in Google Sheets.
Understand uses for moving averages techniques, how to evaluate effectiveness of imputation methods, and how to conduct a demand forecast.
Showcase this hands-on experience in an interview
This course will introduce you to cleaning data and replacing missing values with imputed data to support demand forecasting. Demand forecasts are used to maximize revenue, build efficiencies in operational planning, and to drive future growth. Forecasting techniques can be applied to make realistic predictions of outcomes of everything from how demand affects pricing and sales opportunities to operational planning for electrical utilities and healthcare facilities. We can only have confidence in the demand predictions we produce, when we also have confidence in the data quality feeding those predictions. Ensuring that confidence requires using clean data with no missing values for our forecast models. Handling missing data is an essential part of prepping clean data for a demand forecast. In this course, we will review the principles of applying central measures of tendency and regression techniques to impute missing values. As you clean the data, you will visualize it with charts, replace inconsistent values and impute values while comparing the outcomes of the statistical techniques you have applied. When your data is clean, you will create a demand forecast. You will do this as we work side-by-side in the free-to-use software Google Sheets. By the end of this course, you will understand use cases for imputing missing values and be able to confidently apply multiple statistical imputation techniques in any spreadsheet software. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.
Some familiarity with spreadsheet software is helpful, but not required.
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
Access Google Sheets.
Import data into Google Sheets.
Impute data with three simple imputation methods in Google Sheets.
Impute data with linear and exponential regression, and harmonic means.
Impute data with moving averages techniques, evaluate the results of all imputation methods, and conduct a demand forecast.
Your workspace is a cloud desktop right in your browser, no download required
In a split-screen video, your instructor guides you step-by-step
Are Guided Projects available on desktop and mobile?
Because your workspace contains a cloud desktop that is sized for a laptop or desktop computer, Guided Projects are not available on your mobile device.
Who are the instructors for Guided Projects?
Guided Project instructors are subject matter experts who have experience in the skill, tool or domain of their project and are passionate about sharing their knowledge to impact millions of learners around the world.
Can I download the work from my Guided Project after I complete it?
You can download and keep any of your created files from the Guided Project. To do so, you can use the “File Browser” feature while you are accessing your cloud desktop.
How much experience do I need to do this Guided Project?
At the top of the page, you can press on the experience level for this Guided Project to view any knowledge prerequisites. For every level of Guided Project, your instructor will walk you through step-by-step.
Can I complete this Guided Project right through my web browser, instead of installing special software?
Yes, everything you need to complete your Guided Project will be available in a cloud desktop that is available in your browser.
What is the learning experience like with Guided Projects?
You'll learn by doing through completing tasks in a split-screen environment directly in your browser. On the left side of the screen, you'll complete the task in your workspace. On the right side of the screen, you'll watch an instructor walk you through the project, step-by-step.
More questions? Visit the Learner Help Center.