Data Analysis

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.

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. 

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.

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.

This learning path provides a thorough understanding of SQL, emphasizing key commands for data manipulation and querying. 

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

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. 

Integrate ChatGPT into Excel using Macros and APIs to enhance your learning experience and maximize productivity.

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.

Build a strong foundation on your MS Excel skills as you progress to advanced level

Implement advanced & practical analytical techniques inside of Power BI and find insights you never thought possible in an intuitive way

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

A practical guide to recognizing, understanding, and managing uncertainty in data 

Build a solid foundation in using Power BI.

Ace the Microsoft Power Platform (PL-900) Certification exam with our complete training guide

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

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

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

Boost your productivity and performance by mastering Microsoft’s latest technology updates

On this session, Cristiano Galvao MVP will cover the impact of recent changes in Excel that unleash the power of formulas. 

In this session, Matt Allington will provide an absolute beginner’s walkthrough of the tool and how it can be used to make your life easier.

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

Analyzing your data set in comprehensive way to get a better understanding

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

Create a report or dashboard to help management visualize what is happening on the new app

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

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

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.

Practice your data skills and learn from what is a typical scenario faced by many businesses in various industries

Challenge your data skills by creating a report on transport and shipping data 

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded

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

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!

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.

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.