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

318



LESSON 34 Data Mining in ExcEl

You need to choose the middle option to connect to an Analysis Services instance that you administer.

Excel will prompt you, as in Figure 34-10, to run the server configuration utility if you have not done

so already. You have because you’re prepared!

You now have the option to open a test table of data when the wizard closes, as shown in Figure 34-11.

That is exactly what you are going to do.

FIGURE 3410

FIGURE 3411

889633c34.indd 318 8/16/10 10:51:52 PM

Exploring the Data Mining Add-Ins



319

That shortcut will open up the DMAddins_SampleData.xlsx spreadsheet that was installed along

with the add-ins. See Figure 34-12. This spreadsheet is the main artifact you’ll continue to work

with in this lesson. The introduction tab walks you through the different types of analysis you can

work on in this example data set with the new add-ins you just installed.

FIGURE 3412

You will also notice in Figure 34-12 that the spreadsheet has a tab for each type of analysis you can

do. If you select the Table Analysis Tools Sample tab and click anywhere in the tool, you’ll see the

Ribbon has another section called Table Tools, highlighted in yellow. On the Analyze portion of the

Table Tools, you find all the user-friendly data mining tools that Excel has to offer to ...