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 dives into SharePoint and Power Apps, focusing on leveraging Power Automate for task automation and improved user interaction. 

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

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.

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

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

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

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

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

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

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

Review some of the best practices to refine your Power BI development skills

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.

Build a solid foundation in using Power BI.

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

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

Explore structured columns containing Lists, Records or Tables

Understand how to provide context to your visualisations to present arguments rather than statements

Join a casual conversation with Sam and the Power BI Challenge Winner, Greg.

Introducing Power BI Geospatial Analysis for building compelling and dynamic maps in reports.

Learn number of ways to create new visualizations and features including layering visuals, customizing visual formatting, and/or utilizing DAX measures

Develop an analysis report about the Football/Soccer Players Summer Transfers Season 2022-23

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

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.

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

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

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.

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

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