Corporate Finance Institute

Power Pivot Fundamentals

Sebastian Taylor

Instructor: Sebastian Taylor

Course

Gain insight into a topic and learn the fundamentals

Beginner level
No prior experience required
4 hours (approximately)
Flexible schedule
Learn at your own pace

Details to know

Earn a career certificate

Add to your LinkedIn profile

Recently updated!

February 2024

Assessments

4 assignments

Taught in English

Course

Gain insight into a topic and learn the fundamentals

Beginner level
No prior experience required
4 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your subject-matter expertise

This course is part of the Data Skills for Excel Professionals Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 7 modules in this course

In this module, you'll explore how Power Pivot transforms Microsoft Excel, bringing business intelligence and analysis capabilities to the forefront. Discover the key benefits, from creating pivot tables with multiple sources to performing powerful time period comparisons, and elevate your analysis skills to the next level with simple formulas and advanced functionalities.

What's included

4 videos1 reading

Dive into the world of data modeling as we guide you through the process of building a relational data model in Power Pivot. Unleash the power of new functionalities and learn to import, relate, summarize, and interact with your data using measures, tables, and slicers for enhanced Excel capabilities.

What's included

12 videos

Welcome to the next chapter of our Power Pivot Mastery course! Now that you've mastered data consolidation and interaction, this chapter delves into the world of DAX measures. Learn how to create metrics, leverage DAX as a powerful formula language, and unlock new possibilities for data aggregation and analysis in your Excel data model.

What's included

13 videos1 assignment

Welcome to our Advanced Power Pivot Techniques module! Building upon your understanding of the Power Pivot data model and DAX, explore how to efficiently aggregate and summarize data with reusable formulas. This chapter introduces the Star Schema data model, guiding you through expanding datasets, managing multiple dimension tables, and creating interactive dashboards with a logical flow. Learn the significance of the Star Schema, leverage timelines, pivot charts, and enhance data import efficiency by combining Power Query with Power Pivot for a cohesive and consistent dashboard experience.

What's included

21 videos1 assignment

In this module, explore the art of turning data into meaningful insights and compelling data stories. Learn to create advanced DAX measures, employ the CALCULATE function for percent of total calculations, delve into DAX Time Intelligence for year-over-year comparisons, and enhance dashboard aesthetics with conditional formatting, KPIs, and visual cues. Elevate your data presentation skills and gain a solid foundation for crafting professional-looking dashboards that communicate insights effectively.

What's included

13 videos

Welcome to the end-of-course exercise! Apply your skills to the Big Wings Airline case study, where you'll independently create a competitor analysis dashboard. Utilize your data modeling, metrics creation, and dashboard formatting knowledge to meet the provided requirements and communicate key insights effectively. Happy practicing!

What's included

2 videos

Congratulations on completing our Power Pivot course! You've mastered the art of building three insightful dashboards, creating data models, understanding DAX basics, and delving into time intelligence calculations.

What's included

1 video1 reading2 assignments

Instructor

Sebastian Taylor
Corporate Finance Institute
8 Courses2,446 learners

Offered by

Recommended if you're interested in Finance

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

New to Finance? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions