Data Analysis

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.

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.

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.

This path is designed to provide you the necessary skills to build full enterprise apps by integrating Power BI , Power Automate and Power Apps. 

This Learning Path dives into SharePoint and Power Apps, focusing on leveraging Power Automate for task automation and improved user interaction. 

This Learning Path delves into Power BI development, focusing on creating effective reports and visualizations. It covers parameter management, using PowerPoint and more!

This Learning Path delves into data manipulation and analysis using SQL and DAX. It covers techniques and practical code examples.

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).

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.

Enhance your Power BI reports and analysis with R's visualization, text analysis and statistical modeling capabilities.

Review some of the best practices to refine your Power BI development skills

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

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.

Advanced course using Power BI & DAX to solve complex but common business problems and scenarios you'll face everyday

Level up your SQL query fluency even without prior SQL experience.

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.

Listen as Sam McKay talks to Shiv Misra on why companies need to have an appetite for change and embrace data analytics

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

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

Discover how to visualize, debug, validate and solve complex DAX problems using Excel

Learn how to developed compelling dashboards within Power BI using a range of analytical and visualisation techniques

The different admin roles related to Power BI

Join a casual conversation with Sam and the Power BI Challenge Winner, Greg.

Solve advanced analytical questions using Power BI

Identify trends and patterns in a variety of factors that influence the cost of living in different regions around the world by using statistical analysis techniques and visualization tools.

Work on one of the most significant measures for manufacturing productivity - OEE

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

Create a report summary of the overall services provided by a Call Centre for its management

Develop an analysis report about the Football/Soccer Players Summer Transfers Season 2022-23

Analyze the data of a medical emergency response service and discover opportunities for improvement on their process

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

Take on the challenge of creating an analysis report on hotels revenue management data.

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.

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!

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. 

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