Data Analysis

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 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 Learning Path enables individuals to proficiently use Power BI and other Power Platform tools. It prepares business analysts for the PL-900 exam.

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

This Learning Path in statistical analysis and inference equips learners with practical skills to conduct tests, estimate sample sizes, and understand test assumptions. 

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

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. 

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.

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

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

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

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. 

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

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

Dramatically enhance Power BI's capabilities by incorporating Python's flexible and powerful data wrangling, data analysis and data visualization functionality

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

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

The different admin roles related to Power BI

What’s the future of ChatGPT and its integration with MS tools

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

Learn how usability testing can reveal crucial usability information not revealed by A/B testing, focus groups, or surveys

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

Use the data documenter tool to create an effective report template 

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

Implement your analytical skills in creating a report of the entire business operation from production to forecasting.

Provide a business solution by creating an intelligence tool to use by large opticians

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

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

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

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. 

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