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
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
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
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
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.
Beginner
10 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
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 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
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

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
Mastering Report Development - Start to Finish

Mastering Report Development - Start to Finish

A detailed step-by-step process of creating high-quality Power BI reports that satisfy the requirements of real-world scenarios
Intermediate
2 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
Microsoft Excel for Beginners

Microsoft Excel for Beginners

Build a strong foundation on your MS Excel skills as you progress to advanced level
Beginner
3 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
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
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
R For Power BI Users

R For Power BI Users

Amplify your Power BI visualizations with R's comprehensive statistical analysis and graphics language
Beginner
3 Hours

Virtual

Events
93 assets
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
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
Virtual Event
Time-Based Cohort Analysis

Time-Based Cohort Analysis

Create time based cohort insights within Power BI.
00:59:17 Hours
Virtual Event
Using ChatGPT for Data Analytics

Using ChatGPT for Data Analytics

Explore the applications of ChatGPT in the field of data analytics.
Intermediate
00:49:40 Hours
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
Storytelling and Design in Action

Storytelling and Design in Action

Critical thinking to improve problem solving and decision making
00:54:46 Hours
Virtual Event
Power BI For Excel Users - Kick Start Your Analytics Journey

Power BI For Excel Users - Kick Start Your Analytics Journey

Solve advanced analytical questions using Power BI
01:02:29 Hours

Project

Center
27 assets
Challenge
Marketing Analytics - Measuring ROI

Marketing Analytics - Measuring ROI

Analyze data from marketing campaigns and initiatives, using visualization tools and statistical analysis techniques to identify trends and patterns, and use these insights to inform marketing strategy and decision-making.
Challenge
Formula 1 Analysis

Formula 1 Analysis

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

Financial Report Showcase

Show off your impressive financial report! We are confident that your financial report is a testament to your skills and expertise. We would love to see how you've structured it and how you've made it visually appealing.
Challenge
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
Challenge
Global Cost Of Living Crisis

Global Cost Of Living Crisis

Identify trends and patterns in a variety of factors that influence the cost of living in different regions around the world by using statistical analysis techniques and visualization tools.
Challenge
Acing Documentation

Acing Documentation

Use the data documenter tool to create an effective report template 
Challenge
Delivery App Review

Delivery App Review

Create a report or dashboard to help management visualize what is happening on the new app
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 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
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 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.