Data Analyst Resources

Introduction to Excel

In this course, you’ll learn to prepare, visualize, and analyse data through practical exercises.

Master essential skills like using PivotTables, V-Lookups, and Excel formulas to ready your data for analysis, and then create professional visualisations and dashboards.

Advance further by exploring powerful features such as the What-if tool for sensitivity and scenario analysis, and dive into predictive analysis with Excel’s forecasting capabilities – equipping you with the skills to perform real-world data analysis using Excel.

Associate Data Analyst in SQL

With no prior SQL skills required, this course will guide you through the essentials of working with data.

You’ll start by learning how to create basic SQL queries, before moving on to grouping and aggregating data to produce meaningful summary statistics. You’ll also explore how to join tables, apply filters, and work with sub-queries to uncover deeper insights.

As your skills progress, you’ll learn to develop functions that allow you to explore and manipulate data more effectively. Finally, the course will show you how to present your findings in a clear and impactful way to stakeholders.

Associate Data Analyst in Python

Python is one of the most widely used programming languages globally and key for Data Analyst.

This course requires no prior coding experience; you’ll start from the basics and learn how to import, clean, manipulate, and visualise data—crucial skills for any aspiring data professional or researcher.

Your training will include interactive exercises, giving you hands-on experience with popular Python libraries such as pandas, NumPy, and Seaborn. You’ll discover why Python is a top choice for data analysis and work with real-world datasets to enhance your data manipulation and exploratory data analysis abilities.

As you progress, you’ll delve into topics like data manipulation, joining data, and key statistical skills such as hypothesis testing.

Data Analyst in Tableau

Discover how to excel in data analysis with Tableau, one of the most popular business intelligence tools in the world.

You’ll begin with the basics, learning how to analyse data and create dashboards, then apply your new Tableau skills through practical exercises and case studies.

You’ll master connecting to data sources, creating compelling visualisations, and utilising Tableau’s features to your advantage. The course also covers advanced calculations and statistical techniques.

PL-300: Microsoft Power BI Data Analyst

This course explores the diverse methods and best practices for modelling, visualising, and analysing data with Power BI, aligning with both business and technical requirements.

It covers how to access and process data from a variety of sources, including relational and non-relational databases.

Additionally, the course addresses managing and deploying reports and dashboards for sharing and distributing content.

Microsoft Azure Data Fundamentals

Learn the core concepts of data and how they are managed in the cloud. The course covers different types of data (structured, unstructured, and semi-structured), database concepts, and key services within Microsoft Azure for relational and non-relational data.

Students also explore data storage options, analytics workloads, and basics of data security and compliance in Azure.

AI-900: Microsoft Azure AI Fundamentals

In this course you’ll learn skills that validate a foundational understanding of artificial intelligence (AI) and machine learning (ML) concepts, particularly in the context of Microsoft Azure.

It covers key AI topics such as machine learning, computer vision, natural language processing (NLP), and conversational AI, along with responsible AI principles.