What will you do at the end of this Excel Power Pivot course?

Excel Power Pivot

Excel Power Pivot Course Program:

  • Use the Excel Power Pivot interface
  • Set up relationships between data
  • Insert calculations
  • Understand the specifications of the Data Analysis eXpressions (DAX) language.
  • The Power View environment
  • The Power Map environment

Recipients

The Excel Power Pivot course is for people who are interested in analyzing how data is processed on a daily basis into accurate information in Excel that is available to the resources that need it. Business Intelligence solutions are the key to analyzing financial, operational, administrative, personal data, and leverage it for effective decision-making.

Prerequisites

Good Excel & database knowledge are needed for this Excel Power Pivot course

Excel course content

  • Introduction to Excel Power Pivot,
  • Data transformation (power query)
  • Data structures
  • The basics of DAX language
  • Techniques and how to find and load data
  • Data modeling (Excel Power Pivot)
  • Creating table relationships
  • Building the Excel Power Pivot Model
  • Preparing the Excel Power Pivot Model for PowerView
  • PowerView reporting
  • Power Maps

Teacher

Content expert.

Certificate issued

Frequency certificate.

Request term

The date to define.

Details

9 hours, divided into 3 meetings of 3 hours

To be defined

See all Excel courses

Sign up for the Excel Power Pivot course

Payment will take place in the first lesson

Only 165 euros

For 3 meetings for a total of 9 hours

From 4 subscribers

The Excel Power Pivot course will start when the minimum number of subscribers is reached

Excel Power Pivot

Our Certifications