Power Pivot: Unlock the Potential
of Your Data with Excel

This Power Pivot training course offers an in-depth exploration of Excel’s powerful data analysis and modeling capabilities. You will learn how to import data from various sources, establish table relationships, and execute advanced calculations using DAX formulas. The course also covers key features such as time intelligence, hierarchical structures, and perspectives. Additionally, you will gain insights into advanced topics like optimizing data models, using Power Query, creating KPIs, troubleshooting issues, and designing visualizations with Power View. By the end of the course, you will be confident in using Power Pivot for your data analysis projects.

This Anderson training course will feature:

• Data modeling
• Data analysis
• Star and snow flake model
• Creating measures and KPIs
• Essential DAX formulae

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

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.

• What is Power Pivot and why use it?
• How to enable and start Power Pivot in Excel
• How to create a data model from multiple sources
• How to manage and view data in the Power Pivot window
• How to create relationships between tables
• How to use the diagram view to visualize the data model
• Exercises and examples

• Calculated columns and calculated fields (measures)
• When to use them and how to create them
• What is DAX and how to write basic formulas
• How to use common DAX functions and operators
• How to understand and use context and filter in DAX
• Exercises and examples

• What are date tables and why are they important?
• How to create and use date tables in Power Pivot
• How to use time intelligence functions in DAX
• How to filter and compare data by dates
• How to create dynamic date calculations
• Exercises and examples

• What are hierarchies and how to create them in Power Pivot
• How to use hierarchies in PivotTables and PivotCharts
• How to drill up and down in hierarchies
• What are perspectives and how to create them in Power Pivot
• Using perspectives to focus on specific aspects of the data model
• Exercises and examples

• How to optimize the data model for performance and memory efficiency
• Power Query (Get & Transform) to import and transform data for Power Pivot
• How to create key performance indicators (KPIs) in Power Pivot
• How to troubleshoot common errors and issues in Power Pivot
• Interactive visualizations of the data model
• Tips and best practices for working with Power Pivot

Anderson Certificate of Completion will be provided to delegates who attend and complete the course