Enterprise DNA Skills

Advanced Analytics

Use complex and sophisticated analytical techniques to uncover deep insights and make highly accurate predictions or recommendations.
Start Learning for Free
Advanced Analytics Cover

New to Advanced Analytics?

Start here.

DAX Optimization Masterclass Using DAX Studio Cover

Paid Course

DAX Optimization Masterclass Using DAX Studio

Improve the overall performance of your DAX measures using the DAX Studio

intermediate
intermediate
6 Hours
Learn More chevron_right

Learning

Center

16 assets
Course
DAX Optimization Masterclass Using DAX Studio

DAX Optimization Masterclass Using DAX Studio

Improve the overall performance of your DAX measures using the DAX Studio
Intermediate
6 Hours
Course
DP-500 Certification II: Visualizing and Governing Data using Azure Synapse Analytics and Power BI

DP-500 Certification II: Visualizing and Governing Data using Azure Synapse Analytics and Power BI

The second part of the preparation course for the Microsoft's DP-500 Exam Certification
Advanced
6 Hours
Course
Accessing Data via APIs in Power BI

Accessing Data via APIs in Power BI

Expand Power BI's capabilities in accessing a wide range of data using APIs
Intermediate
2 Hours
Course
DAX Formula Patterns

DAX Formula Patterns

Advanced course using Power BI & DAX to solve complex but common business problems and scenarios you'll face everyday
Intermediate
3 Hours
Course
DP-500 Certification Part I: Transform and Model Data using Azure Synapse Analytics and Power BI

DP-500 Certification Part I: Transform and Model Data using Azure Synapse Analytics and Power BI

The first of the two-part preparation course for the Microsoft's DP-500 Exam Certification
Advanced
8 Hours
Course
Tabular Editor 3: Beginner To Advanced

Tabular Editor 3: Beginner To Advanced

Master the most powerful tool for data modeling and DAX calculations in Power BI and Analysis Services
Advanced
3 Hours
Course
SQL For Power BI Users

SQL For Power BI Users

Level up your SQL query fluency even without prior SQL experience.
Beginner
3 Hours
Course
R for Power BI Users II

R for Power BI Users II

Enhance your Power BI reports and analysis with R's visualization, text analysis and statistical modeling capabilities.
Intermediate
2 Hours
Course
DAX Studio For Power BI & SAAS - Beginner To Advanced

DAX Studio For Power BI & SAAS - Beginner To Advanced

Master the ultimate tool for executing and analyzing DAX queries against various sources including Power BI and SSAS
Beginner
4 Hours
Course
Optimizing DAX

Optimizing DAX

Master key data modeling and DAX concepts and techniques to optimize performance in Power BI
Advanced
4 Hours
Path
Power BI Data Analyst

Power BI Data Analyst

This path is designed to build the broad range of expert-level knowledge necessary to confidently pass the PL-300 Data Analyst certification exam (replacement for DA-100).
13 Courses
Path
Power BI Optimization Expert

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.
5 Courses
Path
Data Transformation Expert

Data Transformation Expert

This path is focused on developing expert level skills in data cleaning, data transformation and data modeling. You will learn to maximize the capabilities of the Power Query UI, and also write M code for both single use solutions and to build custom functions to speed the processing of recurring tasks.
3 Courses
Path
Advanced Analytics Expert

Advanced Analytics Expert

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.
13 Courses
Path
Power BI Mastery

Power BI Mastery

This path is the most in-depth and rigorous on the list, designed to provide you expert-level skills in all of the key pillars of Power BI. You will gain the knowledge necessary to achieve Enterprise DNA Expert Certification and potentially become a member of the Enterprise DNA Expert Team.
8 Courses
Path
MS Certifications

MS Certifications

This path is designed to build the broad range of expert-level knowledge necessary to confidently pass the PL-300 Data Analyst certification exam (replacement for DA-100).
4 Courses

Virtual

Events

10 assets
Virtual Event
Detecting and Showcasing Outliers in Power BI

Detecting and Showcasing Outliers in Power BI

Develop complex Power BI solutions
Virtual Event
Where is All Your Data

Where is All Your Data

Where is all your data with Oakley Turvey
Virtual Event
Zebra BI Tool For Choosing Right Visual

Zebra BI Tool For Choosing Right Visual

Learn about the three fundamental rules that should guide your decision on choosing the correct type of chart
Virtual Event
Manage Banking Transactions Directly Through Your Excel-VBA model

Manage Banking Transactions Directly Through Your Excel-VBA model

In this session, you will learn how to manage Banking Transactions Directly Through Your Excel-VBA model
Virtual Event
R and Python in Power BI

R and Python in Power BI

This session will cover which Python and R packages and examples can facilitate functionalities found in Power BI
Virtual Event
Enhanced Data Storytelling

Enhanced Data Storytelling

Data story telling is an important part of the report development process. It changes the way the audience views reports.
Virtual Event
Azure AD for the Azure Data Services

Azure AD for the Azure Data Services

In this sessions we will start from what you need to know about Azure AD in relation to Azure data services.
Virtual Event
Calculation Groups Beyond Time Intelligence

Calculation Groups Beyond Time Intelligence

Dynamic data labels at the end of the line
Virtual Event
Power Query Route To M(astery): Challenge Yourself!

Power Query Route To M(astery): Challenge Yourself!

Illustrate key techniques in Power Query/M by working through the Challenges
Summit
2022 My Data Summit on Power BI & Excel

2022 My Data Summit on Power BI & Excel

Boost your productivity and performance by mastering Microsoft’s latest technology updates

Resources

1 assets
Resource
Exploring Expression Functions in Power Query/ M

Exploring Expression Functions in Power Query/ M