Data Analysis

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

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 delves into Power BI development, focusing on creating effective reports and visualizations. It covers parameter management, using PowerPoint and more!

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 techniques, focusing on Power BI functions. It guides learners to enhance their data insight extraction skills.

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

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

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.

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

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. 

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.

Unlock the power of data analysis and visualization with PandasAI, and transform raw data into actionable insights that drive decision-making and growth.

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

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

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

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

What is a story? How should we apply the concept of storytelling to data visualization?

Discover how to add formatting tricks to visuals using DAX expressions

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

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

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

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

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

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

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

Produce insights for management level that can highlight any issues and prepare them for the audit

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

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.

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.