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

Paid Course

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

Learning

Paths
20 assets
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
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
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
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 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
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
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

Learning

Center
33 assets
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
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
Data Science Overview with Python

Data Science Overview with Python

Dive into data with Python! Transform raw data into actionable insights, mastering data preparation, wrangling, and modeling. Start your data science journey today.
Beginner
1 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
Data Analysis with PandasAI

Data Analysis with PandasAI

Unlock the power of data analysis and visualization with PandasAI, and transform raw data into actionable insights that drive decision-making and growth.
Intermediate
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
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
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
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
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
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
00:43:34 Hours
Virtual Event
High Level Analytics w/Power BI

High Level Analytics w/Power BI

Analyzing your data set in comprehensive way to get a better understanding
00:46:24 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
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
Clean Your Data Like A Pro

Clean Your Data Like A Pro

Use Power Query/ M effectively to prepare data for analysis
00:37:02 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
Twitter Threads Analysis

Twitter Threads Analysis

Jump into this twitter related dataset and showcase some interesting insights based on the text of the tweet and the stock reference or tagged within the tweet itself.
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
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
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
Call Center Data Reporting

Call Center Data Reporting

Create a report summary of the overall services provided by a Call Centre for its management
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
Health & Substance Abuse Report Analysis

Health & Substance Abuse Report Analysis

Challenge your data skills in creating an analysis report on substance
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.