Course
|
Excel

Developing and Visualizing Your Data Model

In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also look at options for displaying your data that go beyond Pivot Tables, such as Power Maps and Power View.
2 HOURS
Advanced
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Add a date table to the Power Pivot data model
Create and use hierarchies
Modify the sort order of variables
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Excel

Developing and Visualizing Your Data Model

In our second course on Power Pivot, we will look at more of the important features of Power Pivot, such as date tables and hierarchies. We will also look at options for displaying your data that go beyond Pivot Tables, such as Power Maps and Power View.
2 HOURS
Advanced
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Add a date table to the Power Pivot data model
Create and use hierarchies
Modify the sort order of variables
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

11 Lessons
Adding a Date Table
6 MINS
LESSON
Adding a Date Table
Exercise

When conducting time based analysis in Power Pivot, you need to use a date table. We will learn what date tables are, why they are needed and how to add them to Power Pivot.

Creating and Using Hierarchies
5 MINS
LESSON
Creating and Using Hierarchies
Exercise

When you have a group of fields that form a logical group, you can create a hierarchy, which allows you to add and analyse the fields together in Pivot Tables.

Modifying the Sort Order
3 MINS
LESSON
Modifying the Sort Order
Exercise

Sometimes, Power Pivot will sort data in a way you don't want. In this lesson, we will see how to use another column to sort your data the way you want it.

Creating a KPI
5 MINS
LESSON
Creating a KPI
Exercise

Key Performance Indicators, or KPIs, let you create a visual comparison between a measure and its target, which you can then add to a Pivot Table.

Formatting the Data Model
5 MINS
LESSON
Formatting the Data Model
Exercise

In this lesson, we will look at various things you can do to improve your data model. We will look at column types and formatting, as well as how you can hide columns or tables from the data model.

Visualizing Geographic Data
4 MINS
LESSON
Visualizing Geographic Data
Exercise

3D Maps allows you to create appealing maps easily. In this lesson, we will introduce 3D Maps and create our first map using the tool.

Map Formatting and Features
5 MINS
LESSON
Map Formatting and Features
Exercise

In this lesson, we will continue looking at 3D Maps. We will see how you can change the type of chart that is plotted, and see how you can add filters to your map.

Creating Tours
4 MINS
LESSON
Creating Tours
Exercise

Having created a few individual scenes in 3D Maps, we will now see how to turn multiple scenes into an appealing video tour.

Introduction to Power View
5 MINS
LESSON
Introduction to Power View
Exercise

Power View is a visualisation tool introduced in Excel 2013, allowing you to create sheets containing multiple charts and tables. We will create our first Power View sheet in this lesson.

Creating a Power View Report
3 MINS
LESSON
Creating a Power View Report
Exercise

Power View sheets can contain several different chart types. In this lesson, we will add more charts to our Power View sheet from the previous lesson.

Filters and Interactions
5 MINS
LESSON
Filters and Interactions
Exercise

There are many ways you can filter Power View visualisations. In this lesson, we will see filters, slicers and interactions, where one chart is used to filter other charts.

LESSON
Exercise

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo