Power Pivot

About Power Pivot

In our Excel Power Pivot course you will learn to compose a PowerPivot model in Microsoft Excel and how to use it to draw up a report with pivot tables and pivot graphs. The information comes from various sources, such as from linked Excel tables, from text files or from databases. You will learn the difference between a flat database and a relational database and you will get to know the DAX functionality, which allows you to apply calculations to your data. You will also get acquainted with some DAX functions.

Why Power Pivot?

Power Pivot is an Excel add-in that enables you to create powerful data analyses and comprehensive data models. With Power Pivot you can quickly analyse big data from multiple sources and easily share insights. You can create your own data model via a collection of tables and link them together.

What can you expect?

In this Excel Power Pivot course you will learn to compose a Power Pivot model in Microsoft Excel and how to use it to draw up a report with pivot tables and pivot graphs. The information comes from various sources, such as linked Excel tables, from text files or from databases. You will learn the difference between a flat database and a relational database and you will get to know the DAX functionality, which allows you to apply calculations to your data. You will also get acquainted with some DAX functions.

Who?

BI consultants, analysts, power users, end users, IT professionals and advanced Excel users who want to be familiar with the possibilities that Power Pivot offers.

Goal

Get familiar with how to gather and analyse big data at a fast pace. Connecting all your data and transform to a consistent dataset. Get familiar with how to share this with your stakeholders.

Result

Capable to connect all your data and process it into valuable information. By creating relations you’ll discover additional patterns and add value to your reporting.

Course: Power Pivot
Number of days: 2 (evenings)
PE: 6
CPE: 7
Location: Amsterdam, Eindhoven, Utrecht, online
Rating: ★ ★ ★ ★ ☆

Inhouse training possible: Yes – more info

Dates

A new group has probably just started, the next start date will be announced as soon as possible. If interested please contact us at academy@staan.nl or 020 – 303 87 87

Investment: € 449 (ex VAT)

Apply now to secure one of the 8 seats!

Apply

or download brochure

Program Power Pivot

Differences Excel and Power Pivot data model
Data import and transformation
Create pivots
Specific calculations
Introduction DAX functionalities

Rating: 8,5

‘A course I have actually applied to my daily work projects. PowerPivot is the course you need if you are working with big data in various tables. This course improved my knowledge and efficiency in excel, as I discovered how to create your own data model. The topics are straight to the point and easy to understand. I recommend this course for anyone looking to expand their excel skills’.

SelcukFinancial Accountant

‘Processing large data sets, connecting data from different sources, and still only using the refresh button at month end. The PowerPivot course really showed me how I can built my reports more efficiently. If you want to spent more time on analyis instead of (re)building your reports at month end I really recommend this course’.

BenitoTreasury Project Manager

‘The training for Microsoft Power Pivot was very fantastic and helpful. I am now able to build relationships between different large Excel files and creating calculations. My work today is more effective than yesterday’.

AliBusiness Analyst