Instructor for this course
more

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: July 11, 2020

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 .
Course Syllabus
INTRODUCTION AND OVERVIEW
  0:28Introduction to Power Pivot: Big Data Analysis Made Easy
  3:34Background-Data Analysis Challenges
  1:05Instructor Introduction
  0:34Course Purpose
  5:41Introduction to Power Pivot
Intermediate: Integration in Power Pivot
  4:16Mapping-Part 1
  4:25Mapping-Part 2
  1:34Table Names
  3:47Bonus Relationship
  2:13Dashboard Without Using DAX Formula
Advanced: 6 Essential DAX Formulas
  3:39DAX Formula - Part 1
  3:42DAX Formula - Part 2
  5:05DAX Formula - Part 3
  6:57DAX Formula - Part 4
Advanced: Best Practices In Power Pivot Modelling
  5:01Best Practices: Part 1
  2:42Best Practices: Part 2
  4:16Dashboard
Wrap Up
  1:09Takeaways
  0:51Next Course
CONTINUOUS PLAY
  1:01:00Power Pivot: Big Data Analysis Made Easy
SUPPORTING MATERIAL
  PDFSlides: Power Pivot: Big Data Analysis Made Easy
  PDFPower Pivot: Big Data Analysis Made Easy Glossary/ Index
  XLSXWorkbook: Session 3 - Data
  XLSXWorkbook: Session 3 - Power Pivot (Practice)
  XLSXWorkbook: Session 3 - Power Pivot (Answer)
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM