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.
Ultimate Beginners Guide To DAX Cover

Paid Course

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
beginner
2 Hours
Learn More

Learning

Paths
20 assets
Path
Power BI for Data Science: From Data to Insights

Power BI for Data Science: From Data to Insights

This Learning Path delves into data analysis and visualization using both R and Python, covering data cleaning, data frames, and the use of packages like dplyr, tidyverse, skim R, and seaborn. It offers hands-on examples, such as creating various plots, performing group-based operations, and utilizing descriptive statistics for effective data interpretation.
Intermediate
16 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
Advanced DAX for Power BI

Advanced DAX for Power BI

This Learning Path provides a deep dive into Power BI and DAX, focusing on data analysis techniques and visualization. It equips learners with skills to craft dynamic visualizations.
Intermediate
5 Hours
Path
SQL for Data Analysis and Business Intelligence

SQL for Data Analysis and Business Intelligence

This Learning Path delves into data manipulation and analysis using SQL and DAX. It covers techniques and practical code examples.
Intermediate
5 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
Creating Interactive Apps with Power BI and Power Apps

Creating Interactive Apps with Power BI and Power Apps

This Learning Path dives into SharePoint and Power Apps, focusing on leveraging Power Automate for task automation and improved user interaction. 
Intermediate
4 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

Learning

Center
33 assets
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
DAX for SQL Developers

DAX for SQL Developers

Learn how to transfer your knowledge of SQL to DAX and vice versa
Intermediate
4 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
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
ChatGPT for Power BI Users

ChatGPT for Power BI Users

Discover how to utilize ChatGPT within Power BI for enhanced data analysis, reporting, and interactive dashboards. Learn how to integrate ChatGPT into Power BI to create dynamic and conversational visualizations.
Beginner
1 Hours
Course
Beginners Guide to Power BI

Beginners Guide to Power BI

Build a solid foundation in using Power BI.
Beginner
2 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
ChatGPT to Improve Productivity in Excel

ChatGPT to Improve Productivity in Excel

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!
Beginner
1 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
Power Query Going Back To Basics

Power Query Going Back To Basics

Learn the basics of data types in Power Query and some helpful hints
00:51:53 Hours
Virtual Event
Transformation High Level Analytics w/ Power BI

Transformation High Level Analytics w/ Power BI

Combining the power of the data model with high level analysis
00:45:59 Hours
Virtual Event
Geospatial Analytics

Geospatial Analytics

Introducing Power BI Geospatial Analysis for building compelling and dynamic maps in reports.
01:37:27 Hours
Virtual Event
Time-Based Cohort Analysis

Time-Based Cohort Analysis

Create time based cohort insights within Power BI.
00:59:17 Hours
Virtual Event
Implementation Best Practices For Power BI

Implementation Best Practices For Power BI

Relationship best practices in Power BI
00:54:35 Hours

Project

Center
27 assets
Challenge
Transport and Shipping Data

Transport and Shipping Data

Challenge your data skills by creating a report on transport and shipping data 
Challenge
Delivery App Review

Delivery App Review

Create a report or dashboard to help management visualize what is happening on the new app
Challenge
Covid 19 Reporting

Covid 19 Reporting

An excellent opportunity for you to create a one-page data report for Covid-19 analysis
Challenge
Formula 1 Analysis

Formula 1 Analysis

Deep dive into the world of F1 and create an analysis of the drivers' stats
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
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
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
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
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
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
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
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!