Data Analysis

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

This Learning Path in statistical analysis and inference equips learners with practical skills to conduct tests, estimate sample sizes, and understand test assumptions. 

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

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

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

Build a strong foundation on your MS Excel skills as you progress to advanced level

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. 

Discover the key to unlocking insights and making informed decisions through data.

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

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.

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

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

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!

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

Develop complex Power BI solutions

Supply chain management involves the flow of goods and services.

Learn how to developed compelling dashboards within Power BI using a range of analytical and visualisation techniques

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

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

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

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

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

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

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

Use the data documenter tool to create an effective report template 

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. 

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.

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!