Use PowerPivot for Excel to deliver self-service business intelligence! This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You'll soon be assembling data from diverse sources into models that deliver business intelligence upon demand. Throughout the rapid but practical exercises, you will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise.
Overview
Use PowerPivot for Excel to deliver self-service business intelligence! This course will start from scratch, and take you through intermediate PowerPivot concepts pragmatically. You'll soon be assembling data from diverse sources into models that deliver business intelligence upon demand. Throughout the rapid but practical exercises, you will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise.
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