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

Free Course

SQL For Power BI Users

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

beginner
beginner
3 Hours
Learn More

Learning

Paths
20 assets
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 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.
Intermediate
29 Hours
Path
Power BI Advanced Analytics Expert

Power BI 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 analyses and gain insight into complex business questions.
Intermediate
47 Hours
Path
PL-900 Certification

PL-900 Certification

This Learning Path enables individuals to proficiently use Power BI and other Power Platform tools. It prepares business analysts for the PL-900 exam.
Beginner
15 Hours
Path
Mastering M Code for Power Query

Mastering M Code for Power Query

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.
Intermediate
10 Hours
Path
DAX Fundamentals in Power BI

DAX Fundamentals in Power BI

This Learning Path delves into data analysis and modeling, focusing on Filter and Row Contexts for data computations, and the use of functions like SUM, SUMX, and Calculate.
Beginner
7 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
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

Learning

Center
33 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
Data Literacy for Beginners

Data Literacy for Beginners

Discover the key to unlocking insights and making informed decisions through data.
Beginner
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
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
Integrate ChatGPT into Excel using Macros and APIs

Integrate ChatGPT into Excel using Macros and APIs

Integrate ChatGPT into Excel using Macros and APIs to enhance your learning experience and maximize productivity.
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
Introduction to Statistics for Data Analysts

Introduction to Statistics for Data Analysts

A practical guide to recognizing, understanding, and managing uncertainty in data 
Intermediate
2 Hours
Course
Scenario Analysis Deep Dive

Scenario Analysis Deep Dive

Learn how to predict and optimize for results in the future, by utilizing 'what if' parameters and scenario analysis techniques
Intermediate
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
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
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
Virtual Event
Leveraging UX & Design Principles to Elevate Data Experience

Leveraging UX & Design Principles to Elevate Data Experience

Learn key principles from user experience and design and how to thoughtfully integrate them into your data viz workflow.
00:36:59 Hours
Virtual Event
Detecting and Showcasing Outliers in Power BI

Detecting and Showcasing Outliers in Power BI

Develop complex Power BI solutions
00:05:43 Hours
Virtual Event
The Meme Report: Teaching About Data Visualization Thru Humor

The Meme Report: Teaching About Data Visualization Thru Humor

Know the the importance on reading about data visualization theory and the benefits of Zebra BI visuals for Power BI reports
00:41:07 Hours
Virtual Event
Effective Power BI Reporting for Analysts

Effective Power BI Reporting for Analysts

Produce amazing insights including running custom scenarios on your raw data
00:59:23 Hours
Virtual Event
Correlation and Regression in Excel

Correlation and Regression in Excel

Explore the relationship between correlation and causation
00:33:45 Hours

Project

Center
27 assets
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.
Challenge
Delivery App Review

Delivery App Review

Create a report or dashboard to help management visualize what is happening on the new app
Challenge
Insurance Complaints

Insurance Complaints

Analyze the data of a large insurance company who are due to undergo an internal audit with regard to its complaint’s procedure
Challenge
Transport and Shipping Data

Transport and Shipping Data

Challenge your data skills by creating a report on transport and shipping data 
Challenge
Acing Documentation

Acing Documentation

Use the data documenter tool to create an effective report template 
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
Customer Insight

Customer Insight

An opportunity to design and build a report that gives insights into customer behavior
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.
Guides
4 assets
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
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
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