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.
Excel to Python for Data Analysis Cover

Paid Course

Excel to Python for Data Analysis

Join us on this journey from cells to scripts, and unlock a new realm of possibilities for your data projects.

beginner
beginner
1 Hours
Learn More chevron_right

Learning

Paths
37 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
DAX for Power BI Analysis

DAX for Power BI Analysis

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
17 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
10 Hours
Path
Security and Administration in Power BI

Security and Administration in Power BI

This Learning Path delves into advanced data analytics, focusing on implementing role-level security and measure-level security in data models. Participants will learn to manage joins, and pivot tables, and utilize calculation groups for dynamic data access and visualization.
Intermediate
2 Hours
Path
Advanced Power BI Using Python for Machine Learning

Advanced Power BI Using Python for Machine Learning

Elevate your Power BI prowess by delving into the confluence of machine learning and Python, two of the most transformative domains in data science. Our learning path, "Advanced Power BI: Harnessing Python and Machine Learning", unravels a structured approach to predictive analytics and advanced data manipulations. Through an immersive hands-on experience, you will journey from the intricacies of predictive modeling in Power BI to harnessing the versatility of Python, ensuring you're well-equipped to tackle complex analytical challenges.
Advanced
2 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
11 Hours
Path
AI-Driven Data Science: Exploring PandasAI & ChatGPT

AI-Driven Data Science: Exploring PandasAI & ChatGPT

In the modern era of data, the AI-driven approach is rapidly redefining how data science operates. Our learning path, "AI-Driven Data Science: Exploring PandasAI and ChatGPT", is crafted to immerse learners into the realms of PandasAI and ChatGPT. The path focuses on harnessing the potential of these AI tools, enabling learners to analyze, visualize, and interpret data with enhanced proficiency. From the foundational principles of data analysis with PandasAI to the expansive capabilities of ChatGPT in data science, this path offers a comprehensive journey into the world of AI-powered data analytics.
Intermediate
4 Hours
Path
Advanced Excel: Mastering Pivot Tables and Data Analysis

Advanced Excel: Mastering Pivot Tables and Data Analysis

This Learning Path delves into advanced features, teaching students to efficiently utilize tables, automate formulas, and harness tools like Power Query and Pivot for dynamic data analysis and reporting. Master techniques for data extraction, transformation, and visualization in Excel.
Intermediate
7 Hours

Learning

Center
41 assets
Course
Excel to Python for Data Analysis

Excel to Python for Data Analysis

Join us on this journey from cells to scripts, and unlock a new realm of possibilities for your data projects.
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
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
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
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
Data Literacy for Beginners

Data Literacy for Beginners

Discover the key to unlocking insights and making informed decisions through data.
Beginner
1 Hours
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
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

Virtual

Events
109 assets
Podcast
Embracing the AI Revolution: Navigating Disruption and Opportunities in Data Analysis

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

Join Sam in this thought-provoking episode of ‘The Analytic Mind’, as he delves into the heart of the AI revolution and its transformative impact on data analysis.
Podcast
AI Inflection The Future of Data: Productivity and Opportunity

AI Inflection The Future of Data: Productivity and Opportunity

In this episode of ‘The Analytic Mind’ podcast, join us as we delve deep into the transformative power of AI in the data analytics space and its broader implications across various industries.
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
Predicting Future Outcomes w/Power BI

Predicting Future Outcomes w/Power BI

Learn how to developed compelling dashboards within Power BI using a range of analytical and visualisation techniques
01:04:24 Hours
Virtual Event
Storytelling with Data

Storytelling with Data

Understand how to provide context to your visualisations to present arguments rather than statements
01:16:01 Hours
Virtual Event
Forecasting Analysis in Python

Forecasting Analysis in Python

Master complex data model techniques especially when running forecasting analysis
00:49:56 Hours

Project

Center
34 assets
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
Demo Challenge 1 - Divergence in Trends

Demo Challenge 1 - Divergence in Trends

Showcase a Power BI report example where you showcase a divergence in trends over time.
Challenge
Data Challenge 1: The Pursuit of Happiness: A Decade’s Exploration

Data Challenge 1: The Pursuit of Happiness: A Decade’s Exploration

In this challenge, participants are encouraged to dive deep, explore, and come up with unique insights and visualizations.
Challenge
Hotels Revenue Management

Hotels Revenue Management

Take on the challenge of creating an analysis report on hotels revenue management data.
Challenge
Consumers Analysis - Annual Consumer Analysis

Consumers Analysis - Annual Consumer Analysis

Analyse the shopping activities of consumer for the last 3 years
Challenge
Covid 19 Reporting

Covid 19 Reporting

An excellent opportunity for you to create a one-page data report for Covid-19 analysis
Challenge
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
Challenge
Delivery App Review

Delivery App Review

Create a report or dashboard to help management visualize what is happening on the new app
Resources
9 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
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
Starting Out Learning Power BI from Scratch in 2023

Starting Out Learning Power BI from Scratch in 2023

Embark on your Power BI journey in 2023 with these expert insights. This guide offers a comprehensive roadmap for both beginners and seasoned professionals.
Resource
Constructing lists in Power Query/M

Constructing lists in Power Query/M

The Power Query M language constructs lists, which are ordered sequences of comma-delimited values enclosed in curly brackets, capable of holding any type of value, and are lazily evaluated, potentially supporting infinite elements.
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
Exploring Splitter.SplitTextByWhitespace in Power Query/ M

Exploring Splitter.SplitTextByWhitespace in Power Query/ M

Learn how to effectively use this function in various real-world scenarios. It also demonstrates how this function can handle different types of whitespace characters
Resource
Data Solopreneur Opportunities - A Guide

Data Solopreneur Opportunities - A Guide

Explore a myriad of opportunities in the data industry with this guide, a resource aimed at empowering individuals to leverage their data skills for independent success.
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!