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.
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.
9 Reviews (61 ratings)
Reviews
Prerequisites
Basic Excel knowledge; be able to open one Excel file and add a new sheet, etc.