Power Pivot Workshop

Charlotte, NC, US

Sorry, this course is closed.

Leave your email if you want to be notified when a new edition of Power Pivot Workshop is available in United States.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

 By pressing the Notify button you are agreeing to our Privacy Policy.

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

Location

Aloft Hotel

13139 Ballantyne Corporate Pl
Charlotte, NC, US
View on Google Maps

Teaching this course

SQLBI
Trainer for 76 other courses at SQLBI

Looking for another city?

We bring our classroom courses to you all over the world. Here are the current scheduled classroom courses.
Please note that each classroom course is taught exclusively by SQLBI trainers in person. No external trainers are involved.
 Phoenix (Tempe), AZ, US Feb 18-20
Phoenix
 Amsterdam, NL Mar 3-5
Amsterdam
 Houston, TX, US Mar 30-Apr 1
Houston
 New York City, NY, US Apr 8-10
New York City
 Copenhagen, DK May 5-7
Copenhagen
 Baltimore, MD, US May 27-29
Baltimore
 Zürich, CH Jun 10-12
Zürich
 Berlin, DE Jun 15-17
Berlin
 Amsterdam, NL Jun 30-Jul 2
Amsterdam
 Amsterdam, NL Jul 21-23
Amsterdam
Other locations On-Site On-Site On-Site