Developing and visualising your data model

Summary

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 kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

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.