Data Analysis

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 delves into data manipulation and analysis using SQL and DAX. It covers techniques and practical code examples.

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

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

This Learning Path delves into data analysis techniques, focusing on Power BI functions. It guides learners to enhance their data insight extraction skills.

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

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.

Advanced course using Power BI & DAX to solve complex but common business problems and scenarios you'll face everyday

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

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

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

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

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

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

Learn a range of advanced techniques in Power BI using DAX

Showcase the best practice techniques how the winning entry was built.

Use DAX ranking techniques in your analysis

WORKOUTS is an innovative approach that combines hands-on exercises, practical applications, and collaborative learning to help data practitioners master data skills effectively.

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

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

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

An opportunity to design and build a report that gives insights into customer behavior

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

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

Create a navigation experience that showcases your brand and keeps users coming back for more by prioritizing the user experience and considering the needs and preferences of your target audience.

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

Show off your impressive financial report! We are confident that your financial report is a testament to your skills and expertise. We would love to see how you've structured it and how you've made it visually appealing.

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. 

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