Advanced Data Modeling and DAX in Power BI

In this Power BI course, participants develop a deep understanding of Power BI’s data modeling and DAX capabilities. They explore advanced techniques for creating and optimizing data relationships,...

Read More
By Request
8781  Reviews star_rate star_rate star_rate star_rate star_half
$1,495USD
Duration 2 days
Course Code WA3712
Available Formats Classroom

Overview

Course Description

In this Power BI course, participants develop a deep understanding of Power BI’s data modeling and DAX capabilities. They explore advanced techniques for creating and optimizing data relationships, categorization, and hierarchical structures. The course also covers powerful DAX expressions, statistical functions, and best practices for enhancing performance. Through hands-on exercises, participants learn to build efficient, high-performing reports and dashboards using advanced Power BI techniques.

Skills Gained

  • Understand and implement different data modeling approaches, including Star and Snowflake schemas
  • Create and optimize relationships, hierarchies, and groupings for efficient data representation
  • Develop proficiency in writing and debugging complex DAX expressions
  • Apply statistical and ranking functions to perform advanced analytics in Power BI
  • Optimize Power BI performance using best practices, query folding, and performance analysis tools

Prerequisites

  • Basic understanding of Power BI, including data loading and report creation
  • Familiarity with fundamental DAX functions and concepts
  • Basic knowledge of relational database concepts and SQL (recommended)

Setup Requirements

  • A computer with an internet connection is required.
  • A remote lab VM with all necessary accounts will be provided to each participant.
Read Less

Course Details

Course Details

Data Modeling in Power BI

  • Understanding Data Modeling
  • Star vs. Snowflake Schema: When to Use Each
  • Creating Relationships: One-to-One, One-to-Many, and Many-to-Many
  • Organizing Data: Display Formats, Categorization, and Folders
  • Building Hierarchies for Efficient Data Navigation
  • Grouping and Binning for Aggregated Insights

A Quick Overview of DAX

  • What is DAX?
  • Calculated measures, columns, and tables
  • Using SUM and SUMX
  • Usuing FILTER
  • Using CALCULATE

Statistical and Ranking Functions in DAX

  • Ranking Functions: RANKX, RANK.EQ, RANK.AVG, DENSERANK, PERCENTRANKX
  • Quartile and Percentile Functions: NTILE, QUARTILE.EXC, QUARTILE.INC, PERCENTILE.EXC, PERCENTILE.INC
  • Central Tendency Measures: MEAN, MEDIAN
  • Standard Deviation and Variance: STDEV.P, STDEV.S, VAR.P, VAR.S
  • Advanced Statistical Functions: SKEWNESS, KURTOSIS, COVARIANCE.P, COVARIANCE.S, CORREL
  • ANOVA: Performing Variance Analysis in Power BI

Data Sampling and Filtering in DAX

  • Using SAMPLE and TOPN for Data Sampling
  • Generating Random Data with RAND()
  • Filtering Techniques: SWITCH, FILTER, and ALL Functions
  • Concatenating Text Data: CONCATENATE() and CONCATENATEX()
  • Counting Functions: COUNT(), COUNTA(), COUNTBLANK(), COUNTROWS(), DISTINCTCOUNT(), DISTINCTCOUNTNOBLANK()

Advanced DAX Concepts

  • Working with Calculation Groups in Tabular Editor
  • Creating Dedicated Tables for Measures
  • Using Variables in DAX for Performance Optimization
  • Advanced Variable Techniques for Complex Calculations
  • Debugging DAX Expressions Using DAX Studio

Power BI Performance Optimization

  • Choosing Between DirectQuery, Import, and Hybrid Models
  • Using Performance Analyzer to Identify Bottlenecks
  • Understanding Query Folding and How It Affects Performance
  • Leveraging the Best Practice Analyzer for Optimized Data Models
  • Effective Strategies for Data Grouping and Summarization

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information
Ascendient Learning would like to occasionally share news about our services and career opportunities via e-mail when we believe it would be relevant to you. Would you like to opt-in to these communications? You may withdraw your consent at any time using the opt-out/preferences link in the emails sent.

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

I liked the pace of the course. I like that I have more than instance to use the lab.

Although there seemed to be too many links for the course, everything worked smoothly.

Some Labs are very good but some steps it ask to update but its already updated, but overall its very good training.

Both course material and instructor demonstrated a sound foundation on Maximo material

They were very good. They made sure everyone was able to get into the training and got all of the material needed for class.