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
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
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
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
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
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
Mastering M Code for Power Query

Mastering M Code for Power Query

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.
Intermediate
10 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
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

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
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
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
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
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
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
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
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
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
Exploratory Data Analysis in Excel

Exploratory Data Analysis in Excel

Prepare, profile and analyze data in Excel workbooks
00:32:25 Hours
Virtual Event
Power BI Mastermind with Sam McKay & Greg Philps

Power BI Mastermind with Sam McKay & Greg Philps

Join a casual conversation with Sam and the Power BI Challenge Winner, Greg.
01:12:17 Hours
Virtual Event
Time-Based Cohort Analysis

Time-Based Cohort Analysis

Create time based cohort insights within Power BI.
00:59:17 Hours
Virtual Event
Better Insights from Visually Consistent Dashboards

Better Insights from Visually Consistent Dashboards

Find out why pattern recognition results in faster and better understanding
00:33:31 Hours
Virtual Event
Advanced SQL Skills For Data Analysts

Advanced SQL Skills For Data Analysts

Discover various Data Time Manipulation techniques in SQL
00:33:04 Hours

Project

Center
27 assets
Challenge
Delivery App Review

Delivery App Review

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

Transport and Shipping Data

Challenge your data skills by creating a report on transport and shipping data 
Guides
4 assets
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.
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.