Data Analysis

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 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 delves into data analysis and visualization using both R and Python, covering data cleaning, data frames, and the use of packages like dplyr, tidyverse, skim R, and seaborn. It offers hands-on examples, such as creating various plots, performing group-based operations, and utilizing descriptive statistics for effective data interpretation.

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

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

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 navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.

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.

Learn valid inference techniques for two-sample and two-variable data questions.

Master key data modeling and DAX concepts and techniques to optimize performance in Power BI

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.

A detailed step-by-step process of creating high-quality Power BI reports that satisfy the requirements of real-world scenarios

Amplify your Power BI visualizations with R's comprehensive statistical analysis and graphics language

Clean data and perform Natural Language Processing through Python's functions, algorithms and programming methods

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.

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

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

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

Showcase the best practice techniques how the winning entry was built.

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.

Learn advanced scenario analysis techniques and enhance your related distinct counts

Create reusable, templatized offset measures to further simplify and speed DAX analyses

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

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

Create a navigation experience that showcases your brand and keeps users coming back for more by prioritizing the user experience and considering the needs and preferences of your target audience.

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

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

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.

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

Deep dive into the world of F1 and create an analysis of the drivers' stats

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

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!

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

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.