Power Pivot Workshop

Perth, AU

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.

Our trainers will assist you during hands-on-labs, helping you creating your first Power Pivot models and reports.

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 live edition)
  • Using DAX as a Query Language (FULL live edition)
  • Advanced DAX techniques (FULL live edition)
  • DAX Patterns (FULL live edition)

FULL edition specific contents are in bold.
All other contents are in common with the BASIC live 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 course is an intensive and interactive format. Each attendee can bring his/her laptop, but it is not required. There will be "group exercises" driven by the trainers using the wall projector.

Course location

NEC IT Solutions
Level 2 503 Murray Street - Perth WA 6000
Perth, AU
Get directions

Course Book

Each participant will receive a copy of:
Microsoft Excel 2013: Building Data Models with PowerPivot

Marco Russo & Alberto Ferrari
Microsoft Press