Microsoft Excel - Power Pivot

Enroll for our 2-day Microsoft Excel - Power Pivot from Koenig Solutions. In this course you will learn how to perform powerhouse data analysis and modeling to make intelligent business decisions through Microsoft PowerPivot. Microsoft PowerPivot is an add on for Excel that provides Business Intelligence functionality & reporting within the familiar environment of Excel.

The course is designed for Excel 2016, 2019 and Microsoft 365 (Office 365), so you can choose the version that works best for you.

Target Audience:

The training is Intended for data analysts, financial analysts, business analysts, managers, and anyone who wants to harness Excel's business intelligence capabilities.

Learning Objectives:

After completing this course, you will be able to:

• How to get data and transform it into useful tables.
• How to build a proper dimensional model in Excel, by linking multiple tables together in order to solve common real-world problems.
• Write your own custom calculations for pivot tables using DAX (Data Analysis Expressions), Power Pivot’s formula language.
• How to build amazing reports.