Formulas & Functions

Charts & Graphs

Data Analysis  with PivotTables

Power Query, Power Pivot & DAX

POWER QUERY, POWER PIVOT & DAX

This course introduces Microsoft Excel’s powerful data modeling and business intelligence tools.

Using project files and hands-on demos, we’ll load and transform raw files with Power Query, create table relationships with Excel’s Data Model, and use Power Pivot and DAX to explore and analyze our data with powerful calculated fields. If you’re ready to take your analytics game to the next level and become a true Excel power user, this course will get you there. Guaranteed.

ACCESS FULL COURSE

$175

Regular Price

$25

Special Offer

Full Course Access Includes

https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_clockwise.svg

Lifetime Access

https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_elaboration_browser_download.svg

Downloadable resources and practice files

https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/basic_book_pencil.svg

Course quizzes and homework exercises

https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/arrows_shrink_horizonal2.svg

1-on-1 instructor support

https://www.excelmaven.com/wp-content/themes/salient/css/fonts/svg/ecommerce_receipt_dollar.svg

Formulas & Functions

Charts & Graphs

Data Analysis with PivotTables

Power Query, Power Pivot & DAX

POWER QUERY, POWER PIVOT & DAX

$175

$25

Full Course Access Includes

Lifetime Access

Downloadable resources and practice files

Course quizzes and homework exercises

1-on-1 instructor support

30-day money-back guarantee

Choose A Section

Getting Started

IMPORTANT: Versions & Compatibility

Intro to Power Excel

The “Power Excel” Workflow

“The Best Thing to Happen to Excel in 20 Years”

When to use Power Query & Power Pivot

Power Query

Meet Power Query (aka “Get & Transform”)

The Query Editor

Data Loading Options

Basic Table Transformations

Text-Specific Tools

Number-Specific Tools

Date-Specific Tools

PRO TIP: Creating a Rolling Calendar

Adding Index & Conditional Columns

Grouping & Aggregating Data

Pivoting & Unpivoting

Modifying Workbook Queries

Merging Queries

Appending Queries

Connecting to a Folder of Files

Power Query Best Practices

Data Modeling 101

Meet Excel’s “Data Model”

Data vs. Diagram View

Database Normalization

Data Tables vs. Lookup Tables

Relationships vs. Merged Tables

Creating Table Relationships

Modifying Table Relationships

Active vs. Inactive Relationships

Relationship Cardinality

Connecting Multiple Data Tables

Filter Direction

Hiding Fields from Client Tools

Defining Hierarchies

Data Model Best Practices

Power Pivot & DAX 101

Creating a “Power” PivotTable

Power Pivots vs. “Normal” Pivots

Intro to Data Analysis Expressions (DAX)

Calculated Columns

DAX Measures = Supercharged Calculated Fields

Creating Implicit Measures

Creating Explicit Measured (AutoSum)

Creating Explicit Measures (Power Pivot)

Understanding Filter Context

Step-by-Step Measure Calculation

Recap: Calculated Columns vs. Measures

Power Pivot Best Practices

Common DAX Functions

DAX Formula Syntax & Operators

Common DAX Function Categories

Basic Math & Stats Functions

COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS

Logical Functions (IF/AND/OR)

SWITCH & SWITCH (TRUE)

Text Functions

The CALCULATE Function

Adding Filter Context with Filter (Part 1)

Adding Filter Context with Filter (Part 2)

Removing Filter Context with ALL

Joining Data with RELATED

Iterator (“X”) Functions: SUMX

Iterator (“X”) Functions: RANKX

Data Analysis  with PivotTables