Data Analysis

This learning path provides a thorough understanding of SQL, emphasizing key commands for data manipulation and querying. 

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 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 enables individuals to proficiently use Power BI and other Power Platform tools. It prepares business analysts for the PL-900 exam.

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 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 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 help you become an expert in data visualization, data storytelling, and report design. You will learn how to create advanced custom visualizations using bespoke visualization languages.

Build a solid foundation in using Power BI.

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

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

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

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

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

Review some of the best practices to refine your Power BI development skills

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

Creating basic tables and figures with R to check assumptions and communicate findings

Prepare, profile and analyze data in Excel workbooks

Understand the overview of the new DAX functions – OFFSET, INDEX, WINDOW, EVALUATEANDLOG, TOJSON and TOCSV

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

Review a number of techniques specifically around developing high quality reporting solutions in Power BI.

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.

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.

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

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.

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

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

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

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

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!

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