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

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

This Learning Path provides a deep dive into Power BI and DAX, focusing on data analysis techniques and visualization. It equips learners with skills to craft dynamic visualizations.

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.

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. 

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.

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

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

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.

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.

Dive deeper into using ChatGPT for data science tasks. Explore techniques for data preprocessing, feature engineering, model training, and deploying ChatGPT models for specific data analysis and prediction tasks.

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

Challenge Submission Review

Learn how to combine queries to protect the fact tables in the tabular model

Explore how artificial intelligence (AI) can be leveraged to create powerful analytics notebooks that can streamline data analysis workflows and enhance productivity.

Know the techniques how to be strategic in your workbook development through the use of query referencing and duplicating

Discover various Data Time Manipulation techniques in SQL

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

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

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

Analyze the data of a large insurance company who are due to undergo an internal audit with regard to its complaint’s procedure

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

Challenge your data skills in creating an analysis report on substance

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

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.