Creating Predictions for the Call Center Models (Intermediate Data Mining Tutorial)

In Solution Explorer, right-click Data Source Views, and then select New Data Source View.

In the Data Source View wizard, select Adventure Works DW2008R2 as the data source, and then click Next.

On the Select Tables and Views page, click Next without selecting any tables.

On the Completing the Wizard page, type the name, Shifts.

This name will appear in Solution Explorer as the name of the data source view.

Right-click the empty design pane, then select New Named Query.

In the Create Named Query dialog box, for Name, type Shifts for Call Center.

This name will appear in Data Source View designer only as the name of the named query.

Paste the following query statement into the SQL text pane in the lower half of the dialog box.

SELECT DISTINCT WageType, Shift, 
AVG(Orders) as AvgOrders, MIN(Orders) as MinOrders, MAX(Orders) as MaxOrders,
AVG(Calls) as AvgCalls, MIN(Calls) as MinCalls, MAX(Calls) as MaxCalls,
AVG(LevelTwoOperators) as AvgOperators, MIN(LevelTwoOperators) as MinOperators, MAX(LevelTwoOperators) as MaxOperators,
AVG(Issues) as AvgIssues, MIN(Issues) as MinIssues, MAX(Issues) as MaxIssues
FROM dbo.FactCallCenter
GROUP BY Shift, WageType

Click OK..

In the design pane, right-click the table, Shifts for Call Center, and select Explore Data to preview the data as returned by the T-SQL query.

Right-click the tab, Shifts.dsv (Design), and then click Save to save the new data source view definition.

In Data Mining Designer, click the Mining Model Prediction tab.

In the Mining Model pane, click Select Model, and choose Call Cetner - LR from the list of available models.

From the Mining Model menu, clear the option, Singleton Query. A warning tells you that the singleton query inputs will be lost. Click OK.

The Singleton Query Input dialog box is replaced with the Select Input Table(s) dialog box.

Click Select Case Table.

In the Select Table dialog box, selectShifts from the list of data sources. In the Table/View name list, select Shifts for Call Center (it might be automatically selected), and then click OK.

The Mining Model Prediction design surface is updated to show mappings that are created by Analysis Services based on the names and data types of columns in the input data and in the model.

Right-click one of the join lines, and then select Modify Connections.

In this dialog box, you can see exactly which columns are mapped and which are not. The mining model contains columns for Calls, Orders, Issues, and LvlTwoOperators, which you can map to any of the aggregates that you created based on these columns in the source data. In this scenario, you will map to the averages.

Click the empty cell next to LevelTwoOperators, and select Shifts for Call Center.AvgOperators.

Click the empty cell next to Calls, select Shifts for Call Center.AvgCalls. and then click OK.

In the grid at the bottom half of the Prediction Query Builder, click the empty cell under Source, and then select Shifts for Call Center.

In the empty cell under Field, select Shift.

Click the next empty line in the grid and repeat the procedure described above to add another row for WageType.

Click the next empty line in the grid. In the Source column, select Prediction Function. In the Field column, select Predict.

Drag the column ServiceGrade from the Mining Model pane down to the grid, and into the Criteria/Argument cell. In the Alias field, type Predicted Service Grade.

Click the next empty line in the grid. In the Source column, select Prediction Function. In the Field column, select PredictProbability.

Drag the column ServiceGrade from the Mining Model pane down to the grid, and into the Criteria/Argument cell. In the Alias field, type Probability.

Click Switch to query result view to view the predictions.