Excel – Power Pivot

Simplify Complex Reports with Data Modeling

(1 day)

 

Hands-On Workshop
  • Participants must bring their own laptop.
Learning Outcomes
  • Transform data with Power Query Editor
  • Model Data in Power Pivot Environment
  • Create Measures and Calculated Columns with DAX functions
  • Build interactive reports with charts, tables and slicers
Training Location

123 Slater Street, Ottawa ON K1P 5G4

 

Available for private groups : inquire.

This product is currently out of stock and unavailable.

Create data models and build powerful analyses. Automate your report update process using the Power Query Editor. Combine multiple data sources in an interactive report with Power Pivot.
Target Audience

Analysts, Accountants, Report Builders, Data Analysis Professionals

 

Bring Your Own Device

Each participant must bring his/her laptop with Microsoft Excel application (version 2013 or greater).

Or add Laptop Rental to your cart.

 

Microsoft Certified Instructor

Our Ottawa-based instructor is certified by Microsoft, as a skilled professional in Business Intelligence Reporting.

 

Quality Service

Workshops are limited to 10 attendees to address each participants questions and requests.

Training is delivered in a modern environment: offering a comfortable and bright workplace, centrally located.

 

Training Schedule

Training takes place from 9 a.m. to 4 p.m.

Learning Outcomes
  • Transform data with Power Query Editor
  • Model Data in Power Pivot environment
  • Create Measures and Calculated Columns with DAX functions
  • Build interactive reports with charts, tables and slicers

 

Topics

1. Master the basic workflow

  • Import data from different sources
  • Transform data in Power Query
  • Load data to Data Model
  • Define data default format setting in Power Pivot environment
  • Create relationships between data tables in Power Pivot
  • Create a PivotTable
  • Create a PivotChart
  • Create a slicer

2. Review the report’s update process

  • Periodic Update process: click Refresh All
  • Cyclical Update process: edit Data Source Settings…

3. Add complexity to the basic workflow

  • View the impact of wrong relationships on a Pivot Table
  • Understand the concept of context in a Pivot Table or PivotChart
  • Create inactive relationships between data tables in Power Pivot
  • Create Measures
  • Use DAX functions : COUNT, SUM, DIVIDE AVERAGEX, CALCULATE and USERELATIONSHIP
  • Edit a Measure
  • Create a Pivot Table to visualize a measure
  • Create Calculated Columns in Power Pivot environment
  • Use a calculated column in a Pivot Table as a Row field
  • Format a report
  • Name charts and tables

You may also like…

Laptop Rental

Laptop rental for the entire training duration (1, 2 or 3 days).



View Details