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

Paid Course

Mastering DAX Calculations

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI

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

Learning

Center
33 assets
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
Power BI Super Users Workshop

Power BI Super Users Workshop

An in depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights from your own data.
Beginner
6 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
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
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
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
Introduction to Statistics for Data Analysts II

Introduction to Statistics for Data Analysts II

Learn valid inference techniques for two-sample and two-variable data questions.
Intermediate
2 Hours
Course
Beginners Guide to Langchain

Beginners Guide to Langchain

Discover the Langchain platform and learn how to build and deploy language models using its powerful tools and APIs. Explore custom training, fine-tuning, and deployment options.
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
Q&A Networking Event with Sam McKay, Brian Julius & Reid Havens

Q&A Networking Event with Sam McKay, Brian Julius & Reid Havens

One of the break-out session in our Reporting & Data Visualization Summit, showcasing a variety of beginner to advanced Power BI tips and techniques.
01:20:11 Hours
Virtual Event
Detecting and Showcasing Outliers in Power BI

Detecting and Showcasing Outliers in Power BI

Develop complex Power BI solutions
00:05:43 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
Let's Merge Queries To Improve Tabular Model

Let's Merge Queries To Improve Tabular Model

Learn how to combine queries to protect the fact tables in the tabular model
00:36:01 Hours
Virtual Event
Offset Magic: Make DAX Time Intelligence Disappear

Offset Magic: Make DAX Time Intelligence Disappear

Create reusable, templatized offset measures to further simplify and speed DAX analyses
00:44:14 Hours

Project

Center
27 assets
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
Customer Insight

Customer Insight

An opportunity to design and build a report that gives insights into customer behavior
Challenge
Covid 19 Reporting

Covid 19 Reporting

An excellent opportunity for you to create a one-page data report for Covid-19 analysis
Challenge
Transport and Shipping Data

Transport and Shipping Data

Challenge your data skills by creating a report on transport and shipping data 
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
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
Challenge
Acing Documentation

Acing Documentation

Use the data documenter tool to create an effective report template 
Challenge
Purchases, Inventory And Sales

Purchases, Inventory And Sales

Practice your data skills and learn from what is a typical scenario faced by many businesses in various industries
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
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. 
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