Data Analysis

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 dives into SharePoint and Power Apps, focusing on leveraging Power Automate for task automation and improved user interaction. 

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 provides a thorough understanding of SQL, emphasizing key commands for data manipulation and querying. 

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 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 provide you the necessary skills to build full enterprise apps by integrating Power BI , Power Automate and Power Apps. 

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.

Master the most powerful tool for data modeling and DAX calculations in Power BI and Analysis Services

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

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

Ace the Microsoft Power Platform (PL-900) Certification exam with our complete training guide

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

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

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

Analyzing your data set in comprehensive way to get a better understanding

Use DAX ranking techniques in your analysis

Explore structured columns containing Lists, Records or Tables

Create time based cohort insights within Power BI.

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

Implement your analytical skills in creating a report of the entire business operation from production to forecasting.

Challenge your data skills in creating an analysis report on substance

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

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

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 

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

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.