Loading...

Course Description

This course provides step-by-step instructions for how to set-up a business intelligence dashboard in Excel using the Power Pivot add-on. You’ll learn the key functions and best practices for setting-up a dashboard. As you progress through the course, you’ll apply everything you’ve learned to a hands-on example using data we provide. By the end of this course, you’ll walk away with everything you need to create your own dashboards in Excel—so you can analyze and present data, track KPIs, and make your data easily accessible.Upon completing this course, you will be able to:● Create a Power Pivot table by drawing data from several different tables● Develop simple calculated metrics with consistent formatting to be re-used across our dashboard● Assemble multiple pivot tables, charts, and dimensions into a dashboard● Apply DAX formatting language to create measures and columns that draw data from other tables● Manipulate context to calculate more advanced metrics● Utilize DAX Advanced Time Intelligence to create powerful period comparisons and KPIs
Loading...

Enroll Now - Select a section to enroll in

Section Title
Power Pivot Fundamentals
Language of Delivery
English
Section Schedule
Date and Time TBA
Course Fee(s)
Course Fee non-credit $49.00
Drop Request Deadline
TBD
Required fields are indicated by .