SharePoint 2010 Business Intelligence Course

Finally!  It is about one month past due, but I finished it today!  It will be globally available in two weeks!  Here's the outline:

  • Business Intelligence
    • Answer Business Intelligence Questions
  • Business Intelligence Center
    • Explore SharePoint Business Intelligence Center
    • Understand a Key Performance Indicator
    • Explore Dashboard Designer
  • Data Mart & Data Warehouses
    • Explore Data Formats
    • Create a Simple Data Warehouse
    • Explore the Extract stage
    • Explore Transform & Load stages
    • Realize the importance of primary/unique keys
    • Create Data Warehouse Granularity Levels
    • Create a Data Mart
  • Business Connectivity Services
    • Explore External Content Types
    • Create a new External Content Type
    • Create an External List
    • Create a new External Content Type
    • Create an External List
    • Filters and External lists
    • Entity Profile Pages
    • Explore Office and BCS Integration
  • Analysis Services
    • Create Dimension and Fact tables
    • Create an Analysis Services Database
    • Create a Analysis Services Database
    • Create a Cube
    • Create Dimensions
    • Create Fact Tables
    • Create a KPI
  • Filter Web Parts
    • Use each of the Filter Web Parts
  • Excel Services
    • Create An Excel Report
    • Learn to use Excel Services
    • Create/Publish to Excel Services
    • Configure Excel Services
    • Shared Data Connections
    • Explore Excel 2010 MDX features
    • Create a Slicer
    • Create an MDX Set
    • Use Excel 2010 Sparklines
    • Explore Filter Web Parts and Excel Services
    • Explore REST features of Excel Services
    • Explore the Excel Services Web Service
  • PowerPivot
    • Install PowerPivot for Excel
    • Install PowerPivot for SharePoint 2010
    • Configure PowerPivot for SharePoint
    • Explore PowerPivot Functions
    • Use Basic PowerPivot
    • Use PowerPivot with Large DataSets
    • Create PowerPivot Linked Tables
    • Publish to SharePoint
    • Automating Data Refresh
    • Analyzing Usage Data
  • Reporting Services
    • Configure Reporting Services
    • Create a Reporting Services Report
    • Configure Reporting Services Web Part
    • Create Advanced Reporting Services report
    • Filter Web Parts and Reports
    • Create Report Part Gallery
    • Create a Report Library
    • Create Report Parts
    • Create a Report using Report Parts
    • Automated Report Delivery
  • Performance Point
    • Explore Performance Service Application
    • Explore the Dashboard Designer
    • Create A Scorecard
    • Create A PP KPI
    • Explore Time Intelligence
    • Create Performance Point Reports
    • Create Filters
    • Create A Dashboard
  • Visio & Access Services
    • Use Visio Services
    • Publish a Visio to SharePoint
    • Tie report process to Visio
    • Explore Access Services
    • Publish Access Database To SharePoint
  • GeoSpatial Data with Charts & Maps
    • Utilize the new Spatial Data Types in SQL Server
    • Explore new features of SQL Server Management Studio
    • Utilize Bing Maps API
    • Create a Simple Map With Content Editor Web Part
    • Create an Advanced Map with Data Views
    • Explore Filters, Data Views and Bing Maps integration
    • Integrate Geospatial Customer data into SharePoint Sites
    • Utilize .NET Charts