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