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.
Exam PL-300: Microsoft Power BI Data Analyst Cover

Paid Course

Exam PL-300: Microsoft Power BI Data Analyst

Prepare for PL-300: Microsoft Power BI Data Analyst Exam to earn the Power BI  Data Analyst Associate certification

intermediate
intermediate
6 Hours
Learn More

Learning

Paths
20 assets
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.
Intermediate
13 Hours
Path
Applied Statistics for Data Analysis

Applied Statistics for Data Analysis

This Learning Path in statistical analysis and inference equips learners with practical skills to conduct tests, estimate sample sizes, and understand test assumptions. 
Intermediate
6 Hours
Path
Business Intelligence with Power BI

Business Intelligence with Power BI

This Learning Path delves into Power BI development, focusing on creating effective reports and visualizations. It covers parameter management, using PowerPoint and more!
Intermediate
10 Hours
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. 
Intermediate
31 Hours
Path
Intermediate DAX Concepts for Power BI

Intermediate DAX Concepts for Power BI

This Learning Path delves into data analysis techniques, focusing on Power BI functions. It guides learners to enhance their data insight extraction skills.
Intermediate
12 Hours
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 create advanced custom visualizations using bespoke visualization languages.
Beginner
25 Hours
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.
Beginner
16 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).
Beginner
41 Hours

Learning

Center
33 assets
Course
Exam PL-300: Microsoft Power BI Data Analyst

Exam PL-300: Microsoft Power BI Data Analyst

Prepare for PL-300: Microsoft Power BI Data Analyst Exam to earn the Power BI  Data Analyst Associate certification
Intermediate
6 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
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
Advanced Analytics In Power BI

Advanced Analytics In Power BI

Implement advanced & practical analytical techniques inside of Power BI and find insights you never thought possible in an intuitive way
Advanced
1 Hours
Course
Power Platform Certification Course - PL-900

Power Platform Certification Course - PL-900

Ace the Microsoft Power Platform (PL-900) Certification exam with our complete training guide
Beginner
14 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
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
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

Virtual

Events
93 assets
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
How Data Analytics Make Companies More Resilient

How Data Analytics Make Companies More Resilient

Listen as Sam McKay talks to Shiv Misra on why companies need to have an appetite for change and embrace data analytics
Podcast
Unique Data Insights In the Healthcare Space

Unique Data Insights In the Healthcare Space

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
Implementation Best Practices For Power BI

Implementation Best Practices For Power BI

Relationship best practices in Power BI
00:54:35 Hours
Virtual Event
What’s New & What’s Coming For Power BI

What’s New & What’s Coming For Power BI

Learn how the improved user experience in Power BI has made it easier to create and manage complex calculations
00:39:00 Hours
Virtual Event
Track Changes Using Dimensions In Power Query

Track Changes Using Dimensions In Power Query

Showcase how to implement an SCD Type 2 using Power Query to allow a full historical analysis of a specific dimension
00:45:11 Hours
Virtual Event
Q&A Networking Event with Sam McKay, Brian Julius & Reid Havens

Q&A Networking Event with Sam McKay, Brian Julius & Reid Havens

One of the break-out session in our Reporting & Data Visualization Summit, showcasing a variety of beginner to advanced Power BI tips and techniques.
01:20:11 Hours
Virtual Event
Once Upon a Time: From Data to Stories

Once Upon a Time: From Data to Stories

What is a story? How should we apply the concept of storytelling to data visualization?
00:41:00 Hours

Project

Center
27 assets
Challenge
Formula 1 Analysis

Formula 1 Analysis

Deep dive into the world of F1 and create an analysis of the drivers' stats
Challenge
Currency Conversion and More

Currency Conversion and More

Challenge your data skills by producing a report that gives the user the ability to select a currency and see the associated sales and cost
Challenge
User Experience Focus - Design Creative Navigations

User Experience Focus - Design Creative Navigations

Create a navigation experience that showcases your brand and keeps users coming back for more by prioritizing the user experience and considering the needs and preferences of your target audience.
Challenge
Emergency Services Analytics

Emergency Services Analytics

Analyze the data of a medical emergency response service and discover opportunities for improvement on their process
Challenge
Environmental Data Reporting

Environmental Data Reporting

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded
Challenge
Acing Documentation

Acing Documentation

Use the data documenter tool to create an effective report template 
Challenge
EDNA Youtube Channel Data Analysis

EDNA Youtube Channel Data Analysis

Analyze Enterprise DNA's Youtube Channel Data to understand its audience and create a strategy to drive more channel engagement.
Challenge
Sales and Production Analysis

Sales and Production Analysis

Implement your analytical skills in creating a report of the entire business operation from production to forecasting.
Guides
4 assets
Resource
Microsoft DP-500 Certification Study Guide

Microsoft DP-500 Certification Study Guide

The Microsoft DP-500 exam, formally titled “Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI,” is designed to test your knowledge and skills in using the Azure environment and Power BI for advanced data analytics tasks.
Resource
Excel Cheat Sheet: A Beginners Guide With Time-Saving Tips

Excel Cheat Sheet: A Beginners Guide With Time-Saving Tips

This guide is here to simplify your journey with Excel, offering you the key tools, shortcuts, and techniques at your fingertips, so make sure to save it for future reference. 
Resource
Numpy Cheat Sheet

Numpy Cheat Sheet

A NumPy cheat sheet can be an excellent resource to help guide your journey into this Python library. A comprehensive cheat sheet will help you navigate NumPy’s features and quickly become proficient in using it for various tasks!
Resource
Excel Formulas Cheat Sheet: Intermediate Guide

Excel Formulas Cheat Sheet: Intermediate Guide

This Microsoft Excel intermediate cheat sheet covers a wide range of topics that will level up your skills in numerical analysis, text processing, and complex date and time logic