Microsoft Excel: Intro to Power Query, Power Pivot & DAX

Name: Microsoft Excel: Intro to Power Query, Power Pivot & DAX
Brand: Excel Maven
Price: 11.99 USD
Availability: Discontinued
Rating: 5 (1 reviews)

1 Review

7 Hours

$11.99$175.00

You save 93%

86 Lessons (7h)

Getting Started
Course Structure & Outline1:47
IMPORTANT: Versions & Compatibility3:15
Exploring the Course Project Files1:16
Setting Expectations1:53
Intro to "Power Excel"
The "Power Excel" Workflow3:50
"Best Thing to Happen to Excel in 20 Years"8:18
When to use Power Query & Power Pivot0:44
QUIZ: Intro to "Power Excel"
HOMEWORK: Intro to "Power Excel"
Power Query
Introduction0:27
Meet Power Query (aka "Get & Transform")2:40
The Query Editor3:17
Data Loading Options1:40
IMPORTANT: Regional Date Formatting
Basic Table Transformations8:06
Text-Specific Tools10:17
Number-Specific Tools7:41
Date-Specific Tools7:39
PRO TIP: Creating a Rolling Calendar5:02
Adding Index & Conditional Columns7:44
Grouping & Aggregating Data7:10
Pivoting & Unpivoting8:52
Modifying Workbook Queries4:18
Merging Queries7:43
Appending Queries5:49
Connecting to a Folder of Files9:32
Power Query Best Practices2:44
QUIZ: Power Query
HOMEWORK: Power Query
Data Modeling 101
Introduction0:28
Meet Excel's "Data Model"3:38
Data vs. Diagram View2:33
Database Normalization4:14
Data Tables vs. Lookup Tables5:40
Relationships vs. Merged Tables2:07
Creating Table Relationships6:54
Modifying Table Relationships2:06
Active vs. Inactive Relationships3:55
Relationship Cardinality5:46
Connecting Multiple Data Tables5:59
Filter Direction5:08
Hiding Fields from Client Tools4:59
Defining Hierarchies3:53
Data Model Best Practices1:38
QUIZ: Data Modeling 101
HOMEWORK: Data Modeling 101
Power Pivot & DAX 101
Introduction0:29
Creating a "Power" PivotTable5:27
"Power" Pivots vs. "Normal" Pivots2:48
Intro to Data Analysis Expressions (DAX)1:12
Calculated Columns8:39
DAX Measures = Supercharged Calculated Fields2:24
Creating Implicit Measures1:59
Creating Explicit Measures (AutoSum)7:08
Creating Explicit Measures (Power Pivot)7:42
Understanding Filter Context9:18
Step-by-Step Measure Calculation12:06
RECAP: Calculated Columns vs. Measures2:29
Power Pivot Best Practices1:50
QUIZ: Power Pivot & DAX 101
HOMEWORK: Power Pivot & DAX 101
Common DAX Functions
Introduction0:27
DAX Formula Syntax & Operators4:05
Common DAX Function Categories3:54
Basic Math & Stats Functions12:45
COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS10:35
HOMEWORK: Math & Stats Functions
Logical Functions (IF/AND/OR)16:49
SWITCH & SWITCH(TRUE)10:33
Text Functions10:53
HOMEWORK: Logical & Text Functions
The CALCULATE Function14:39
Adding Filter Context with FILTER (Part 1)9:20
Adding Filter Context with FILTER (Part 2)14:23
Removing Filter Context with ALL9:06
HOMEWORK: CALCULATE, FILTER & ALL
Joining Data with RELATED3:39
Iterator ("X") Functions: SUMX12:20
Iterator ("X") Functions: RANKX5:33
HOMEWORK: Iterator Functions
Basic Date & Time Functions4:58
Time Intelligence Formulas17:02
HOMEWORK: Time Intelligence
Speed & Performance Considerations3:02
DAX Best Practices2:03
QUIZ: Common DAX Functions
Wrapping Up
Introduction0:53
Data Visualization Options4:35
SNEAK PEEK: PowerBI5:55
Resources & Next Steps2:25

DescriptionInstructorImportant DetailsReviewsRelated Products

Get Up & Running with Excel's Data Modeling & Business Intelligence Tools

Excel MavenChris Dutton is a certified Microsoft Excel Expert, analytics consultant, and best-selling instructor with more than a decade of experience specializing in business intelligence, marketing analytics and data visualization.

He founded Excel Maven in 2014 to provide high-quality, applied analytics training and consulting to clients around the world, and now mentors 25,000+ students in more than 150 countries. He has developed award-winning data analytics and visualization tools, featured by Microsoft, the New York Times, and the Society of American Baseball Research.

Description

This course will introduce you to Microsoft Excel's powerful data modeling and business tools Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and supercharge your analytics, then this is the A-Z guide that you're looking for.

Access 86 lectures & 7 hours of content 24/7
Use sample data from a fictional supermarket chain to get hands-on w/ Power Query
Practice shaping, blending, & exploring project files
Cover the fundamentals of database design & normalization
Explore & analyze your data model using Power Pivot & DAX
Cover basic DAX syntax & learn some of the most powerful and commonly used functions

Specs

Details & Requirements

Length of time users can access this course: lifetime
Access options: web streaming, mobile streaming
Certification of completion not included
Redemption deadline: redeem your code within 30 days of purchase
Experience level required: all levels
You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

1 Review

5/ 5

All reviews are from verified purchasers collected after purchase.

Raeleen Giles

Verified Buyer

This course is well organized with great examples, I can’t say enough good things about it. If you are an Excel power user and new to power query and DAX you will learn plenty.

May 26, 2020

Your Cart

Your cart is empty. Continue Shopping!

Processing order...