Power Pivot Fundamentals

This course is part of Data Skills for Excel Professionals Specialization

Instructor: CFI (Corporate Finance Institute)

Skills you'll gain

  •   Key Performance Indicators (KPIs)
  •   Data Analysis Expressions (DAX)
  •   Dashboard
  •   Data Integration
  •   Star Schema
  •   Pivot Tables And Charts
  •   Data Modeling
  •   Microsoft Excel
  •   Business Metrics
  •   Business Intelligence
  •   Competitive Analysis
  •   Data Storytelling
  • There are 7 modules in this course

    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

    Module 1: A Basic Data Model

    Module 2: Basic Measures

    Module 3: Working with a Star Schema

    Module 4: From Number to Narratives

    Module 5: Extended Practice

    Course Conclusion

    Explore more from Finance

    ©2025  ementorhub.com. All rights reserved