Enterprise DNA Skills

Data Analysis

Apply statistical and analytical techniques to raw data to uncover insights and make informed decisions.
Start Learning for Free
Data Analysis Cover

New to Data Analysis?

Start here.

SQL For Power BI Users Cover

Paid Course

SQL For Power BI Users

Level up your SQL query fluency even without prior SQL experience.

beginner
beginner
3 Hours
Learn More chevron_right

Learning

Center

22 assets
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
Mastering DAX Calculations

Mastering DAX Calculations

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI
Intermediate
9 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
Ultimate Beginners Guide To DAX

Ultimate Beginners Guide To DAX

Learn all about DAX calculations in Power BI. Learn introductory theory as well as how to put it into practice when developing Power BI models. 
Beginner
2 Hours
Course
Optimizing DAX

Optimizing DAX

Master key data modeling and DAX concepts and techniques to optimize performance in Power BI
Advanced
4 Hours
Course
ChatGPT for Data Science

ChatGPT for Data Science

Dive deeper into using ChatGPT for data science tasks. Explore techniques for data preprocessing, feature engineering, model training, and deploying ChatGPT models for specific data analysis and prediction tasks.
Beginner
1 Hours
Course
Power BI Super Users Workshop

Power BI Super Users Workshop

An in depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights from your own data.
Beginner
6 Hours
Course
Report Development Best Practices Checklist

Report Development Best Practices Checklist

Review some of the best practices to refine your Power BI development skills
Beginner
3 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
Lab
ALL & ALLSELECTED Functions

ALL & ALLSELECTED Functions

The ALL function is an extremely important part of the DAX language in Power BI
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 Visualization Expert

Power BI Visualization Expert

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.
10 Courses
Path
Power Platform Expert

Power Platform Expert

This path is designed to provide you the necessary skills to build full enterprise apps by integrating Power BI , Power Automate and Power Apps. You will also gain the expert level knowledge to pass the full Microsoft Power Platform certification series
7 Courses
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
Data Analytics Generalist

Data Analytics Generalist

This path is similar to the Data Analyst learning path above, but is geared to building a strong and broad foundation of data analysis skills, as compared to being more specifically focused on passing the PL 300 exam.
8 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 Strategy Expert

Data Strategy Expert

This path is designed to help you build expert level skills in the implementation, monitoring and governance of Power BI, including making optimal use of the Service through dataflows, datasets, thin reports, etc.
3 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
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
Assessment
Introduction to Statistics for Data Analysts Review Questions

Introduction to Statistics for Data Analysts Review Questions

Introduction to Statistics for Data Analysts Review Questio
Assessment
Exam PL-300: Microsoft Power BI Data Analyst - Practice Set #2

Exam PL-300: Microsoft Power BI Data Analyst - Practice Set #2

Exam PL-300: Microsoft Power BI Data Analyst - Practice Set #2
Assessment
Exam PL-300: Microsoft Power BI Data Analyst - Practice Set #1

Exam PL-300: Microsoft Power BI Data Analyst - Practice Set #1

Exam PL-300: Microsoft Power BI Data Analyst - Practice Set #1

Virtual

Events

13 assets
Podcast
How Data Analytics Make Companies More Resilient By Shiv Misra

How Data Analytics Make Companies More Resilient By Shiv Misra

Listen as Sam McKay talks to Shiv Misra on why companies need to have an appetite for change and embrace data analytics
Podcast
Imagine the Possibilities of Data Products with Power BI

Imagine the Possibilities of Data Products with Power BI

Listen as Jarrett Moore talks to Sam McKay on how he scaled a data analytics system for his own company and built a separate data product on top of it
Podcast
Unique Data Insights in the Healthcare Space with Anuj Kapoor

Unique Data Insights in the Healthcare Space with Anuj Kapoor

Join Sam McKay and Anuj Kapoor as they talk about how data analytics is helping the healthcare industry save lives. Anuj also discusses the importance of establishing a problem statement and having quality data to work with
Virtual Event
Project Management Insights w/Power BI

Project Management Insights w/Power BI

Create effective project management dashboards
Virtual Event
Move From An Excel To Power BI Super User

Move From An Excel To Power BI Super User

Transfer your Excel skills into Power BI seamlessly.
Virtual Event
Advanced SQL Skills For Data Analysts

Advanced SQL Skills For Data Analysts

Discover various Data Time Manipulation techniques in SQL
Virtual Event
Use Excel To Build & Validate Complex DAX

Use Excel To Build & Validate Complex DAX

Discover how to visualize, debug, validate and solve complex DAX problems using Excel
Virtual Event
Row-Level-Security Hacks

Row-Level-Security Hacks

Implement some creative Row-Level-Security techniques effectively and learn how to dynamically anonymize data
Virtual Event
Practical Power Query Solutions

Practical Power Query Solutions

Let’s practice some Power Query/M. It’s a Date!
Virtual Event
Become A Power BI Power User With DAX

Become A Power BI Power User With DAX

Perform dynamic analysis of data through context transition in DAX
Virtual Event
The CHRTS Assistant, A Tool for Choosing Best-Fitting Visualizations

The CHRTS Assistant, A Tool for Choosing Best-Fitting Visualizations

Learn how to choose the correct visualizations that best fit consumer data questions based on five visualization families
Summit
Power Platform Innovation Labs #2

Power Platform Innovation Labs #2

Learn how to build scalable Power Platform solutions to implement robust business processes from the world's global experts.
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

3 assets
Resource
Exploring Splitter.SplitTextByWhitespace in Power Query/ M

Exploring Splitter.SplitTextByWhitespace in Power Query/ M

Resource
An INDEX MATCH challenge with Power Query M

An INDEX MATCH challenge with Power Query M

Resource
Constructing lists in Power Query/M

Constructing lists in Power Query/M