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

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

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

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

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

Learn how to predict and optimize for results in the future, by utilizing 'what if' parameters and scenario analysis techniques

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

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

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.

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.

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

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

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

Explore structured columns containing Lists, Records or Tables

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

Solve advanced analytical questions using Power BI

Learn the basics of data types in Power Query and some helpful hints

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

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded

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

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

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

Use the data documenter tool to create an effective report template 

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

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!

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