Developing and visualising your data model


In this course, we’ll introduce some of the more advanced concepts associated with Excel’s data model. We’ll look at simple tools like KPIs, and more advanced tools like 3D Maps and Power View, all of which allow you to create compelling visuals using the Data Model. You’ll apply key concepts through case-study style learning, with concise lessons & applied assessments.  Created & customized for Chartered Accountants Ireland by

Venue details:  
Online EU, ,
Start date & time:  
01 January 2021 00:00
End date & time:  
01 January 2022 00:00
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00 Training Tickets accepted
CPD hours:  
Speaker details
No speakers have been associated with this event.


Product type:  
CPD online course
Kubicle, Technology and data

Who Should Attend?

This is an intermediate course, and is suited to learners with a basic knowledge of the Excel Data Model, also known as Power Pivot. No knowledge of 3D Maps or Power View is required. This course will be of interest to any business professionals, such as accountants, management consultants and analysts.

Course Overview

This Kubicle course contains 11 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Adding a Date Table
  • Creating and Using Hierarchies
  • Modifying the Sort Order
  • Creating a KPI
  • Formatting the Data Model
  • Visualizing Geographic Data
  • Map Formatting and Features
  • Creating Tours
  • Introduction to Power View
  • Creating a Power View Report
  • Filters and Interactions

Key Outcomes

Once you’ve completed this course, you’ll understand how to create compelling visualizations using the Excel Data Model. You’ll have a wider understanding of how to use the Data Model itself, and understand how to use Excel tools that use the Data Model, like 3D Maps and Power View. By applying the skills you’ll learn in this course, you’ll be able to generate insightful visualizations using the Excel Data Model, improving your ability to use Excel as an analytics tool.