Data Analysis

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

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.

This Learning Path delves into Power BI development, focusing on creating effective reports and visualizations. It covers parameter management, using PowerPoint and more!

This path is designed to help you harness the full power of Power BI in combination with R and Python. You will learn how to conduct advanced analyses and gain insight into complex business questions.

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

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

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.

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

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

Learn valid inference techniques for two-sample and two-variable data questions.

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

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. 

Take your Excel skills to the next level with this intermediate course focused on Macros, VBA (Visual Basic for Applications), and automation.

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

One of the break-out session in our Reporting & Data Visualization Summit, showcasing a variety of beginner to advanced Power BI tips and techniques.

Discover how to visualize, debug, validate and solve complex DAX problems using Excel

On this session, Cristiano Galvao MVP will cover the impact of recent changes in Excel that unleash the power of formulas. 

Master complex data model techniques especially when running forecasting analysis

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

Produce insights for management level that can highlight any issues and prepare them for the audit

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

Identify trends and patterns in a variety of factors that influence the cost of living in different regions around the world by using statistical analysis techniques and visualization tools.

Take a deep dive into the world of utilisation and timesheet data

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

An opportunity to design and build a report that gives insights into customer behavior

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

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. 

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.

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