Developing and Visualizing Your Data Model
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Adding a Date Table
Adding a Date Table
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
Creating and Using Hierarchies
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
Modifying the Sort Order
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
Creating a KPI
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
Formatting the Data Model
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
Visualizing Geographic Data
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
Map Formatting and Features
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
Creating Tours
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
Introduction to Power View
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
Creating a Power View Report
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
Filters and Interactions
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.
