Data Analysis

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.

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

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 navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.

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.

Advanced course using Power BI & DAX to solve complex but common business problems and scenarios you'll face everyday

Integrate ChatGPT into Excel using Macros and APIs to enhance your learning experience and maximize productivity.

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

Master key data modeling and DAX concepts and techniques to optimize performance in Power BI

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

Learn all about DAX calculations in Power BI. Learn introductory theory as well as how to put it into practice when developing Power BI models. 

Boost your Excel productivity with our ChatGPT course designed to enhance your 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

Find out why pattern recognition results in faster and better understanding

Use DAX ranking techniques in your analysis

We'll be reviewing a number of techniques specifically around reporting dashboards in Power BI.

Discover various Data Time Manipulation techniques in SQL

Showcase the best practice techniques how the winning entry was built.

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

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

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

Practice your data skills and learn from what is a typical scenario faced by many businesses in various industries

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

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

An excellent opportunity for you to create a one-page data report for Covid-19 analysis

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. 

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