Your browser is not supported. Please download another browser to be able to use all of the Maven features.

Self-Paced Course

Power Query, Power Pivot & DAX

Build and analyze relational data models using Excel’s powerful trio of self-service BI tools: Power Query, Power Pivot & DAX.

Course Hours7.5 hours
Skills Learned
Data Prep
Data Analysis
Tools
Excel
Course Level
Intermediate
Credentials
Paths

Not Sure Which COURSE or PATH is right for you?

Take our customized survey to find the perfect courses & paths for your skill level and goals!

Course Description

It's time to introduce Excel's powerful trio of self-service BI tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're serious about business intelligence, these are essential skills to master.

This course takes a project-based approach, and is designed to guide you through the entire BI workflow from start to finish. Using data from a fictional supermarket chain, we'll load and transform raw CSV files with Power Query, build our own relational data model from scratch, and explore and analyze our model using Power Pivot and DAX expressions.

If you're ready to become an elite Excel user and take your analytics skills to the next level,** this is the course for you**.

Course Outline

WHO SHOULD TAKE THIS COURSE?

  • Excel users who are looking for an introduction to advanced analytics and data modeling tools, or preparing to transition into a business intelligence role

  • Analysts or BI professionals using Excel to analyze large datasets (>1mm rows), connect to external sources, or build relational data models

  • Anyone seeking to explore Excel's business intelligence capabilities

WHAT ARE THE COURSE REQUIREMENTS?

  • Microsoft Excel for PC/Windows, compatible with Power Query & Power Pivot (Power Pivot is currently unavailable in Excel for Mac)

  • Experience with Excel PivotTables and formulas is strongly recommended

Are you ready to become a DATA ROCKSTAR? Start learning today with your FREE 7-Day trial!

Every subscription includes access to the following course materials

  • Interactive Project files
  • Downloadable e-books
  • Graded quizzes and assessments
  • 1-on-1 Expert support
  • 100% satisfaction guarantee
  • Verified credentials & accredited badges
Sign Up Today

Ready to become a

data rockstar?

Sign up today for a 7-Day Free Trial and start learning today!

Sign Up for Free