Data Analysis

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

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 modeling, focusing on Filter and Row Contexts for data computations, and the use of functions like SUM, SUMX, and Calculate.

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

Ace the Microsoft Power Platform (PL-900) Certification exam with our complete training guide

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

Expand Power BI's capabilities in accessing a wide range of data using APIs

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

Implement advanced & practical analytical techniques inside of Power BI and find insights you never thought possible in an intuitive way

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

Prepare for PL-300: Microsoft Power BI Data Analyst Exam to earn the Power BI  Data Analyst Associate certification

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

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

Find out why pattern recognition results in faster and better understanding

Learn key principles from user experience and design and how to thoughtfully integrate them into your data viz workflow.

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

Review discrete events with scenario applied

Discover how to add, view, edit, delete data from Microsoft Dataverse

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

Analyze Enterprise DNA's Youtube Channel Data to understand its audience and create a strategy to drive more channel engagement.

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

Jump into this twitter related dataset and showcase some interesting insights based on the text of the tweet and the stock reference or tagged within the tweet itself.

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

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

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

Create a summary report, a task that for many data analysts will always find its way across the desk every so often

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!

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.