Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Try It



323

Favors Skilled Manual:



This column displays a relative impact data bar. This data bar’s length

and darkness demonstrate the impact the influencer on that line in the report has on Skilled

Manual. The longer and darker it is, the more impact it has.

Favors Professional:



This column displays a relative impact data bar. This data bar’s length and

darkness demonstrates the impact the influencer on that line in the report has on Professional.

The longer and darker it is, the more impact it has.

Now you’re going to build an influencers report in Excel 2007 using the data mining add-ins in the

Try It section that follows.

TRY IT

In this Try It section you’re going to build an influencers report that categorizes bicycle buyers by

education.

Lesson Requirements

You will create a report in Excel 2007 that uses the sample data from the DMAddins_SampleData

Spreadsheet and categorizes the main influencers for bicycle buying between different levels of buyer

education. To do this, use the following hints.

Hints

Make sure to install and configure the add-ins before you begin.



Use the Table Analysis Tools Sample Tab for your source data.



Make sure to click in the table to expose the options you need.



Step-by-Step

1. Open the Sample Spreadsheet. If you have

already closed out the wizard, you can access it

directly from the start menu as in Figure 34-18.

2. Because you’re going to analyze ...