Power Pivot: Big Data Analysis Made Easy 1.5 CPE

The course is presented in four parts.

• 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.

Prerequisites

Basic Excel knowledge; be able to open one Excel file and add a new sheet, etc.

Learning Objective

• 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.

Last updated/reviewed: March 27, 2024