Data Analysis

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 delves into data analysis techniques, focusing on Power BI functions. It guides learners to enhance their data insight extraction skills.

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

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

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

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

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

Dive deeper into using ChatGPT for data science tasks. Explore techniques for data preprocessing, feature engineering, model training, and deploying ChatGPT models for specific data analysis and prediction tasks.

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

Unlock the power of data analysis and visualization with PandasAI, and transform raw data into actionable insights that drive decision-making and growth.

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

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

Listen as Sam McKay talks to Shiv Misra on why companies need to have an appetite for change and embrace data analytics

Improve and transform the way sustainable energy is managed and generate value across energy production, supply, distribution, and consumption using data-driven insights

Explore how artificial intelligence (AI) can be leveraged to create powerful analytics notebooks that can streamline data analysis workflows and enhance productivity.

What should you consider when putting your carefully-researched data together for an audience? Get the tips for using the right tools for each job.

Develop complex Power BI solutions

Find out why pattern recognition results in faster and better understanding

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

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

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded

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

Use the data documenter tool to create an effective report template 

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

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

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

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.