Power Pivot Workshop Full
Online (America's Time)

Power Pivot Workshop is an intensive course that enable Excel users to master Power Pivot.

Attending this course you will learn how to create a data model in Power Pivot, how to import data, create relationships, use PivotTable and Power View to navigate data, how to create both simple and more advanced calculations in DAX.

You will receive exercises to complete after each online session. Please, consider other 2 hours in your schedule after each day session if you want to complete exercises. Our teachers will answer to your questions during online sessions or by mail.

Course outline:

  • Introduction to Power Pivot and Data Models in Excel 2013
  • Data loading techniques with different sources: OLTP, DWH, Microsoft SQL Server, Microsoft Access and others
  • Data Modeling basics for building Power Pivot data models
  • Calendar computation and data modeling best practices
  • SharePoint integration
  • Creating Power View reports
  • Shaping Reports
  • Evaluation Contexts and CALCULATE (FULL edition)
  • Using DAX as a Query Language (FULL edition)
  • Advanced DAX techniques (FULL edition)
  • DAX Patterns (FULL edition)

FULL edition specific contents are in bold.
All other contents are in common with the BASIC edition.

This course is intended for both Excel 2010 and Excel 2013 users.
PowerView is a feature available only in Excel 2013.

» Course outline (PDF)

The workshop online will be delivered in a LiveMeeting session.
The number of attendees is limited in order to improve interaction.

Course time
Your time
UTC04:00pm » 08:00pm
Eastern Time (US & Canada)11:00am » 03:00pm
Central Time (US & Canada)10:00am » 02:00pm
Mountain Time (US & Canada)09:00am » 01:00pm
Pacific Time (US & Canada)08:00am » 12:00pm
Other zones » Show all
After each session, plan to time to complete exercises (about 2 hours each day). You can also do exercises later after the course, if you prefer.