Table of Contents
Section I: Data Warehousing and Section I: Business Intelligence.
Lesson 1: Why Business Intelligence?
Lesson 2: Dimensional Modeling.
Lesson 3: Fact Table Modeling.
Section II: SQL Server Integration Services.
Lesson 4: Understanding SSIS.
Lesson 5: Using the Control Flow.
Lesson 6: Using the Data Flow.
Lesson 7: Solving Common SSIS Scenarios.
Lesson 8: Loading Dimensions.
Lesson 9: Loading a Fact Table.
Lesson 10: Deploying SSIS Packages.
Section III: SQL Server Analysis Services.
Lesson 11: Understanding SSAS.
Lesson 12: Configuring a Data Source and Data Source View.
Lesson 13: Using the Cube Wizard.
Lesson 14: Editing Your Dimension.
Lesson 15: Editing Your Cube.
Lesson 16: Add ing New Dimensions and Measure Groups.
Lesson 17: Using MDX.
Lesson 18: Creating Calculations.
Lesson 19: Data Mining.
Lesson 20: Administering the SSAS Instance.
Section IV: Reporting Services.
Lesson 21: Understanding SSRS.
Lesson 22: Using Report Wizard.
Lesson 23: Building a Matrix Report.
Lesson 24: Parameterizing Your Reports.
Lesson 25: Building Reports on Your Cube.
Lesson 26: Using Maps in Your Report.
Lesson 27: Building a Dashboard.
Lesson 28: Deploying and Ad ministering SSRS.
Lesson 29: New Reporting Services Visualizations — Sparklines, Data Bars, and Indicators.
Lesson 30: Using Report Builder.
Section V: Containers.
Lesson 31: Reporting against a Cube with Excel.
Lesson 32: Loading Data into a PowerPivot Workbook.
Lesson 33: Creating a PowerPivot Report.
Lesson 34: Data Mining in Excel.
Section VI: SharePoint.
Lesson 35: Understanding SharePoint for Business Intelligence.
Lesson 36: Deploying and Using Reporting Services in SharePoint 2010.
Lesson 37: Building PerformancePoint Dashboards in SharePoint 2010.
Lesson 38: Deploying and Using Excel Services.
Lesson 39: Deploying and Using PowerPivot in SharePoint.
Lesson 40: Managing SharePoint Business Intelligence.
Appendix: What's on the DVD?