8574  Reviews star_rate star_rate star_rate star_rate star_half

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...

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

Overview

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)

Course Details

Setup Requirements

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

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
Read Less

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 or can be ordered separately by clicking here.

  • 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

The training was great . But i expected some of the Networking concepts would be covered in this certification .

Instructor was great, course was mostly very good except for too much focus on pricing

The class covered the concepts needed for the AWS Cloud Practitioner Certification.

Thorough explanations by the instructor along guide and practical training sim of software.

The training was good but needed the basic skills of maximo before getting deep in the configuration of it.