Booking Information
Once you have booked your course, you will receive a confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland Portal within the Kubicle site.
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.
Contact us
If you have any questions regarding this or any other CPD course or requirements, please feel free to contact the team here or call us at (+353) 01 523 3930
Note for Legacy CPA Members
Members who joined Chartered Accountants Ireland following1 September 2024, please continue to book on the CPA Portal here to ensure you receive your member discount.
LOADING...