Learn how to use Microsoft PowerPivot to do self service Business Intelligence. This course will guide you through importing data, working with it, then creating pivot tables and charts all in Excel 2010.
Overview
Learn how to use Microsoft PowerPivot to do self service Business Intelligence. This course will guide you through importing data, working with it, then creating pivot tables and charts all in Excel 2010.
Syllabus
- Introduction and Foreword 6mins
- PowerPivot Installation and Overview 53mins
- Building the Basic PowerPivot Data Model 24mins
- Working with the PowerPivot Model, and an Introduction to DAX 49mins
- Build a Practical PowerPivot Application - Part 1 30mins
- Build a Practical PowerPivot Application - Part 2 42mins
- Practical PowerPivot Analysis and Reporting with PivotTables 44mins
Taught by
Bill Pearson