O'Reilly logo

Professional Microsoft® SQL Server® Analysis Services 2008 with MDX by Denny Guang-Yeu Lee, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Sivakumar Harinath

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

18.2. Table Analytics

Table Analytics, one of the Microsoft SQL Server 2008 Data Mining Add-ins for Office 2007, helps you to analyze the tables within Excel spreadsheets. You will use the sample Excel spreadsheet DMAddins_SampleData.xlsx shipped with the Microsoft SQL Server 2008 Data Mining Add-ins for Office 2007 to learn about the Table Analytics component. To start using Table Analytics, follow these steps:

  1. Open the sample spreadsheet DMAddins_SampleData.xlsx by clicking Start All Programs Microsoft SQL Server 2008 DM Add-ins Sample Excel Data.

    You see the default page of the Excel Sample Data spreadsheet. The spreadsheet has nine sheets that contain sample data to highlight various features of the Microsoft SQL Server 2008 Data Mining Add-ins for Office 2007.

  2. Click the sheet named Table Analytics Tools Sample.

  3. In the sheet click one of the cells in the table. You see additional tabs in the Excel Ribbon called Analyze and Design.

  4. Click the Analyze Ribbon. You see the various Table Analytics features from the Table Analytics Tools add-in as icons shown in Figure 18-2. Each icon is used to perform specific tasks on your table to provide results from which you can potentially take ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required