Lesson 2: Building a Forecasting Scenario (Intermediate Data Mining Tutorial)

 

Applies To: SQL Server 2016 Preview

As the sales analyst for Adventure Works Cycles, you have been asked to forecast the sales of products for the next year. In particular, you have been asked to compare forecasts for the different regions and product lines. Additionally, you have been asked to determine whether sales of different products vary depending on the time of the year.

To find the requested information, in this lesson you will summarize the company's sales data at the monthly level, and you will also summarize sales figures by three regions: Europe, North America, and the Pacific.

After you complete the tasks in this lesson, you will be able to answer the following questions:

• How do the sales of different bike models change over time?

• Are there differences between the patterns for sales in the three regions?

• Can we forecast sales peaks?

The lesson can be completed in two parts:

• Part One introduces the basics of how to create and use a time series model.

• Part Two walks you through creation of a general time series model, based on all regions. You can use this general model for cross-prediction.

To complete the tasks in this lesson, which are listed below, you will use the AdventureWorksDW2012 data source that you created in Lesson 1: Creating the Intermediate Data Mining Solution (Intermediate Data Mining Tutorial).

Warning

The dates in the Adventure Works Cycles sample database have been updated for this release. If you use an earlier version of Adventure Works Cycles, you can build the model following these steps, but you might see different results.

Creating a Simple Forecasting Model

• Adding a Data Source View for Forecasting (Intermediate Data Mining Tutorial)

• Creating a Forecasting Structure and Model (Intermediate Data Mining Tutorial)

• Modifying the Forecasting Structure (Intermediate Data Mining Tutorial)

• Customizing and Processing the Forecasting Model (Intermediate Data Mining Tutorial)

• Exploring the Forecasting Model (Intermediate Data Mining Tutorial)

• Creating Time Series Predictions (Intermediate Data Mining Tutorial)

Creating a General Forecasting Model for Cross-Prediction

• Advanced Time Series Predictions (Intermediate Data Mining Tutorial)

• Time Series Predictions using Updated Data (Intermediate Data Mining Tutorial)

• Time Series Predictions using Replacement Data (Intermediate Data Mining Tutorial)

• Comparing Predictions for Forecasting Models (Intermediate Data Mining Tutorial)

Next Task in Lesson

Adding a Data Source View for Forecasting (Intermediate Data Mining Tutorial)

Understanding the Requirements for a Time Series Model (Intermediate Data Mining Tutorial)

All Lessons

Lesson 1: Creating the Intermediate Data Mining Solution (Intermediate Data Mining Tutorial)

Lesson 2: Forecasting Scenario (Intermediate Data Mining Tutorial)

Lesson 3: Building a Market Basket Scenario (Intermediate Data Mining Tutorial)

Lesson 4: Building a Sequence Clustering Scenario (Intermediate Data Mining Tutorial)

Lesson 5: Building Neural Network and Logistic Regression Models (Intermediate Data Mining Tutorial)

See Also

Basic Data Mining Tutorial
Intermediate Data Mining Tutorial (Analysis Services - Data Mining)
Microsoft Time Series Algorithm