Description

The course is presented in four parts.

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

• 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
• Power Pivot can combine all data sources into one pivot table. So no more VLOOKUP()
• A plethora of DAX formulas in Power Pivot. Plus the formulas can be re-used!

Second: To demonstrate basic maneuvers on how to:

• Map all dimension tables and fact tables together, and
• 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:

• CALCULATE
• SUMX
• RELATED
• SAMEPERIODLASTYEAR

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

• Use Measures (or Calculated Fields) over Calculated Column in order to
• Table naming conventions, and
• DAX format

Course Key Concept: Power Pivot, Calculated Column, Calculated Field, Measures, DAX formulas, Data Analysis Expressions, Dimension table, Fact table.