TRAINING COURSE OVERVIEW
Power Pivot is a powerful data analysis and data modeling tool in Excel. In this course, you will learn how to use Power Pivot to import data from various sources, create relationships between tables, perform calculations using DAX formulas, work with dates, time intelligence, hierarchies, perspectives, and more. The Power Pivot training course will also teach some advanced topics and tips for optimizing your data model, using Power Query, creating KPIs, troubleshooting errors, and creating visualizations using Power View. By the end of this Anderson training course, you will be able to use Power Pivot confidently and efficiently for your own data analysis needs.
This Anderson training course will feature:
- Data modeling
- Data analysis
- Star and snow flake model
- Creating measures and KPIs
- Essential DAX formulae
TRAINING COURSE OBJECTIVES
By the end of this Anderson training course, participants will be able to:
- To learn the basics of Power Pivot and how it can enhance data analysis in Excel
- to create, manage, and refine data models using Power Pivot
- To learn how to use DAX formulas to perform calculations and analysis on the data model
- To learn how to work with dates, time intelligence, hierarchies, and perspectives in Power Pivot
- To learn some advanced topics and tips for using Power Pivot effectively
LEARNING METHODS
This Anderson training course will utilise a variety of proven adult learning techniques to ensure maximum understanding, comprehension and retention of the information presented. This includes presentation, workshops, question and answer sessions.