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 Basic 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 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.
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.
Get familiar how to gather and analyse big data in a fast pace. Connecting all your data and transform to a consistent dataset. Get familiar how to share this with your stakeholders.
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.
Number of days: 2 (evenings)
Investment: €449 (ex VAT)
Apply now to secure one of the 8 seats!