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 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
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 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
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
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
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
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

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
Mastering DAX Calculations

Mastering DAX Calculations

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI
Intermediate
9 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
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
R for Power BI Users II

R for Power BI Users II

Enhance your Power BI reports and analysis with R's visualization, text analysis and statistical modeling capabilities.
Intermediate
2 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
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
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

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
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
Virtual Event
ChatGPT & The Future Of Learning Data Skills

ChatGPT & The Future Of Learning Data Skills

What’s the future of ChatGPT and its integration with MS tools
01:07:53 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
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
The (M)agic of List.Generate

The (M)agic of List.Generate

Incorporate multiple variables within function using List.Generate
00:45:25 Hours
Virtual Event
Reporting & Data Visualization Summit

Reporting & Data Visualization Summit

Join This FREE Live Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more...
30:48:44 Hours

Project

Center
27 assets
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
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
Hotels Revenue Management

Hotels Revenue Management

Take on the challenge of creating an analysis report on hotels revenue management 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
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
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
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
Environmental Data Reporting

Environmental Data Reporting

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded
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
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!
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