1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
Excel Business Intelligence: Power Pivot, DAX and Data Modeling Preview

Excel Business Intelligence: Power Pivot, DAX and Data Modeling

With Maven Analytics and Chris Dutton Liked by 387 users
Duration: 6h 56m Skill level: Intermediate Released: 7/15/2024

Start my 1-month free trial Buy for my team

Course details

It's time to get up to speed with Microsoft Excel's powerful trio of business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're serious about a successful career in business intelligence, these skills are essential to master. This project-based course is designed to guide you through the entire business intelligence workflow from start to finish, including data prep, modeling, analysis, and visualization. Join instructor Chris Dutton as he demonstrates the basics of loading and transforming raw CSV files with Power Query, building a relational data model from scratch, and exploring and analyzing your model using Power Pivot and DAX measures. Along the way, you’ll practice applying your skills with hands-on demos and datasets from a fictional supermarket chain.

Note: This course was created by Chris Dutton and Maven Analytics. We are pleased to host this training in our library.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructors

Learner reviews

4.9 out of 5

410 ratings
  • 5 star
    Current value: 366 89%
  • 4 star
    Current value: 42 10%
  • 3 star
    Current value: 2 <1%
  • 2 star
    Current value: 0 0%
  • 1 star
    Current value: 0 0%
  • Kim Munro Kim Munro

    Kim Munro

    Commercial Finance Analyst

    5/5 April 12, 2025
    Highly recommend this content. Very informative and easy to follow
    Helpful · Report
  • Joel Acker Joel Acker

    Joel Acker

    FP&A + Data Analytics + Accounting | eCommerce • Digital Publishing • Consumer Products Licensing

    5/5 April 11, 2025
    It's a very good course for people who already have some familiarity with Excel and pivot tables.
    Helpful · Report
  • Diogo Martins Diogo Martins

    Diogo Martins

    Sr Specialist Product Supply Interface

    5/5 April 2, 2025
    Highly recommend this course, Chris does an amazing job to both explain the theory and show practical examples that are easy to understand for beginners.
    Helpful · Report

Contents

What’s included

  • Practice while you learn 2 exercise files
  • Test your knowledge 5 quizzes
  • Learn on the go Access on tablet and phone
  • Stay up to date Continuing Education Units

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.

Download on the App Store Get it on Google Play