Data Analysis

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

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

Level up your SQL query fluency even without prior SQL experience.

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

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

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

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

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.

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.

Amplify your Power BI visualizations with R's comprehensive statistical analysis and graphics language

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

Create time based cohort insights within Power BI.

Explore the applications of ChatGPT in the field of data analytics.

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

Critical thinking to improve problem solving and decision making

Solve advanced analytical questions using Power BI

Analyze data from marketing campaigns and initiatives, using visualization tools and statistical analysis techniques to identify trends and patterns, and use these insights to inform marketing strategy and decision-making.

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

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

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.

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

Identify trends and patterns in a variety of factors that influence the cost of living in different regions around the world by using statistical analysis techniques and visualization tools.

Use the data documenter tool to create an effective report template 

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

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!

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.