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.
ChatGPT to Improve Productivity in Excel Cover

Paid Course

ChatGPT to Improve Productivity in Excel

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!

beginner
beginner
1 Hours
Learn More chevron_right

Learning

Paths
37 assets
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
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
5 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
8 Hours
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
32 Hours
Path
Financial Analysis and Reporting in Power BI

Financial Analysis and Reporting in Power BI

This Learning Path delves into advanced data modeling techniques, focusing on Power BI and Enterprise DNA tools. Participants will learn to automate financial reports, utilize dynamic grouping formulas, and integrate various data sources for comprehensive analysis.
Intermediate
10 Hours
Path
Advanced Visualizations and Dashboarding with Power BI

Advanced Visualizations and Dashboarding with Power BI

This Learning path delves into transformative data visualization techniques. Elevate your presentations, ensuring clarity and swift comprehension for your audience.
Intermediate
8 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
13 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
16 Hours

Learning

Center
52 assets
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
Excel for Data Analytics: Leveraging Excel's Power for Data Analysis

Excel for Data Analytics: Leveraging Excel's Power for Data Analysis

Mastering Excel for Comprehensive Data Analysis
Beginner
2 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
Artificial Neural Networks 101: Intro to Deep Learning

Artificial Neural Networks 101: Intro to Deep Learning

Unraveling the Mystique: A Beginner's Dive into Neutral Networks.
Intermediate
1 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
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
ChatGPT for Power BI Users

ChatGPT for Power BI Users

Discover how to utilize ChatGPT within Power BI for enhanced data analysis, reporting, and interactive dashboards. Learn how to integrate ChatGPT into Power BI to create dynamic and conversational visualizations.
Beginner
2 Hours
Course
Python-Powered Marketing: Strategies and Insights with ChatGPT Integration

Python-Powered Marketing: Strategies and Insights with ChatGPT Integration

Elevate your marketing capabilities by integrating Python's robust analytical and data visualization tools, enhancing marketing strategies with insights powered by Python.
Intermediate
1 Hours

Virtual

Events
110 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
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
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
Power BI Freestyle Session w/ Sam McKay - Oct 15th

Power BI Freestyle Session w/ Sam McKay - Oct 15th

Power BI Freestyle Session w/ Sam McKay
01:10:33 Hours
Virtual Event
Power Query Going Back To Basics

Power Query Going Back To Basics

Learn the basics of data types in Power Query and some helpful hints
00:51:53 Hours

Project

Center
35 assets
Challenge
Emergency Services Analytics

Emergency Services Analytics

Analyze the data of a medical emergency response service and discover opportunities for improvement on their process
Challenge
Marketing Analytics - Measuring ROI

Marketing Analytics - Measuring ROI

Analyze data from marketing campaigns and initiatives, using visualization tools and statistical analysis techniques to identify trends and patterns, and use these insights to inform marketing strategy and decision-making.
Challenge
Environmental Data Reporting

Environmental Data Reporting

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded
Challenge
Business Intelligence - Exploratory Data Analysis

Business Intelligence - Exploratory Data Analysis

Create a Power BI report that showcases the differences in sales between two different regions
Challenge
Consumers Analysis - Annual Consumer Analysis

Consumers Analysis - Annual Consumer Analysis

Analyse the shopping activities of consumer for the last 3 years
Challenge
Twitter Threads Analysis

Twitter Threads Analysis

Jump into this twitter related dataset and showcase some interesting insights based on the text of the tweet and the stock reference or tagged within the tweet itself.
Challenge
Timesheet Utilisation Reporting

Timesheet Utilisation Reporting

Take a deep dive into the world of utilisation and timesheet data
Challenge
Call Center Data Reporting

Call Center Data Reporting

Create a report summary of the overall services provided by a Call Centre for its management
Guides
11 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
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
2023 Data Career Guide

2023 Data Career Guide

This guide will empower you with insights into various roles, practical experience acquisition, navigating the job market, and upskilling opportunities.
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
How To Become The Most High-Value Data Person In Your Organization

How To Become The Most High-Value Data Person In Your Organization

This infographic offers a clear and straightforward guide to enhancing your role in your organization through data skills.
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 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
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.