Coursera

Power Pivot Fundamentals (Coursera)

Offered by Corporate Finance Institute,
Power Pivot Fundamentals (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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

This course is part of the Data Skills for Excel Professionals Specialization.

Syllabus

Course Orientation
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.

Module 1: A Basic Data Model
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.

Module 2: Basic Measures
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.

Module 3: Working with a Star Schema
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.

Module 4: From Number to Narratives
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.

Module 5: Extended Practice
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!

Course Conclusion
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. Continue your data analysis journey by earning the Excel Data Analysis specialization and consider expanding your DAX skills in our recommended next course. Reach out on LinkedIn—I'd love to hear about your data journey. Well done, and see you next time!

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Everyday Excel, Part 3 (Projects) (Coursera) Coursera
University of Colorado Boulder

Everyday Excel, Part 3 (Projects) (Coursera)

Computer Science

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, [Parts 1](https://www.mooc-list.com/course/everyday-excel-part-1-coursera) and [Parts 2](https://www.mooc-list.com/course/everyday-excel-part-2-coursera)". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways). Each learner must complete two easy projects (chosen from four), two intermediate projects (chosen from 4), and three main (more difficult) projects (chosen from 7).

Oct 19th 2026
5-12 Weeks
Computing Algorithms Spreadsheets
Details
Introduction to Computers and Office Productivity Software (Coursera) Coursera
The Hong Kong University of Science and Technology - HKUST

Introduction to Computers and Office Productivity Software (Coursera)

CS: Design & Product

In this course, you will learn the following essential computer skills for the digital age: major hardware components of a computer system; different types of software on a computer system; photo Editing using GIMP; and word processing applications, including MS Word, MS Excel, and MS PowerPoint.

Oct 26th 2026
5-12 Weeks
Computer Software Hardware
Details
Math for MBA and GMAT Prep (Coursera) Coursera
Emory University

Math for MBA and GMAT Prep (Coursera)

Business

This course gives participants a basic understanding of statistics as they apply in business situations. A fair share of students considering MBA programs come from backgrounds that do not include a large amount of training in mathematics and statistics. Often, students find themselves at a disadvantage when they apply for or enroll in MBA programs. This course will give you the tools to understand how these business statistics are calculated for navigating the built-in formulas that are included in Excel, but also how to apply these formulas in an range of business settings and situations.

Nov 2nd 2026
5-12 Weeks
Statistics Excel Statistical Analysis
Details
Business Analytics with Excel: Elementary to Advanced (Coursera) Coursera
Johns Hopkins University

Business Analytics with Excel: Elementary to Advanced (Coursera)

Business

A leader in a data driven world requires the knowledge of both data-related (statistical) methods and of appropriate models to use that data. This Business Analytics class focuses on the latter: it introduces students to analytical frameworks used for decision making though Excel modeling. These include Linear and Integer Optimization, Decision Analysis, and Risk modeling. For each methodology students are first exposed to the basic mechanics, and then apply the methodology to real-world business problems using Excel.

Oct 19th 2026
5-12 Weeks
Spreadsheets Excel Linear Programming
Details
Big Data Analysis Deep Dive (Coursera) Coursera
Alibaba Cloud Academy

Big Data Analysis Deep Dive (Coursera)

CS: Information & Technology

The job market for architects, engineers, and analytics professionals with Big Data expertise continues to increase. The Academy’s Big Data Career path focuses on the fundamental tools and techniques needed to pursue a career in Big Data. This course includes: data processing with python, writing and reading SQL queries, transmitting data with MaxCompute, analyzing data with Quick BI, using Hive, Hadoop, and spark on E-MapReduce, and how to visualize data with data dashboards. Work through our course material, learn different aspects of the Big Data field, and get certified as a Big Data Professional!

Oct 26th 2026
5-12 Weeks
Python SQL Big Data
Details
Excel Skills for Business: Essentials (Coursera) Coursera
Macquarie University

Excel Skills for Business: Essentials (Coursera)

Business

In this first course of the specialization Excel Skills for Business you will learn the Essentials of Microsoft Excel. Within six weeks, you will learn to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs.

Oct 19th 2026
5-12 Weeks
Spreadsheets Excel Graphs
Details
Data Visualization with R (Coursera) Coursera
IBM

Data Visualization with R (Coursera)

Statistics & Data Analysis Data Science

In this course, you will learn the Grammar of Graphics, a system for describing and building graphs, and how the ggplot2 data visualization package for R applies this concept to basic bar charts, histograms, pie charts, scatter plots, line plots, and box plots. You will also learn how to further customize your charts and plots using themes and other techniques. You will then learn how to use another data visualization package for R called Leaflet to create map plots, a unique way to plot data based on geolocation data. Finally, you will be introduced to creating interactive dashboards using the R Shiny package.

Oct 19th 2026
4 Weeks
Data Science Data Visualization R Programming
Details
From Excel to Power BI (Coursera) Coursera
Knowledge Accelerators

From Excel to Power BI (Coursera)

CS: Information & Technology

Are you using Excel to manage, analyze, and visualize your data? Would you like to do more? Perhaps you've considered Power BI as an alternative, but have been intimidated by the idea of working in an advanced environment. The fact is, many of the same tools and mechanisms exist across both these Microsoft products. This means Excel users are actually uniquely positioned to transition to data modeling and visualization in Power BI! Using methods that will feel familiar, you can learn to use Power BI to make data-driven business decisions using large volumes of data.

Nov 2nd 2026
1 Week
Excel Data Analysis Microsoft Excel
Details
Data Visualization in Excel (Coursera) Coursera
Macquarie University

Data Visualization in Excel (Coursera)

Business

In an age now driven by "big data", we need to cut through the noise and present key information in a way that can be quickly consumed and acted upon making data visualization an increasingly important skill. Visualizations need to not only present data in an easy to understand and attractive way, but they must also provide context for the data, tell a story, achieving that fine balance between form and function. Excel has many rivals in this space, but it is still an excellent choice, particularly if it's where your data resides. It offers a wealth of tools for creating visualizations other than charts and the chart options available are constantly increasing and improving, so the newer versions now include waterfall charts, sunburst diagrams and even map charts. But what sets Excel apart is its flexibility, it gives us total creative control over our designs so if needed we could produce our own animated custom chart to tell the right story for our data.

Oct 19th 2026
5-12 Weeks
Excel Big Data Microsoft Excel
Details
Excel Skills for Business: Advanced (Coursera) Coursera
Macquarie University

Excel Skills for Business: Advanced (Coursera)

Business

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading.

Oct 19th 2026
5-12 Weeks
Spreadsheets Excel Microsoft Excel
Details
Excel Time Series Models for Business Forecasting (Coursera) Coursera
Macquarie University

Excel Time Series Models for Business Forecasting (Coursera)

Business

This course explores different time series business forecasting methods. The course covers a variety of business forecasting methods for different types of components present in time series data — level, trending, and seasonal. We will learn about the theoretical methods and apply these methods to business data using Microsoft Excel.

Oct 19th 2026
5-12 Weeks
Excel Microsoft Excel Forecasting
Details