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

This path will provide you in-depth knowledge of the full range of Power BI best practices, with particular emphasis on building data models specifically optimized for Power BI.

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

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.

Dive into data with Python! Transform raw data into actionable insights, mastering data preparation, wrangling, and modeling. Start your data science journey today.

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

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

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

Discover the Langchain platform and learn how to build and deploy language models using its powerful tools and APIs. Explore custom training, fine-tuning, and deployment options.

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

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.

Enhance your Power BI reports and analysis with R's visualization, text analysis and statistical modeling capabilities.

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

Relationship best practices in Power BI

Critical thinking to improve problem solving and decision making

Combining the power of the data model with high level analysis

What is a story? How should we apply the concept of storytelling to data visualization?

Boost your productivity and performance by mastering Microsoft’s latest technology updates

Create a report summary of the overall services provided by a Call Centre for its management

Jump into this twitter related dataset and showcase some interesting insights based on the text of the tweet and the stock reference or tagged within the tweet itself.

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

Analyze the data of a medical emergency response service and discover opportunities for improvement on their process

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

Work on one of the most significant measures for manufacturing productivity - OEE

Challenge your data skills in creating an analysis report on substance

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

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. 

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.