Data Analysis

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 in statistical analysis and inference equips learners with practical skills to conduct tests, estimate sample sizes, and understand test assumptions. 

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

This Learning Path navigates learners through real-world scenarios to cultivate problem-solving skills using the M language in Power Query.

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 visualization using both R and Python, covering data cleaning, data frames, and the use of packages like dplyr, tidyverse, skim R, and seaborn. It offers hands-on examples, such as creating various plots, performing group-based operations, and utilizing descriptive statistics for effective data interpretation.

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.

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

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.

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

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

Amplify your Power BI visualizations with R's comprehensive statistical analysis and graphics language

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

An in depth overview of the entire Power BI suite, with a focus on using Power BI to extract compelling insights from your own data.

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

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 a casual conversation with Sam and the Power BI Challenge Winner, Greg.

View Replays of the August 2022 Business Intelligence Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more...

The different admin roles related to Power BI

Discover various Data Time Manipulation techniques in SQL

Learn number of ways to create new visualizations and features including layering visuals, customizing visual formatting, and/or utilizing DAX measures

Use the data documenter tool to create an effective report template 

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

Challenge your data skills in creating an analysis report on substance

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

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

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

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.

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

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