Data Analysis

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

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 in statistical analysis and inference equips learners with practical skills to conduct tests, estimate sample sizes, and understand test assumptions. 

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 is designed to help you harness the full power of Power BI in combination with R and Python. You will learn how to conduct advanced analyses and gain insight into complex business questions.

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

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

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

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

Master the most powerful tool for data modeling and DAX calculations in Power BI and Analysis Services

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

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

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

Learn how to transfer your knowledge of SQL to DAX and vice versa

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. 

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

Showcase how to implement an SCD Type 2 using Power Query to allow a full historical analysis of a specific dimension

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

Learn how you can create, share, and deploy applications and streamline processes across your organization using PowerApps and Power Automate

Solve advanced analytical questions using Power BI

Data story telling is an important part of the report development process. It changes the way the audience views reports.

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

Use the data documenter tool to create an effective report template 

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

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.

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

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

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

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

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. 

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!