What You Need to Know Before
You Start
Starts 7 June 2025 19:58
Ends 7 June 2025
Power Pivot Fundamentals
2019 Courses
Not Specified
Optional upgrade avallable
All Levels
Progress at your own speed
Free
Optional upgrade avallable
Overview
This course provides step-by-step instructions for setting up a business intelligence dashboard in Excel using the Power Pivot add-on. You’ll learn the key functions and best practices for creating 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 have the skills needed to create your own dashboards in Excel—enabling you to 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
University:
Provider:
Coursera
Categories:
Data Analysis Courses, Business Intelligence Courses, Data Visualization Courses, Microsoft PowerApps Courses
Taught by
Sebastian Taylor and Joseph Yeates
Subjects
