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:

  • SUMX

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.
Last updated/reviewed: August 13, 2023
7 Reviews (56 ratings)


Anonymous Author
Great course. Highly recommended. This is not my first course with Lenny. However, there was an issue with the Final Exam Question 3. I had one question wrong, but turned out I selected the right answer "DATESYTD()" yet the exam result appeared that I chose "RELATED()" which is a wrong answer.

Member's Profile
Great course that teaches several Power Pivot concepts and best practices using a single real-world example throughout the lessons. Particularly helpful as a transition from traditional Excel formulas and pivot tables to the DAX language used in Power Pivot and Power BI.

Anonymous Author
This course answers many questions excel users have when dealing with data sets larger than 1,000,000 rows.

Member's Profile
Lenny Wu's material and practice data is a step above most online courses

Anonymous Author
Very useful content. I need to put this to use as soon as possible

Anonymous Author
Informative but very hard to stay concentrated on the subject.

Anonymous Author
Thank you, Lenny for another great course! Well done :-)

Course Complexity: Intermediate

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

Education Provider Information
Company: Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact: For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Instructor for this course
Course Syllabus
  Introduction to Power Pivot: Big Data Analysis Made Easy0:28
  Background-Data Analysis Challenges3:34
  Instructor Introduction1:05
  Course Purpose0:34
  Introduction to Power Pivot5:41
Intermediate: Integration in Power Pivot
  Mapping-Part 14:16
  Mapping-Part 24:25
  Table Names1:34
  Bonus Relationship3:47
  Dashboard Without Using DAX Formula2:13
Advanced: 6 Essential DAX Formulas
  DAX Formula - Part 13:39
  DAX Formula - Part 23:42
  DAX Formula - Part 35:05
  DAX Formula - Part 46:57
Advanced: Best Practices In Power Pivot Modelling
  Best Practices: Part 15:01
  Best Practices: Part 22:42
Wrap Up
  Next Course0:51
  Power Pivot: Big Data Analysis Made Easy1:01:00
  Slides: Power Pivot: Big Data Analysis Made EasyPDF
  Power Pivot: Big Data Analysis Made Easy Glossary/ IndexPDF
  Workbook: Session 3 - DataXLSX
  Workbook: Session 3 - Power Pivot (Practice)XLSX
  Workbook: Session 3 - Power Pivot (Answer)XLSX