Pragmatic Self-Service BI with PowerPivot for Excel
Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction and Foreword- 6m 43s
—Introduction and Installation 6m 43sPowerPivot Installation and Overview- 53m 0s
—Introduction and Installation 2m 55s
—Check for Installation 1m 25s
—Demo: Verify Installation 0m 28s
—Self-Service BI and PowerPivot 3m 52s
—Managed Self-Service Business Intelligence 4m 0s
—How PowerPivot Works 5m 5s
—Demo: A Brief Overview of PowerPivot 2m 17s
—Importing Text into PowerPivot 0m 22s
—Demo: Import a Text File 3m 32s
—Importing from Excel to PowerPivot 1m 19s
—Demo: Import from Excel 2m 8s
—Files Underlying PowerPivot 0m 44s
—Demo: Examine Files Underlying PowerPivot 1m 21s
—PowerPivot with SharePoint 4m 18s
—PowerPivot Features and Limitations, and Relationships 4m 56s
—Demo: Add a Relationship 2m 49s
—Calculated Columns with DAX Examples 1m 10s
—Demo: Add Calculated Columns 3m 35s
—Mount PivotTable with a Measure 0m 57s
—Demo: Create a Basic Dashboard with PowerPivot Data 4m 41s
—Installation and Overview Summary 1m 6sBuilding the Basic PowerPivot Data Model- 24m 14sWorking with the PowerPivot Model, and an Introduction to DAX- 49m 29sBuild a Practical PowerPivot Application - Part 1- 30m 31sBuild a Practical PowerPivot Application - Part 2- 42m 7sPractical PowerPivot Analysis and Reporting with PivotTables- 44m 51s
