Data Analysis

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

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

This Learning Path dives into SharePoint and Power Apps, focusing on leveraging Power Automate for task automation and improved user interaction. 

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 help you build expert level skills in the implementation, monitoring and governance of Power BI, including making optimal use of the Service through dataflows, datasets, thin reports, etc.

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

This path is similar to the Data Analyst learning path above, but is geared to building a strong and broad foundation of data analysis skills, as compared to being more specifically focused on passing the PL 300 exam.

Integrate ChatGPT into Excel using Macros and APIs to enhance your learning experience and maximize productivity.

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

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

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

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

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.

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

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

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

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

Review a number of techniques specifically around dashboarding in Power BI.

Know the the importance on reading about data visualization theory and the benefits of Zebra BI visuals for Power BI reports

Learn how to combine queries to protect the fact tables in the tabular model

Learn what sells well together and analyze product sales for upsell opportunities and

Create a report or dashboard to help management visualize what is happening on the new app

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

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

Use the data documenter tool to create an effective report template 

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

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

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

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

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. 

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!

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

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.