Power Pivot Workshop

– Online

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.

Topics

  • 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.

Power Pivot Outline (PDF)

Prerequisites

Looking for a course in classroom?

We bring our courses to you all over the world. Here are the current scheduled classroom events.
Please note that each course is taught exclusively by SQLBI trainers (no external trainers are involved).
Early Bird
Discount
Bundle
Discount
Video
Discount
Group
Discount
 Vienna (Wien), AT Jun 19-21
Vienna
 Amsterdam, NL Jun 26-28
Amsterdam
 Amsterdam, NL Jul 2-4
Amsterdam
Jul 5-6
Amsterdam
 Brisbane, AU Jul 18-20
Brisbane
 Sydney, AU Jul 24-26
Sydney
 Melbourne, AU Jul 31/Aug 2
Melbourne
 Sydney, AU Aug 7-9
Sydney
 Perth, AU Aug 20-22
Perth
 Toronto, ON, CA Sep 18-20
Toronto
 San Francisco, CA, US Oct 1-3
San Francisco
 Amsterdam, NL Oct 10-12
Amsterdam
 London, UK Oct 16-18
London
 Copenhagen, DK Oct 23-25
Copenhagen
 Boston, MA, US Oct 31/Nov 2
Boston
 London, UK Nov 20-22
London
 New York, NY, US Nov 28-30
New York
 Miami, FL, US Dec 3-5
Miami
Other locations On-Site On-Site On-Site On-Site On-Site