The Skills Hub (Pty) Ltd logo
IntermediateData & Analytics

Data Analytics with Excel & Power BI

Turn raw data into decisions. Learn the analytics toolkit employers are hiring for right now.

6 weeksIntermediate Aisha Naidoo
Data Analytics with Excel & Power BI

About this course

Every organisation is drowning in data and short on people who can make sense of it. This course teaches you to clean, analyse and visualise data using Excel and Power BI, and to tell a clear story with dashboards that drive decisions.

What you'll learn

  • Clean and prepare messy real-world datasets
  • Analyse data with advanced Excel functions
  • Model data and write DAX measures in Power BI
  • Design interactive dashboards that inform decisions
  • Present insights clearly to non-technical stakeholders

Course outline

1

Data Foundations

  • Data types & sources
  • Cleaning & preparation
  • Excel for analysis
2

Power BI

  • Connecting data sources
  • Data modelling
  • DAX basics
3

Visualisation

  • Designing dashboards
  • Interactive reports
  • Storytelling with data

Upcoming intakes

25 August 20266 October 2026
Online45 seats

Your instructor

A

Aisha Naidoo

Aisha is a data analyst who has built reporting for retail and healthcare organisations across South Africa.