Close
Close

QUICK SEARCH
Search your Courses by Keywords


An intensive professional development training course on

Power Pivot:
Unlock the Potential
of Your Data with Excel

Why Choose this Training Course?

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 AZTech training course, you will be able to use Power Pivot confidently and efficiently for your own data analysis needs.

This training course will feature:

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

What are the Goals?

By the end of this AZTech 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

How will this Training Course be Presented?

This AZTech 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.

The Course Content

Day One: Introduction to Power Pivot

  • 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

Day Two: Working with Calculations and DAX

  • 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

Day Three: Working with Dates and Time Intelligence

  • 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

Day Four: Working with Hierarchies and Perspectives

  • 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

Day Five: Advanced Topics and Tips

  • 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

The Certificate

  • AZTech Certificate of Completion for delegates who attend and complete the training course

In Partnership With

DO YOU WANT TO
LEARN MORE ABOUT THIS COURSE?

Request for In-House Solutions
Request for
In-House Solutions
Request for More Details
Request for
More Details
Share this Course With a Colleague
Share this Course
With a Colleague
Request Brochure
Download the
Course Brochure

Send to Colleague

© 2023. Material published by Aztech shown here is copyrighted.

All rights reserved. Any unauthorized copying, distribution, use, dissemination, downloading, storing (in any medium), transmission, reproduction or reliance in whole or any part of this course outline is prohibited and will constitute an infringement of copyright.


Sending your message. Please wait...

Send Successfully

There was a problem sending your message. Please try again.

Please complete all the fields in the form before sending.

USE THE COURSE FINDER TO
BROWSE OVER 400 COURSES

Online Training

DISCOVER OUR
ONLINE TRAINING
COURSES

LinkedIn
Facebook
Twitter
WhatsApp
Email
Other