Introduction | |
Data Warehousing and Section I: Business Intelligence | |
Why Business Intelligence? | |
Dimensional Modeling | |
Fact Table Modeling | |
SQL Server Integration Services | |
Understanding SSIS | |
Using the Control Flow | |
Using the Data Flow | |
Solving Common SSIS Scenarios | |
Loading Dimensions | |
Loading a Fact Table | |
Deploying SSIS Packages | |
SQL Server Analysis Services | |
Understanding SSAS | |
Configuring a Data Source and Data Source View | |
Using the Cube Wizard | |
Editing Your Dimension | |
Editing Your Cube | |
Add ing New Dimensions and Measure Groups | |
Using MDX | |
Creating Calculations | |
Data Mining | |
Administering the SSAS Instance | |
Reporting Services | |
Understanding SSRS | |
Using Report Wizard | |
Building a Matrix Report | |
Parameterizing Your Reports | |
Building Reports on Your Cube | |
Using Maps in Your Report | |
Building a Dashboard | |
Deploying and Ad ministering SSRS | |
New Reporting Services Visualizations - Sparklines, Data Bars, and Indicators | |
Using Report Builder | |
Containers | |
Reporting against a Cube with Excel | |
Loading Data into a PowerPivot Workbook | |
Creating a PowerPivot Report | |
Data Mining in Excel | |
SharePoint | |
Understanding SharePoint for Business Intelligence | |
Deploying and Using Reporting Services in SharePoint 2010 | |
Building PerformancePoint Dashboards in SharePoint 2010 | |
Deploying and Using Excel Services | |
Deploying and Using PowerPivot in SharePoint | |
Managing SharePoint Business Intelligence | |
Appendix: What's on the DVD? | |
Table of Contents provided by Publisher. All Rights Reserved. |