Class Outline

Power Pivot is a one-day instructor led course covering the Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can combine large volumes of data from various sources, perform information analysis rapidly, and share insights easily. In both Excel and in Power Pivot, you can create a Data Model, a collection of tables with relationships. The data model you see in a workbook in Excel is the same data model you see in the Power Pivot window. Any data you import into Excel is available in Power Pivot, and vice versa.

The training covers these topics:

The Power Pivot Data Model

  • Adding the Power Pivot Add
  • Importing Data from an Access Database
  • Importing Static Data from an Excel Workbook
  • Importing Linked Data from an Excel Workbook

Relationships Between Data Tables

  • Viewing Database Relationships
  • Creating Relationships with an Excel Imported File
  • Creating Hierarchies
  • Creating a PivotTable that Uses a Hierarchy

Shaping the Data Model with Data Analysis Expressions Functions (DAX)

  • Building a Calculated Column
  • Creating Measures
  • Testing our Calculations
  • Related() Function
  • RelatedTable() Function
  • Count() Function
  • Year() Function
  • Date() Function
  • Calculate() Function
  • All() Function

Time Intelligence

  • Creating a Date Table
  • Relating a Date Table to the Data Model
  • Creating Time-Intelligence Functions