Using Drillthrough on Structure Data (Basic Data Mining Tutorial)

As part of their advertising campaign, Adventure Works Cycles is sending a mailer to potential customers in the 34-40 age demographic. The marketing department has decided that they would also like to send the mailer to the customers whom purchased bikes from Adventure Works Cycles more than five years ago. In this lesson you will identify customers with older bikes and retrieve their contact information. This information is not included in the model, but is included in the structure. To retrieve the contact information you will first ensure that drillthrough is enabled for the structure and then you will use drillthrough to reveal the names and addresses of the customers with older bikes.

For information on how to drill through to model cases, see Using Drillthrough on Structure Data (Basic Data Mining Tutorial).

To enable drillthrough on a mining model

  1. In Business Intelligence Development Studio, on the Mining Models tab of Data Mining Designer, right-click the TM_Decision_Tree model, and select Properties.

  2. In the Properties windows, click AllowDrillthrough, and select True.

  3. In the Mining Models tab, right-click the model, and select Process Model.

For more information, see Using Drillthrough on Mining Models and Mining Structures (Analysis Services - Data Mining)

To view drillthrough data from a mining model

  1. In Data Mining Designer, click the Mining Model Viewer tab.

  2. Select the TM_Decision_Tree model from the Mining Model list.

  3. Change the Background value to 1.

  4. Select the Microsoft Tree viewer from the Viewer list, and right-click the Age >=34 and <41 node.

  5. Select Drill Through, and then select Model and Structure Columns to open the Drill Through window.

  6. Scroll to the Structure.Date First Purchase column to view the purchase dates for the older bikes.

  7. To copy the data to the Clipboard, right-click any row in the table, and select Copy All.

Congratulations, you have completed the basic data mining tutorial. Now that you are comfortable using the data mining tools, we recommend that you also complete the intermediate data mining tutorial, which demonstrates how to create models for forecasting, market basket analysis, and sequence clustering.