__STYLES__

/

/

Learn Power Query, Power Pivot & DAX in 15 MINUTES

Learn Power Query, Power Pivot & DAX in 15 MINUTES

MAVEN CRASH COURSE

MAVEN CRASH COURSE

MAVEN CRASH COURSE

Learn Power Query, Power Pivot & DAX in 15 MINUTES

Learn Power Query, Power Pivot & DAX in 15 MINUTES

Learn Power Query, Power Pivot & DAX in 15 MINUTES

Chris Dutton

Excel

15 Min

Advanced

You’ve just been hired as a Data Analyst for Maven Electronics, a global electronics retailer.

It’s 4:00pm on a Friday when you receive an urgent email from the VP of Sales, asking you to build a brand new Excel report for regional sales managers. To make matters worse, the data is over the place – SQL servers, CSV files, even static PDFs – and she needs it first thing Monday morning. Yikes 😬

In this hands-on demo, Maven Analytics Founder and Lead Instructor Chris Dutton walks through this business case while showcasing the power of modern Excel tools like Power Query, Power Pivot and DAX.

You’ll start by using Power Query to extract, transform, and load data from external sources like SQL databases and CSV files.

Next you’ll build a relational model to join the tables without writing a single formula, conduct some exploratory analysis using Power Pivot, and define calculated measures with Data Analysis Expressions (DAX).

Finally you’ll use Pivot Charts and slicers to design a simple interactive report that the sales managers can use to analyze revenue trends and product performance.

All in a matter of minutes 💪

Microsoft Excel is an incredibly powerful data analytics platform, yet less than 1% of users know how to leverage its most powerful business intelligence tools.

These skills will not only allow you to work smarter and faster in Excel, but also help you build foundational database and ETL skills that can easily be applied to tools like SQL or Power BI.

Course Outline

Intro

00:00

Project Brief

00:34

Dataset Review

01:05

Connecting data with Power Query

01:45

Connecting to a SQL Database

02:16

Connecting to a CSV File

04:39

Connecting to a PDF

05:53

Creating a Calendar Table

07:26

Building a Relational Data Model

08:52

Exploring Data with Power Pivot

10:20

Calculating Measures with DAX

11:20

Calculating Total Orders with DISTINCTCOUNT

12:03

Calculating Total Revenue with SUMX

12:44

Building an Interactive Excel Report

14:10

Project Recap & Free Resources

16:45

Course Outline

Intro

00:00

Project Brief

00:34

Dataset Review

01:05

Connecting data with Power Query

01:45

Connecting to a SQL Database

02:16

Connecting to a CSV File

04:39

Connecting to a PDF

05:53

Creating a Calendar Table

07:26

Building a Relational Data Model

08:52

Exploring Data with Power Pivot

10:20

Calculating Measures with DAX

11:20

Calculating Total Orders with DISTINCTCOUNT

12:03

Calculating Total Revenue with SUMX

12:44

Building an Interactive Excel Report

14:10

Project Recap & Free Resources

16:45

Course Outline

Intro

00:00

Project Brief

00:34

Dataset Review

01:05

Connecting data with Power Query

01:45

Connecting to a SQL Database

02:16

Connecting to a CSV File

04:39

Connecting to a PDF

05:53

Creating a Calendar Table

07:26

Building a Relational Data Model

08:52

Exploring Data with Power Pivot

10:20

Calculating Measures with DAX

11:20

Calculating Total Orders with DISTINCTCOUNT

12:03

Calculating Total Revenue with SUMX

12:44

Building an Interactive Excel Report

14:10

Project Recap & Free Resources

16:45

About your instructor

About your instructor

Chris Dutton

Founder & CPO

Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.

Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.