Data Analysis

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 the most in-depth and rigorous on the list, designed to provide you expert-level skills in all of the key pillars of Power BI. 

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 Learning Path delves into advanced data analytics, focusing on implementing role-level security and measure-level security in data models. Participants will learn to manage joins, and pivot tables, and utilize calculation groups for dynamic data access and visualization.

Elevate your Power BI prowess by delving into the confluence of machine learning and Python, two of the most transformative domains in data science. Our learning path, "Advanced Power BI: Harnessing Python and Machine Learning", unravels a structured approach to predictive analytics and advanced data manipulations. Through an immersive hands-on experience, you will journey from the intricacies of predictive modeling in Power BI to harnessing the versatility of Python, ensuring you're well-equipped to tackle complex analytical challenges.

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

In the modern era of data, the AI-driven approach is rapidly redefining how data science operates. Our learning path, "AI-Driven Data Science: Exploring PandasAI and ChatGPT", is crafted to immerse learners into the realms of PandasAI and ChatGPT. The path focuses on harnessing the potential of these AI tools, enabling learners to analyze, visualize, and interpret data with enhanced proficiency. From the foundational principles of data analysis with PandasAI to the expansive capabilities of ChatGPT in data science, this path offers a comprehensive journey into the world of AI-powered data analytics.

This Learning Path delves into advanced features, teaching students to efficiently utilize tables, automate formulas, and harness tools like Power Query and Pivot for dynamic data analysis and reporting. Master techniques for data extraction, transformation, and visualization in Excel.

Join us on this journey from cells to scripts, and unlock a new realm of possibilities for your data projects.

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

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

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

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. 

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

A detailed step-by-step process of creating high-quality Power BI reports that satisfy the requirements of real-world scenarios

Boost your Excel productivity with our ChatGPT course designed to enhance your skills!

Join Sam in this thought-provoking episode of ‘The Analytic Mind’, as he delves into the heart of the AI revolution and its transformative impact on data analysis.

In this episode of ‘The Analytic Mind’ podcast, join us as we delve deep into the transformative power of AI in the data analytics space and its broader implications across various industries.

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

Learn how to developed compelling dashboards within Power BI using a range of analytical and visualisation techniques

Understand how to provide context to your visualisations to present arguments rather than statements

Master complex data model techniques especially when running forecasting analysis

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

Showcase a Power BI report example where you showcase a divergence in trends over time.

In this challenge, participants are encouraged to dive deep, explore, and come up with unique insights and visualizations.

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

Analyse the shopping activities of consumer for the last 3 years

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

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

Create a report or dashboard to help management visualize what is happening on the new app

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

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.

Embark on your Power BI journey in 2023 with these expert insights. This guide offers a comprehensive roadmap for both beginners and seasoned professionals.

The Power Query M language constructs lists, which are ordered sequences of comma-delimited values enclosed in curly brackets, capable of holding any type of value, and are lazily evaluated, potentially supporting infinite elements.

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. 

Learn how to effectively use this function in various real-world scenarios. It also demonstrates how this function can handle different types of whitespace characters

Explore a myriad of opportunities in the data industry with this guide, a resource aimed at empowering individuals to leverage their data skills for independent success.

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!