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.
Integrate ChatGPT into Excel using Macros and APIs Cover

Paid Course

Integrate ChatGPT into Excel using Macros and APIs

Boost your Excel skills with ChatGPT integration! Learn how to use macros and APIs to seamlessly blend ChatGPT into Excel, enhancing both your productivity and learning experience.

beginner
beginner
1 Hours
Learn More

Learning

Paths
12 assets
Path
Power BI Data Analyst

Power BI Data Analyst

Master the skills needed to ace the PL-300 certification exam, blending foundational Power BI knowledge with advanced DAX techniques.
Beginner
19 Hours
Path
Data Analytics Generalist

Data Analytics Generalist

Gain a versatile skill set covering a wide range of data analysis techniques and tools, preparing you for diverse roles in the dynamic field of data analytics!
Beginner
13 Hours
Path
Power BI for Data Science

Power BI for Data Science

Discover data cleaning, data frames, and essential packages like dplyr, tidyverse, skim R, and seaborn for powerful data visualization.
Intermediate
18 Hours
Path
Python for Data Analysis

Python for Data Analysis

Take your data analysis to the next level with Python. Seamlessly integrate Python and AI for efficient workflows and game-changing insights.
Beginner
12 Hours
Path
Statistics & R for Data Analysis

Statistics & R for Data Analysis

Enhance your skills in statistical analysis techniques, including hypothesis testing, regression analysis, and data visualization
Intermediate
11 Hours
Path
Mastering Visualization with Power BI

Mastering Visualization with Power BI

Gain comprehensive knowledge in key features including data transformation, modeling, DAX calculations, and visualization. Build analytical solutions surpassing traditional reporting!
Intermediate
10 Hours
Path
M Code for Power Query

M Code for Power Query

Master the art of creating visually appealing and insightful dashboards and reports using Power BI, leveraging its wide range of visualization options and features.
Intermediate
11 Hours
Path
DAX for Power BI Analysis

DAX for Power BI Analysis

Master the most in-depth and rigorous path on Power BI, gaining expert-level skills across all key pillars of analysis.
Intermediate
24 Hours

Learning

Center
61 assets
Course
Integrate ChatGPT into Excel using Macros and APIs

Integrate ChatGPT into Excel using Macros and APIs

Boost your Excel skills with ChatGPT integration! Learn how to use macros and APIs to seamlessly blend ChatGPT into Excel, enhancing both your productivity and learning experience.
Beginner
1 Hours
Course
ChatGPT for Power BI Users

ChatGPT for Power BI Users

Revolutionize your Power BI dashboards with ChatGPT! Learn simple techniques to infuse AI into your data visuals, making them more interactive and insightful.
Beginner
2 Hours
Course
SQL Fundamentals for Financial Analysis

SQL Fundamentals for Financial Analysis

A comprehensive course providing financial professionals with the fundamentals of SQL and its application in financial analysis.
Beginner
1 Hours
Course
Beginners Guide to R for Data Analysis

Beginners Guide to R for Data Analysis

This course introduces beginners to the R programming language, focusing on its application in data analysis.
Beginner
3 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
4 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
9 Hours
Course
Navigating Financial Data with Python

Navigating Financial Data with Python

Elevate your financial analytics skills with Python for Finance, exploring cutting-edge techniques for data retrieval, time series analysis, and predictive modeling.
Intermediate
1 Hours
Course
Excel to Python for Data Analysis

Excel to Python for Data Analysis

Transform your data approach with Python expertise! Transition from Excel and open the door to limitless possibilities for your projects, seamlessly moving from cells to scripts.
Beginner
1 Hours

Virtual

Events
31 assets
Podcast
Unique Data Insights In the Healthcare Space

Unique Data Insights In the Healthcare Space

Discover how data analytics saves lives in healthcare with Sam McKay and Anuj Kapoor. Learn the importance of clear problem statements and quality data.
Podcast
AI Inflection The Future of Data: Productivity and Opportunity

AI Inflection The Future of Data: Productivity and Opportunity

Explore AI's transformative power in data analytics and its impact across industries on ‘The Analytic Mind’ podcast. Learn about its broad implications.
Podcast
Embracing the AI Revolution: Navigating Disruption and Opportunities in Data Analysis

Embracing the AI Revolution: Navigating Disruption and Opportunities in Data Analysis

Explore the AI revolution's impact on data analysis with Sam in a thought-provoking episode of ‘The Analytic Mind’. Learn about its transformative effects.
Podcast
How Data Analytics Make Companies More Resilient

How Data Analytics Make Companies More Resilient

Discover why embracing change and data analytics is crucial with Sam McKay and Shiv Misra. Learn how it drives business success.
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
Power Platform Innovation Labs #2

Power Platform Innovation Labs #2

Learn how to build scalable Power Platform solutions to implement robust business processes from the world's global experts.
08:09:47 Hours
Virtual Event
Once Upon a Time: From Data to Stories

Once Upon a Time: From Data to Stories

What is a story? How should we apply the concept of storytelling to data visualization?
00:41:00 Hours
Virtual Event
DAX Is Easy, CALCULATE Makes It Hard

DAX Is Easy, CALCULATE Makes It Hard

Understand the overview of the new DAX functions – OFFSET, INDEX, WINDOW, EVALUATEANDLOG, TOJSON and TOCSV
00:47:18 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
Acing Documentation

Acing Documentation

Use the data documenter tool to create an effective report template 
Challenge
Executive Sales Report

Executive Sales Report

Create a summary report, a task that for many data analysts will always find its way across the desk every so often
Challenge
The Pursuit of Happiness

The Pursuit of Happiness

In this challenge, participants are encouraged to dive deep, explore, and come up with unique insights and visualizations.
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
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
Challenge
Discovering Shopper Segments

Discovering Shopper Segments

In this challenge, participants are encouraged to uncover distinctive shopper segments and present innovative insights.
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
Guides
48 assets
Dataset
Customer Segmentation Data

Customer Segmentation Data

This dataset provides insights into customer behavior and preferences through a loyalty program. The data includes details on customer demographics, purchase history, and feedback.
Resource
Python in Google Colab - quickstart guide

Python in Google Colab - quickstart guide

Our quickstart guide on Python in Colab offers a comprehensive overview for efficient data analysis and visualization using Google's cloud-based Jupyter notebook environment.
Resource
Data Analyst vs Data Scientist: Understanding the Key Differences

Data Analyst vs Data Scientist: Understanding the Key Differences

This comparison highlights the key differences between Data Analysts and Data Scientists, focusing on their core responsibilities, tools, and career paths within the data ecosystem.
Resource
Foundations of Microsoft Fabric

Foundations of Microsoft Fabric

Learn architecture basics, data engineering, and advanced analytics. Helping you integrate Azure services and manage scalable solutions!
Resource
Understanding Data Lakes vs. Data Warehouses

Understanding Data Lakes vs. Data Warehouses

Data lakes manage unstructured data for analytics, while data warehouses handle structured data for reporting. What’s your priority: flexibility or performance?
Resource
Batch Processing vs Real-Time Processing

Batch Processing vs Real-Time Processing

Batch processes large data sets periodically, while real-time gives you insights on the spot. Find out which is right for you!
Resource
Advanced Python for Power BI in Data Cleaning and NLP

Advanced Python for Power BI in Data Cleaning and NLP

Discover Python for data cleaning, NLP, and visualizations in Power BI, focusing on automation, text analysis, and performance optimization.
Resource
Python Beyond Excel - a comprehensive guide

Python Beyond Excel - a comprehensive guide

This comprehensive guide is designed to help data professionals transition smoothly from Excel to Python, unlocking new possibilities in data analysis, automation, and visualization.