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

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?