Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Pragmatic Self-Service BI with PowerPivot for Excel

via Pluralsight

Overview

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.

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

Reviews

4 rating at Pluralsight based on 127 ratings

Start your review of Pragmatic Self-Service BI with PowerPivot for Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.