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.
Last updated/reviewed: March 27, 2024
9 Reviews (61 ratings)

Reviews

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

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

5
Member's Profile
It is very useful course, the explanations are very clear. The instructor is very experienced in this power pivot where the learner can really benefit from his explaination.

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

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

4
Member's Profile
Relationship: Mapping all dimension tables and fact tables together

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

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

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

Prerequisites
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 AND OVERVIEW
  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
  Dashboard4:16
Wrap Up
  Takeaways1:09
  Next Course0:51
CONTINUOUS PLAY
  Power Pivot: Big Data Analysis Made Easy1:01:00
SUPPORTING MATERIAL
  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
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam