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

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

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

Dramatically enhance Power BI's capabilities by incorporating Python's flexible and powerful data wrangling, data analysis and data visualization functionality

Build a solid foundation in using Power BI.

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

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

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

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.

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

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

Supply chain management involves the flow of goods and services.

Relationship best practices in Power BI

What’s the future of ChatGPT and its integration with MS tools

Member Case Studies

Check the Replays of the Feb 2022 Analytics Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more.

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.

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.

Challenge your data skills by producing a report that gives the user the ability to select a currency and see the associated sales and cost

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

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

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

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

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

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. 

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.