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
(118)
Level
Intermediate
Updated
Dec 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
(118)
Level
Intermediate
Updated
Dec 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
Section Introduction Transcripts
Section Introduction Transcripts

Working with the PowerPivot Model, and an Introduction to DAX
Pragmatic Self-Service BI with PowerPivot for Excel. I'm Bill Pearson, and this is Working with the PowerPivot Model and an Introduction to DAX. Our objectives in this module are to learn to work with the PowerPivot Model and DAX, to be able to navigate the PowerPivot Window, to understand the component roles within PowerPivot BI of the PowerPivot Window and PivotTables and Data Analysis Expressions or DAX language, to work with calculated columns by creating basic calculated columns in PowerPivot using DAX while understanding the nature and uses of a PowerPivot calculated column, to introduce the Data Analysis Expressions language, the DAX, and to gain exposure to several representative DAX functions within calculated columns. Navigating PowerPivot. Getting around the PowerPivot window and manipulating data in the Data Sheet View. We've also called that the PowerPivot Window. Data Sheet View is another term for it. Formatting, data types, sorting, filtering, and working with columns.

Build a Practical PowerPivot Application - Part 1
Pragmatic Self-Service BI with PowerPivot for Excel. I'm Bill Pearson, and this is Build a Practical PowerPivot Application -- Part 1. We're going to overview the end-to-end creation of a practical PowerPivot application. We're going to go through several steps that we repeat over and over in building this application that would be probably a really good guide to doing it in the real world. As a part of this, we're going to generate support for a working reporting solution, reporting, and analysis for that matter. We're going to create a PowerPivot data structure, this largely, just as we've seen before through imports, building tables, doing relationships, the basic stuff, but in this case we're going to add what we'll know as a support table. The reusable support tables basically give us a capability to put things in one place to maintain consistency and centralize management of calculations, things that maybe predominantly relate to dimension tables, and in this case they'll be date related, but you can extrapolate the same concepts to other dimensions as well. Finally, we're going to create a PivotTable to review module results, much as we've done previously and will do in future modules.

Build a Practical PowerPivot Application - Part 2
Pragmatic Self-Service BI with PowerPivot for Excel. I'm Bill Pearson, and this is Build a Practical PowerPivot Application - Part 2. Objectives. We'll continue the end-to-end creation of a practical PowerPivot application that we began in the last module by becoming familiar with several basic steps and continuing to generate support for a working reporting solution. We'll continue to enhance the PowerPivot data structure by adding further support logic to the model. We'll create PivotTables from which to review results and continue operations much as we've done in previous modules, and we'll add Time Intelligence support measures.

Practical PowerPivot Analysis and Reporting with PivotTables
Pragmatic Self-Service BI with PowerPivot for Excel. I'm Bill Pearson, and this is Practical PowerPivot Analysis and Reporting with PivotTables. Objectives. Describe the PivotTable types and contrast each with the PowerPivot PivotTable. Understand analysis and reporting in the PowerPivot PivotTable with diverse data sources. Create a PivotTable atop PowerPivot and access PowerPivot calculated columns. Create calculated measures within the PivotTable, working further with DAX functions. Discuss custom sorting and aggregation within the PivotTable. Construct a simple dashboard within the Excel workbook. Save and reuse PivotTable components. Introduce the concept of evaluation context. And gain exposure to PivotTable Key Performance Indicators, or KPIs.