Skip to main content
Power Pivot and Power Query Essentials

Developing and Visualizing Your Data Model

If your data contains dates, you have the ability to explore the journey it has taken over time. Power Pivot simplifies this process for you. In this course, you’ll learn how to use date tables and hierarchies for time-based analysis.

Advanced        11 Lessons        120 Minutes        CPD Credits
Start Today

About This Course

Now that you’ve learnt the basics of Power Pivot, it’s time to dig a little deeper. Here, you’ll learn how to use the tool to date and display your data.

Across 11 lessons, you’ll learn what date tables are, why they are needed and how to add them to Power Pivot. You’ll also learn how to visualise your geographic data using 3D Maps.

By the end of this course, you’ll have a clearer understanding of the insights you can get from your data through time-based analysis and visualisation.

Start Today

Learning Outcomes

  • Add a date table to the Power Pivot data model
  • Create and use hierarchies
  • Modify the sort order of variables
  • Create KPIs
  • Format the Power Pivot data model
  • Visualize geographic data using 3D Maps


1. Adding a Date Table
2. Creating and Using Hierarchies
3. Modifying the Sort Order
4. Creating a KPI
5. Formatting the Data Model
6. Visualizing Geographic Data

Read More

7. Map Formatting and Features
8. Creating Tours
9. Introduction to Power View
10. Creating a Power View Report
11. Filters and Interactions
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world