Science of Forecasting Course

How to Forecast Anything

Mastercourse with Excel, SQL, Python, cloud-scale spreadsheets, and modern AI tools.

Learn to predict revenue, demand, trends, pickup, attrition, sales funnels, wholesale sales, costs, and rolling forecasts using practical forecasting techniques applied to real business data.

20+ hours of short, one-topic, on-demand, pre-recorded videos. 5-10 minute lessons. Self-paced with no time limit, no assignments, and forever course access.

20+ hoursShort, one-topic, on-demand videos

5-10 minutesLessons designed to fit into your lifestyle

Forever accessSelf-paced with no time limit

Real transaction dataWork from practical business examples

Downloadable templatesExcel templates included

Instructor sessionsUnlimited one-on-one sessions with instructor

Who has registered for this course?

Built for professionals who need to predict revenue, demand, and business performance.

ControllersAccounting ProsFinancial ProsSales ManagersConsultantsRevenue ProsBookkeepersTax Pros

What You Will Learn

Forecasting skills that move beyond guesswork.

The Best Predictive Techniques

Statistical Concepts for Forecasting
Excel Forecasting functions
Simple Moving Average
Weighted Moving Average
Exponential and Double Smoothing
Exponential Smoothing with Trend Adjustments
Seasonality Smoothing
Excel Array functions
Bayesian Forecasting
Measuring Forecast Accuracy
Improving Forecast Accuracy
Regression Techniques

Applied to Real Business Data

Forecasting Year-over-Year Growth
Forecasting Techniques for Contract Sales
Forecast Customer Pickup and Attrition
Forecast Sales Funnels Performance
Forecast Wholesale Sales
Dynamic Forecasting for Individual Sales
Forecast Bundled Sales
Forecast Variable Costs
Forecast the 21 Dimensions of Revenue
Building a P&L Forecasting Model
Build Rolling Forecasts
Connecting to Transaction Systems for Streaming Forecasts

All the skills needed to be a Forecasting Expert

Learn the methods behind crediblebusiness forecasts.

Data Extraction and Transformation

Data extraction and transformation are vital steps in the forecasting process. Accurate and relevant data is essential for building reliable forecasting models.

You will learn to use SQL and Excel to extract data from various sources, clean and preprocess it, and transform it into a suitable format for forecasting analysis.

Statistical Concepts for Forecasting

Statistical concepts serve as the foundation for forecasting. This module covers key concepts such as probability, probability distributions, correlation, regression analysis, and time series analysis.

You will learn to analyze data patterns, identify relationships, and make informed forecasts.

Excel Forecasting Functions

Excel is a widely used tool for data analysis and forecasting. This module focuses on the specific forecasting functions available in Excel, such as FORECAST, TREND, GROWTH, and LINEST.

You will learn how to leverage these functions to generate forecasts, analyze trends, and evaluate the performance of forecasting models. Proficiency in Excel forecasting functions enhances efficiency and productivity in forecasting tasks.

Excel Array Functions

Array functions in Excel provide advanced capabilities for forecasting calculations. This module introduces students to the concept of array formulas and their application in forecasting.

You will learn how to leverage Excel array functions to perform complex calculations on multiple data points simultaneously, leading to efficient and effective forecasting analysis.

Simple Moving Average

The simple moving average is a fundamental forecasting technique that smoothes out variations in data. This module explores the concept of moving averages and its applications in forecasting.

You will learn how to calculate and interpret moving averages, select appropriate window sizes, and utilize them for short-term forecasting. Mastering simple moving average techniques enables you to identify trends and make quick forecasts based on historical data.

Weighted Moving Average

Weighted moving averages offer a more nuanced approach to forecasting by assigning different weights to past observations. This module delves into the calculation and interpretation of weighted moving averages.

You will understand how to assign weights based on data significance and use this technique to capture changes in data patterns. Proficiency in weighted moving averages enhances forecasting accuracy, particularly when recent data points carry more importance.

Exponential and Double Smoothing

Exponential smoothing techniques provide a flexible and adaptable approach to forecasting. This module explores single-exponential smoothing and double-exponential smoothing.

You will learn how to apply exponential smoothing methods to capture trend and seasonality in data. Understanding these techniques equips you with the ability to handle time series data and generate forecasts that account for different components of variation.

Exponential Smoothing with Trend

Exponential smoothing with trend extends the capabilities of exponential smoothing by incorporating trend analysis. This module focuses on techniques like Holt’s linear exponential smoothing to forecast data with both level and trend components.

You will learn how to adjust smoothing parameters to capture trend changes effectively. Proficiency in exponential smoothing with trend allows for more accurate forecasting in situations where data exhibits a consistent trend over time.

Seasonality Smoothing

Seasonality smoothing is crucial for forecasting data that exhibits recurring patterns at regular intervals. This module covers methods for seasonality decomposition and adjustment, such as seasonal indices and deseasonalization techniques.

You will gain the ability to identify and handle seasonality in data, resulting in more accurate and reliable seasonal forecasts.

Bayesian Forecasting

Bayesian forecasting offers a probabilistic approach that incorporates prior knowledge and observed data. This module explores Bayesian inference and its application in forecasting. Proficiency in Bayesian forecasting equips you with a valuable tool for handling uncertainty and incorporating expert opinions in forecasting analysis.

You will understand how to update prior beliefs with data to generate posterior distributions and probabilistic forecasts.

Regression Techniques

Regression analysis plays a crucial role in forecasting when relationships exist between the dependent variable and one or more independent variables. This module introduces students to simple linear regression, multiple linear regression, and non-linear regression models.

You will learn how to identify relevant variables, estimate regression coefficients, interpret results, and use regression analysis to forecast outcomes.

Measuring Forecast Accuracy

Measuring forecast accuracy is essential for evaluating the performance of forecasting models. This module focuses on commonly used metrics such as mean absolute error, mean squared error, root mean squared error, and mean absolute percentage error.

You will learn how to calculate and interpret these metrics to assess the accuracy of their forecasts. Understanding forecast accuracy metrics enables students to objectively evaluate the performance of different forecasting techniques and make informed decisions.

Improving Forecast Accuracy

Forecast accuracy improvement is a continuous process in forecasting. This module covers techniques and strategies for enhancing forecast accuracy.

You will learn how to analyze forecast errors, identify patterns or biases, and diagnose the root causes of inaccuracies. You will explore methods for model selection, parameter tuning, incorporating external factors, and leveraging expert judgment to refine forecasting models.

Dozens of Real-World Case Studies

Build forecasts for real business situations.

Forecasting Year-over-Year Growth

Forecasting year-over-year growth is crucial for businesses to anticipate and plan for future revenue performance. This case study focuses on understanding historical trends, identifying factors influencing growth, and developing forecasting models that project revenue growth for the upcoming periods.

You will learn how to predict revenue growth accurately, enabling effective resource allocation and strategic decision-making.

Dynamic Pricing and Forecasting Sales

This case study emphasizes dynamic forecasting techniques tailored to product sales, considering factors such as market demand, pricing strategies, and purchase patterns.

You will learn how to develop flexible and responsive forecasting models, enabling businesses to maximize revenue potential, optimize pricing decisions, and efficiently manage inventory.

Building a Forecasting Model

This case study focuses on the practical aspects of building a forecasting model specifically tailored for revenue and expense forecasting. Students learn the step-by-step process of constructing a forecasting model, including data collection, preprocessing, feature selection, model selection, and model evaluation.

You will learn the skills to develop customized forecasting models that accurately predict revenue, enabling informed decision-making and effective profit management.

Build Rolling Forecasts

Rolling forecasts allow analysts to continuously update and refine their forecasts based on the most recent data and market conditions. This case study focuses on the concept of rolling forecasts and the techniques used to build and maintain them.

You will learn how to incorporate new data, adjust forecast models, and analyze forecast variances to ensure the accuracy and relevance of rolling forecasts.

Forecast Automation

Automating the forecasting process can significantly enhance efficiency and accuracy in forecasting. This exercise explores techniques and tools for automating the forecasting workflow, including data extraction, transformation, model selection, and report generation.

You will gain hands-on experience with forecasting models and learn how to leverage automation to streamline the forecasting process, reduce manual effort, and improve overall forecasting quality.

No-nonsense, Immediate-Impact Training

Software-Agnostic forecasting skills that transfer to other systems.

Most data analysis courses focus on a specific software or platform, thereby limiting your ability to transfer your knowledge to other systems. Not this one.

This course is software agnostic. We do not promote or limit the course to any specific statistics package or any other software. We also do not promote any third-party companies or consulting services, including OWL. This course is not affiliated with any university, association, or third-party company.

Leap to the Top .1% of global business analytics talent.

Enrollment

Learn forecasting as a serious business analytics discipline.

100% Money-back Guarantee.
Real transaction data, downloadable Excel templates, and Certificate of Completion.
Lifetime access to review the material at any time.

Meet Your Instructor

Robert Hernandez

I am Robert Hernandez, and I am committed to helping you learn everything I know, without wasting your time on purely academic skills that do not translate into real-world value. I bring a rare combination of cross-disciplinary experience, advanced mathematical and analytics skills, technical competency, multi-industry knowledge, and business process improvement expertise. I am an energetic and dedicated analytics professional with strong business acumen and more than 20 years of experience creating and managing data-driven models and processes for diverse organizations, both on-site and remotely. I have worked at Walt Disney and HP/Compaq, and have consulted for dozens of companies across industries, from e-commerce to entertainment to energy.

in Connect with Robert on LinkedIn

Have a Question about this course? Email me.

Explore Our Other Courses