NEED HELP? TALK TO AN EXPERT (904) 638-5743

Sign In
Start Learning

Advanced Data Modeling with Power BI

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  •  Parsing data modeling formulas
  • Using DAX to create calculations
  • How to define the business process
  • The consequences of data model design decisions
  • Concepts of calculated columns and measures, with particular focus on patterns & CALCULATE
Sign-up for Free Trial
This course includes:
  • 3.5 hours of training
  • Access on mobile app and browser
  • Certificate of Completion

Course Description

This course walks through parsing data modeling formulas, using DAX to create calculations, consequences of data model design decisions, concepts of calculated columns and measures, with particular focus on patterns & CALCULATE.

Outline

 

Module 00 | Course Introduction
07m 35s total

 

Module 00A | Course Introduction
07m 35s

 

Module 01 | Data Modeling Basics and Power BI Desktop Internals
62m 36s total

 

Module 01A | Data Modeling Basics and Power BI Desktop Internals Overview
53m 00s

 

Module 01B | Definining Relationships Lab
9m 36s

 

Module 02 | DAX Calculated Columns and Measures
60m 40s total

 

Module 02A | DAX Calculated Columns and Measures Overview
48m 18s

 

Module 02B | DAX Lab
12m 22s

 

Module 03 | CALCULATE
15m 49s total

 

Module 03A | CALCULATE
15m 49s

 

Module 04 | DAX Evaluation Context
55m 09s total

 

Module 04A | DAX Evaluation Context Overview
33m 42s

 

Module 04B | Evaluation Context Lab
21m 27s

 

Module 05 | Advanced DAX Time Intelligence Functions
14m 26s total

 

Module 05A | Advanced DAX Time Intelligence Functions
14m 26s


Instructor

MANUEL QUINTANA

Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.

 

Click Here To Learn More About Manuel And See Certifications And Reviews

System Requirements

Microsoft Power BI Desktop

What to Know Before Class

We recommend first taking our Introduction to Power BI course prior to taking this one.

REVIEWS
Perfect, I learned a lot and will return to reports I created and improve them performance-wise.

Anonymous

Loved it. Thank you Manuel Quintana.

Anonymous

Excellent

Chandra M.

Related products

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!

Sign-up for Free Trial