Platform Access

Power BI

Optimization Expert

This path will provide you in-depth knowledge of the full range of Power BI best practices, with particular emphasis on building data models specifically optimized for Power BI, tuning your M code for peak performance, and identifying and resolving performance bottlenecks in your DAX code.

Scenario Analysis Deep Dive

About This Path

Within this learning path you will learn how to harness the full analytical power behind Power BI.


You will first learn and master the extensive DAX formula language. While also learning some specifics around how to fine tune and optimise your formulas and code within Power BI Desktop.


Covered in detail are best practises for data models in Power BI. This is essential knowledge to make sure reports run smoothly and efficiently. For optimized Power BI reports you must build the foundations of your data and data models so they are robust and scalable. This learning path takes you through this from start to finish.


Also within this learning path complimentary tools such as DAX Studio and Tabular Editor are reviewed comprehensively. These are quality application the work well alongside Power BI development, with great features for the diligent data professional.

Who Should Take This Path

  • Power BI Users who work with complex measures and want to make their report work efficiently
  • Data analysts who want to improve their Power BI skills
  • Students who want to have a strong DAX skills

What Are The Path Requirements

  • Power BI account for Power BI Desktop

and Power BI Service

Start Your Power BI Optimization Expert Path Now

Meet Your Instructors

Sam Mckay

Sam is Enterprise DNA's CEO & Founder. He helps individuals and organizations develop data-driven cultures and create enterprise value by delivering business intelligence training and education on Microsoft’s Power BI platform

He partners with business decision-makers and analysts across all industries and business functions.

Nick Moné

Skilled in creating complex data models, such as a Sales table and a Budget table.


Expertise in utilizing Power Query to take data in any form and transform it into tabular format.


Ability to see how all the Power BI products (Power Query, DAX, Power BI) function together ecosystem.

Antriksh Sharma

Years of experience in Power BI, Power Pivot, Power Query and SSAS

SuperUser at Microsoft’s Power BI community platform with over 80 solutions, 50 PBI solutions at Enterprise DNA’s community, and approx. 30 PBI solutions on other platforms. Passionately believes in sharing everything he knows.

Join other Enterprise DNA Members

View More Testimonials Here

Want to keep exploring?

Check Out These Other Learning Paths

This path is designed to help you become an expert in data visualization, data storytelling, and report design. You will learn how to make the most of native Power BI visuals, skillfully utilize the best AppSource visuals, and create advanced custom visualizations using bespoke visualization languages including Deneb/Vega-lite, HTML/CSS and ggplot2.


Path Info

This path is designed to help you harness the full power of Power BI in combination with R and Python. You will learn how to conduct advanced statistical analyses, text and sentiment analysis, leverage machine learning techniques and other key methods commonly used to gain insight into complex business questions.


Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

On-Demand

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace