Optimizing DAX

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

5 hours

46 videos

62 exercises

758 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

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

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

How will I be charged?

Can I get an invoice for my company?

Are refunds available?

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

VBA Automation Techniques for Businesses

EXPERIMENTAL: This course teaches valuable Microsoft VBA automation techniques that optimize business processes, leading to increased productivity and efficiency.

Tools

Skills

EDNA Experts

See details

Course Cover: SQL Essentials for Financial Analysis

beginner

Total points: 185 XP 1 hours

SQL Essentials for Financial Analysis

EXPERIMENTAL: A comprehensive course providing financial professionals with the fundamentals of SQL and its application in financial analysis.

Tools

Skills

EDNA Experts

See details

Course Cover: Integration, Analytics, and Governance for MS Fabric

intermediate

Total points: 752 XP 7 hours

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