Power Pivot: Big Data Analysis Made Easy

Course Access: Lifetime
Take this Course
Course Overview

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.

Leave A Comment