Welcome!

Lessons are organized below by topic or technology.  The average lesson is 5.4 minutes long and covers a specific skill or central idea.  View lessons in sequence to cover an entire category thoroughly, or skip around and view only those lessons that interest you.

Take it with you! Videos are optimized for viewing using Windows, Mac OSX, iPad devices and mobile phones (Windows Phone 7, iPhone, and Android).

Power View		Atom Feed
Intro to Power View	Architecture and System Requirements	Power View vs. other BI Tools
SharePoint Content Types	Creating a BISM data source	Creating a basic Power View Report
Data Exploration with Power View	Filters, Slicers and Highlighting	Creating Image Fields
Using the Card Visualization	Charts with small multiples	The Play Axis #1
The Play Axis #2	Exporting reports from Power View
Analysis Services (Tabular)		Atom Feed
Introduction to BISM #1	Introduction to BISM #2	Vertipaq Technology #1
Vertipaq Technology #2	Installing PowerPivot for Excel	Using PowerPivot for Excel (Basic)
Publish PowerPivot for Excel to SharePoint	Import PowerPivot for Excel to SSAS	Introduction to DAX
DAX RELATED() Function	DAX RELATEDTABLE() Function	Creating a Calculated Measure
Creating a Tabular model in SSDT	Importing SQL Server Data	Importing SharePoint Data
Importing from the Azure Data Market	Importing from Text Files	Importing from SSRS Reports
Importing from SSAS Cubes	DAX Calculation Context	DAX CALCULATE() Function
Date Dimensions/Tables	Calculating over Time	Counting DISTINCT() Values
Creating Table Relationships	Creating Hierarchies	Role-Based Security
Perspectives	Table Partitioning	Creating KPIs
Using DAX to count what's not there
Analysis Services (Multidimensional)		Atom Feed
Intro to the Data Source View	Creating the SSAS Solution	Setting Impersonation Information
Multiple Data Sources	Physical and Logical Keys	Named Queries in the DSV
Handling data source schema changes	Named Calculations in the DSV	Creating a new Dimension and Cube
Attribute Keys and Names	Creating User Hierarchies	Attribute Relationships
Date Range Filters in MDX	Date +Time Range Filters in MDX	Introducing MDX
Automating cube processing
Hadoop		Atom Feed
Data Warehousing and Big Data	Big Data 101: MPP Made Easy	Is NoSQL a misnomer?
SQL vs. Hadoop: Acid vs. Base	Schema on Write vs. Schema on Read	Where did Hadoop come from?
Introduction to HDFS	Demo: HDFS	How MapReduce Works
Demo: Hadoop MapReduce	Introduction to Hive	Demo: Hive
Introduction to Sqoop	Demo: Sqoop Export	Demo: Sqoop Import
DW + Hadoop Reference Architecture
SharePoint		Atom Feed
POC VM #1 - Introduction	POC VM #2 - Create Service Account	POC VM #3 - Install SharePoint
POC VM #4 - Install PowerPivot	POC VM #5 - PowerPivot Config Wizard	POC VM #6 - Install SSRS
POC VM #7 - Configure SSRS	POC VM #8 - Add SSAS (MD)	POC VM #9 - Configure PerformancePoint
Bing Maps PerformancePoint Customization
Mobile		Atom Feed
The MSBI Academy Windows 8 App	Dashboards on Tablet Devices	SharePoint + SSRS for iPad #1
SharePoint + SSRS for iPad #2
SQL Server		Atom Feed
Using the UPDATE FROM syntax	Columnstore Index Intro	Using a Columnstore Index
Data Warehouse Design		Atom Feed
Basic Star Schema design	Slowly Changing Dimensions	Automating date dimensions
Integration Services		Atom Feed
Using ForEach with Flat Files
Excel		Atom Feed
Querying SSAS cubes in Excel 2010	Using the CUBEVALUE function