Data Analysis and Visualisation with Excel and Power BI

Data only drives decisions when it is clean, modelled, and told well. This live cohort gives you a clear, repeatable workflow from raw data to insight. You will learn to shape data with Power Query, build models and measures with DAX, design dashboards that people actually use, and communicate findings with confidence. Practical, tool driven, and designed for learners in Africa and the diaspora.

Who this is for

• Early career analysts, operations and finance professionals
• Product, marketing, and customer teams that report on KPIs
• Graduates and career switchers building an analytics portfolio
• Anyone who wants to turn spreadsheets into decisions

What you will build

• A data cleaning toolkit with repeatable Power Query steps
• A reusable data model with relationships and DAX measures
• An interactive dashboard with drill through, bookmarks, and slicers
• A metrics pack that defines KPIs and business logic
• A short storytelling deck for leadership updates
• A portfolio case study you can share with hiring managers

The 8-week journey at a glance

We move from data sourcing and cleaning, into modelling and DAX, then visual design and accessibility, followed by publishing, refresh, and governance. You will practise on realistic datasets, add your own context, and finish with a capstone dashboard and a concise narrative that explains the why behind the numbers.

How it runs

• Three live sessions weekly, recordings available
• Weekly clinic and community support
• Datasets and templates provided, with an optional bring-your-data clinic
• Requires Excel and Power BI Desktop on Windows, or Power BI Service through a browser

Outcome

You leave work ready with a disciplined analysis workflow, a credible dashboard portfolio, and the confidence to answer business questions with evidence.

Apply now to reserve your seat, or talk to us about a corporate cohort.