The course is presented in four parts.

First, brief introduction to Power Pivot and discuss reasons it has become more versatile than the conventional pivot table:

o Excel spreadsheet has limit of 1 million rows, while Power Pivot can connect to over 1 million rows of data. So no limit on the data sources

o Power Pivot can combine all data sources into one pivot table. So no more VLOOKUP()

o A plethora of DAX formulas in Power Pivot. Plus the formulas can be re-used!

Second part is to demonstrate basic maneuvers on how to:

o map all dimension tables and fact tables together, and

o incorporate data from ALL sources into 1 pivot table, and

Third, we demonstrate 6 fundamental DAX formulas in Power Pivot to get you started in building advanced models for effective analytics, including:

o CALCULATE

o SUMX

o RELATED

o SAMEPERIODLASTYEAR

Last, we culminate the webinar with the best practices in Power Pivot modeling, including:

o Use Measures (or Calculated Fields) over Calculated Column in order to

o Table naming conventions, and

o DAX format

Course Search Keywords

- Power Pivot

- Calculated Column

- Calculated Field

- Measures

- DAX formulas

- Data Analysis Expressions

- Dimension table

- Fact table

Prerequisites and Advanced Preparation

● Basic Excel knowledge

● Example: be able to open one Excel file and add a new sheet, etc.

Learning Objectives

● Discover Power Pivot as the big data analysis tool

● Identify the best practices in Power Pivot modeling

● Recognize Power Pivot’s essential steps in relationship and integration

● Discover 6 essential DAX formulas to get you started in Power Pivot formula writing

● Explore differences between a calculated column and a calculate field