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.
The selection is small but growing. Suggestions? Email me and let me know!
| Analysis Services (Tabular) | ||
|---|---|---|
| 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 | |
| Data Warehouse Design | ||
| Basic Star Schema design | Slowly Changing Dimensions | Automating date dimensions |
| Visualization | ||
| Dashboards on Tablet Devices | Bing Maps PerformancePoint Customization | Querying SSAS cubes in Excel 2010 |
| Using the CUBEVALUE function | ||
| SQL Server | ||
| Using the UPDATE FROM syntax | ||
| Analysis Services (Multidimensional) | ||
| Automating cube processing | Automating cube partitions (coming soon) | Using the DESCENDANTS function (coming soon) |
| Using SCOPE statement (coming soon) | Displaying cube last procesed date in Excel (coming soon) | Using roles to secure cube data #1 (coming soon) |
| Using roles to secure cube data #2 (coming soon) | Cube Partitioning #1 (coming soon) | |
| Reporting Services | ||
| Installing SSRS 2008R2 SP Integration (coming soon) | ||
| Integration Services | ||
| Maintaining a basic dimension using SSIS (coming soon) | Importing EDI data with SSIS (coming soon) | |
| SharePoint | ||
| PerformancePoint Overview (coming soon) | Installing PerformancePoint 2010 (coming soon) | Installing Excel Services 2010 (coming soon) |
| Excel Services Data Source Authentication (coming soon) | Intro to Kerberos Delegation (coming soon) | |