Featured Video

Learn Microsoft BI for free. Really.

Learn Microsoft's BI software with an expert, using a libary of free instructional videos. Topics cover the full range of Microsoft BI technologies from Data Modeling to Dashboard Design.

Each video is presented as if you were sitting one-on-one with a mentor. No boring lectures. Just a practical explanation of each topic as it's used in the real world.

Welcome!

Lessons are organized below by topic or technology.  Each lesson is about 10 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 RSS Feed
Intro to Power ViewArchitecture and System RequirementsPower View vs. other BI Tools
SharePoint Content TypesCreating a BISM data sourceCreating a basic Power View Report
Data Exploration with Power ViewFilters, Slicers and HighlightingCreating Image Fields
Using the Card VisualizationCharts with small multiplesThe Play Axis #1
The Play Axis #2Exporting reports from Power View
Analysis Services (Tabular) RSS Feed
Introduction to BISM #1Introduction to BISM #2Vertipaq Technology #1
Vertipaq Technology #2Installing PowerPivot for ExcelUsing PowerPivot for Excel (Basic)
Publish PowerPivot for Excel to SharePointImport PowerPivot for Excel to SSASIntroduction to DAX
DAX RELATED() FunctionDAX RELATEDTABLE() FunctionCreating a Calculated Measure
Creating a Tabular model in SSDTImporting SQL Server DataImporting SharePoint Data
Importing from the Azure Data MarketImporting from Text FilesImporting from SSRS Reports
Importing from SSAS CubesDAX Calculation ContextDAX CALCULATE() Function
Date Dimensions/TablesCalculating over TimeCounting DISTINCT() Values
Creating Table RelationshipsCreating HierarchiesRole-Based Security
PerspectivesTable PartitioningCreating KPIs
Analysis Services (Multidimensional) RSS Feed
Automating cube processing
Mobile RSS Feed
Dashboards on Tablet Devices
SQL Server RSS Feed
Using the UPDATE FROM syntax
Data Warehouse Design RSS Feed
Basic Star Schema designSlowly Changing DimensionsAutomating date dimensions
Integration Services RSS Feed
Using ForEach with Flat Files
SharePoint RSS Feed
Bing Maps PerformancePoint Customization
Excel RSS Feed
Querying SSAS cubes in Excel 2010Using the CUBEVALUE function

Useful links

  •  Last 10 Postings (RSS)
  •    
  •    
  • Microsoft BI Site
  • BlueGranite Web Site
  • Rob Kerr's Blog
  • Make a suggestion
  • Hands-on Labs