Power Pivot Workshop

Milano, IT

Sorry, this course is closed.

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

 By pressing the Notify button you are agree 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.

Power Pivot Workshop Full è un corso intensivo di 3 giorni pensato per gli utenti Excel che vogliono padroneggiare Power Pivot.

Partecipando al corso imparerai come creare un modello dati in Power Pivot, come importare, creare relazioni, usare le tabelle Pivot e PowerView per scorrere i dati, come creare semplici e complessi calcoli con DAX.

I nostri docenti ti assisteranno durante gli Hands-on-Lab, laboratori pratici nei quali potrai costruire i tuoi primi modelli e report con PowerPivot.

Scheda del corso:

  • 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
  • Using DAX as a Query Language
  • Advanced DAX techniques
  • DAX Patterns

Questo corso sarà completamente in ITALIANO.

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

Microsoft Italia Innovation Campus

Via Lombardia, 2/A-1 - Peschiera Borromeo
Milano, IT
View on Google Maps

Teaching this live event

Alberto Ferrari

Consultant & Mentor
Trainer for 107 other courses at SQLBI

Looking for another city?

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 in person (no external trainers are involved).
Early Bird
Discount
Bundle
Discount
Video
Discount
 Melbourne, VIC, AU Jul 23-25
Melbourne
 Sydney, NSW, AU Jul 30-Aug 1
Sydney
 Melbourne, VIC, AU Aug 6-8
Melbourne
 Perth, WA, AU Aug 14-16
Perth
 Chicago, IL, US Sep 17-19
Chicago
 Amsterdam, NL Oct 1-3
Amsterdam
 Denver, CO, US Oct 2-4
Denver
 Washington, DC, US Oct 8-10
Washington
 Copenhagen, DK Oct 22-24
Copenhagen
 San Francisco, CA, US Oct 30-Nov 1
San Francisco
 Toronto, ON, CA Nov 12-14
Toronto
 Amsterdam, NL Nov 26-28
Amsterdam
Other locations On-Site On-Site On-Site On-Site On-Site