Pragmatic Self-Service BI with PowerPivot for Excel

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 info
Rating
(117)
Level
Intermediate
Updated
December 11, 2013
Duration
4h 10m
Table of contents
Introduction and Foreword
PowerPivot Installation and Overview
Building the Basic PowerPivot Data Model
Working with the PowerPivot Model, and an Introduction to DAX
Build a Practical PowerPivot Application - Part 1
Build a Practical PowerPivot Application - Part 2
Practical PowerPivot Analysis and Reporting with PivotTables
Description
Course info
Rating
(117)
Level
Intermediate
Updated
December 11, 2013
Duration
4h 10m
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.

About the author
About the author

Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, focusing his practice upon the integrated Microsoft business intelligence solution. He leverages his years of experience with other enterprise OLAP and reporting applications (Cognos, Business Objects, Crystal, etc.) in regular conversions of these once-dominant applications to the Microsoft BI stack.

More from the author
Business Solutions with MDX
Intermediate
5h 21m
31 Mar 2017