Optimizing DAX

Master key data modeling and DAX concepts and techniques to optimize performance in Power BI

schedule5 hours

play_circle46 videos

unfold_more62 exercises

trending_up758 xp

Power BI

Advanced Analytics

Data Analysis

Let’s create your free account

Google

Microsoft

If you have an account Login here

Trusted by 220,000+ people worldwide.

An outline of this training course

The Optimizing DAX course will teach best practices for developing data models to support optimal performance of your Power BI reports. In addition, you will learn how to diagnose and resolve performance bottlenecks in your DAX measures using a variety of tools and techniques. This course explains in plain language how the DAX calculation engines work, so you can understand and evaluate how your DAX coding choices affect your report performance, ultimately leading to a better user experience.

Details of what you will learn during this course

Learn - best practice techniques when using the query editor
Learn - how to diagnose the root cause of a slow measure
Understand - the techniques to optimize your data model
Implement - methods to improve DAX code to increase performance

What you get with the course

3 hours of course videos
1x demo data sets to practice DAX formula development

Here are the specifics for the course

Learn how to:

Use best practices in developing DAX expressions
Use correct method for developing data model
Solve bottle neck issues that cause slow performance
Develop optimizations of DAX patterns
Visualize the outcome of DAX formulas

What our

Students Say

Curriculum

Course Resource Pack

Introduction

What is VertiPaq

Intro to DAX Studio

VertiPaq Analyzer in DAX Studio

What's Under the Hood

Logical and Physical Query Plans

Deeper Dive into Storage Engine Queries

Measuring Query Performance

Time to Start Optimizing

Your Feedback

Certification

Continuous Learning

Your

Instructor

Nick Mone

We are always looking for the best solution for you

Frequently Asked

Questions

add

What’s the difference between a free account and a paid plan?

add

Do I need to know anything about data science or data analytics to get started with Enterprise DNA?

add

How will I be charged?

add

Can I get an invoice for my company?

add

Are refunds available?

add

Will AI take over the world and make data skills worthless?

Integration, Analytics, and Governance for MS Fabric

Advance your data strategy with Microsoft Fabric and Azure. Discover how to optimize workspaces, develop effective pipelines, and manage data flows for enhanced security and governance.

Tools

Henry Habib

See details

Course Cover: Data Management and Processing in Microsoft Fabric

intermediate

Total points: 287 XP schedule 2 hours

Data Management and Processing in Microsoft Fabric

Uncover Microsoft Fabric's power! Secure OneLake data, optimize with Apache Spark, and master lakehouse vs. warehouse structures. Elevate your data game today!

Tools

Skills

Henry Habib

See details

Course Cover: Foundations of Microsoft Fabric

intermediate

Total points: 239 XP schedule 2 hours

Foundations of Microsoft Fabric

Discover the power of Microsoft Fabric and shape your future in data. Learn essential data engineering and analytics, and craft cutting-edge solutions with OneLake and Delta Lake.

Tools

Skills

Henry Habib

See details