Data Science · 8-week live cohort

Data Analysis & Visualisation with Excel and Power BI

Build a disciplined workflow from raw data to useful analysis.

Learn to clean and shape data with Power Query, model it with DAX, design dashboards people can use, and communicate findings with confidence.

Next cohort

Next cohort details will be published when confirmed.

Register interest
The programme standard

Understand it. Practise it. Produce evidence.

ClarityKnow the concepts and reasoning behind the work.
PracticeUse tools and methods in realistic tasks.
EvidenceLeave with practical outputs you can inspect and explain.
How the work fits together

The analysis workflow

Good reporting is a sequence of decisions, not a collection of charts.

The strongest outcome is not the dashboard alone. It is the reasoning that makes the dashboard trustworthy.
01Prepare

Clean and shape source data with repeatable Power Query steps.

02Model

Define relationships and measures that represent the business logic.

03Visualise

Design dashboards around the questions people need to answer.

04Explain

Turn the evidence into a concise decision-ready narrative.

Programme overview

Data Analysis & Visualisation with Excel and Power BI

Learn to clean and shape data with Power Query, model it with DAX, design dashboards people can use, and communicate findings with confidence.

01
Prepare data properlyUse repeatable Power Query steps to clean, reshape and combine source data.
02
Model the business logicBuild relationships and DAX measures that reflect the questions the analysis needs to answer.
03
Design for useCreate dashboards with useful interactions, clear hierarchy and accessible visual choices.
04
Communicate the evidenceTurn analysis into concise findings and a narrative suitable for decision-makers.

What you will build

Practical work that makes progress visible.

01 · Output
Power Query cleaning toolkit

Reusable steps for handling common data-quality problems.

02 · Output
Reusable data model

Relationships and DAX measures built for analysis.

03 · Output
Interactive dashboard

Drill-through, bookmarks, slicers and purposeful visual design.

04 · Output
KPI and metrics pack

Clear definitions for the measures used in the dashboard.

05 · Output
Leadership storytelling deck

A concise way to explain what changed, why it matters and what needs attention.

06 · Output
Capstone case study

A complete analysis you can explain to a hiring manager or professional audience.

Programme journey

A clear progression through the work.

Weeks 1–2

Source, inspect and clean the data

Work with realistic datasets and establish repeatable Power Query steps.

Weeks 3–4

Build the model and measures

Structure relationships, define business logic and develop DAX measures.

Weeks 5–6

Design the dashboard

Turn the model into clear, usable visual analysis.

Week 7

Publish, refresh and govern

Understand sharing, refresh and responsible management of reporting assets.

Week 8

Capstone and narrative

Bring the workflow together in a polished dashboard and concise explanation.

Who this is for

Built for people who need the capability in practice.

Early-career analysts
Operations and finance professionals
Product, marketing and customer teams
Graduates and career switchers

How you learn

A live learning rhythm built around practice.

The programme combines structured teaching, guided practice and regular review so the work develops alongside the knowledge.

01Three live sessions weekly
02Recordings available
03Weekly clinic and community support
04Datasets and templates provided
05Optional bring-your-data clinic
06Excel and Power BI required

Next step

Interested in this programme?

Check the current application status and register your interest. We do not publish cohort dates until they are confirmed.

Next cohort

Next cohort details will be published when confirmed.

Register interest