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 crossprediction.
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).



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 CrossPrediction
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)
Adding a Data Source View for Forecasting (Intermediate Data Mining Tutorial)
Understanding the Requirements for a Time Series Model (Intermediate Data Mining Tutorial)
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)
Basic Data Mining Tutorial
Intermediate Data Mining Tutorial (Analysis Services  Data Mining)
Microsoft Time Series Algorithm