Creating a Forecasting Mining Model Structure (Data Mining Tutorial)

The first step to creating mining models for a sales forecasting scenario is to use the Data Mining Wizard to create a new mining structure. In this task you will use the wizard to create a mining structure and initial associated mining model that are based on the Microsoft Time Series algorithm.

For More Information

Data Mining Wizard, Data Mining Designer, Microsoft Time Series Algorithm

To create a forecasting mining structure

  1. In Solution Explorer in Business Intelligence Development Studio, right-click Mining Structures and select New Mining Structure.

    The Data Mining Wizard opens.

  2. On the Welcome to the Data Mining Wizard page, click Next.

  3. On the Select the Definition Method page, verify that From existing relational database or data warehouse is selected, and then click Next.

  4. On the Select the Data Mining Technique page, under Which data mining technique do you want to use?, select Microsoft Time Series, and then click Next.

    The Select Data Source View page appears. By default, Adventure Works DW is selected under Available data source views.

  5. Click Next.

  6. On the Specify Table Types page, select the Case check box next to the vTimeSeries table, and then click Next.

  7. On the Training Data page, select the Key check boxes next to the TimeIndex and ModelRegion columns.

  8. Select the Input and Predictable check boxes next to the Quantity column.

    This indicates that you want to forecast this column.

  9. Click Next.

    The Specify Columns' Content and Data Type page appears. The Time Index column is automatically designated as a key time column and the Model Region column is designated as a key column. This means that a separate time series model will be built for each unique entry in the Model Region column. The values in the Time Index column must be unique across individual values in the Model Region column.

  10. Click Next.

  11. On the Completing the Wizard page, in Mining structure name, type Forecasting.

  12. In Mining model name, type Forecasting, and then click Finish.

    Data Mining Designer opens to display the Forecasting mining structure you just created.

Next Task in Lesson

Modifying the Forecasting Model (Data Mining Tutorial)