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.
Intermediate Excel Cover

Paid Course

Intermediate Excel

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.

intermediate
intermediate
4 Hours
Learn More

Learning

Paths
20 assets
Path
SQL Fundamentals: Getting Started with Database Querying

SQL Fundamentals: Getting Started with Database Querying

This learning path provides a thorough understanding of SQL, emphasizing key commands for data manipulation and querying. 
Intermediate
4 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
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
Power Platform Expert

Power Platform Expert

This path is designed to provide you the necessary skills to build full enterprise apps by integrating Power BI , Power Automate and Power Apps. 
Intermediate
52 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
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
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
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

Learning

Center
33 assets
Course
Intermediate Excel

Intermediate Excel

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.
Intermediate
4 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
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
Report Development Best Practices Checklist

Report Development Best Practices Checklist

Review some of the best practices to refine your Power BI development skills
Beginner
3 Hours
Course
Python I for Power BI Users

Python I for Power BI Users

Dramatically enhance Power BI's capabilities by incorporating Python's flexible and powerful data wrangling, data analysis and data visualization functionality
Beginner
4 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
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

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
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
Virtual Event
Using DAX To Unlock Potential Of DAX Visualization

Using DAX To Unlock Potential Of DAX Visualization

Discover sample DAX techniques that enhance business insights and explore DAX formulas to leverage conditional formatting options
00:40:21 Hours
Virtual Event
Introduction To DAX Formulas In Power BI

Introduction To DAX Formulas In Power BI

Use DAX ranking techniques in your analysis
01:02:45 Hours
Virtual Event
Business Analytics Week - October 2021

Business Analytics Week - October 2021

We'll be reviewing a number of techniques specifically around reporting dashboards in Power BI.
02:14:44 Hours
Virtual Event
Using WORKOUTS to Master Data Skills

Using WORKOUTS to Master Data Skills

WORKOUTS is an innovative approach that combines hands-on exercises, practical applications, and collaborative learning to help data practitioners master data skills effectively.
Beginner
00:44:04 Hours
Virtual Event
Power BI Reports Inside Power Apps

Power BI Reports Inside Power Apps

Learn how to seamlessly integrate Power BI reports into Power Apps, either full reports or individual tiles
00:35:03 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
Customer Insight

Customer Insight

An opportunity to design and build a report that gives insights into customer behavior
Challenge
Delivery App Review

Delivery App Review

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

Jira IT Service Desk Analysis

Produce insights for management level that can highlight any issues and prepare them for the audit
Challenge
Optical Data

Optical Data

Provide a business solution by creating an intelligence tool to use by large opticians
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
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
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
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.