INTERMEDIATE · 5 DAYS · FULLY FUNDED

Power BI & Data Analyst Professional Masterclass

Move from Excel pivot tables to building enterprise-grade interactive dashboards. Welsh public sector and NHS Wales are investing heavily in data — this is your ticket in.

DURATION
5 days
~40 hours total
FORMAT
In-person or online
Maesteg · Bridgend
LEVEL
Intermediate
Admin staff
COST
£0 to you
100% ReAct+ funded
// About this masterclass

What you'll learn in five days.

Power BI analysts are in huge demand across Wales — NHS, local government, insurance, finance. The average UK salary is north of £40,000 and climbing.

This five-day intensive takes you from your Excel comfort zone through Power Query, DAX, interactive dashboards, SQL basics and AI insights — the full toolkit a junior data analyst needs.

If you can build a pivot table, you can succeed here. We meet you where you are and build up fast.

40h
Intensive training
5
Hands-on labs
3
Portfolio deliverables
1:6
Tutor ratio max
// Day-by-day curriculum

Five days. Five outcomes. One transformed career.

Mornings are taught sessions, afternoons are hands-on labs where you build something real.

DAY
01

From Excel to Power BI

Your Excel skills are the foundation. We'll bridge them into Power BI on day one so you're productive immediately.

  • Power BI Desktop setup & tour
  • Importing data from Excel & CSV
  • Your first visualisation
  • Power Query introduction
  • Data types & formatting
  • Connecting to multiple sources
LAB
Build your first Power BI dashboard from raw Excel data
DAY
02

Data Cleaning & Transformation

Real data is messy. Power Query lets you clean it systematically so your dashboards are always accurate.

  • Power Query editor deep-dive
  • Removing duplicates & errors
  • Splitting & merging columns
  • Pivoting & unpivoting
  • Custom columns & M code basics
  • Refresh schedules
LAB
Clean a messy NHS-style dataset into analysis-ready form
DAY
03

Building Interactive Dashboards

The visual storytelling that makes data analysts indispensable. Slicers, drill-downs, conditional formatting, and layout.

  • Chart types & when to use each
  • Slicers & filters
  • Drill-through pages
  • Conditional formatting
  • Mobile layouts
  • Design principles for dashboards
LAB
Build an interactive sales dashboard with drill-through
DAY
04

DAX & Advanced Analytics

The formula language that separates good analysts from great ones. Measures, calculated columns, and time intelligence.

  • DAX fundamentals
  • Measures vs calculated columns
  • Time intelligence functions
  • CALCULATE & filter context
  • KPI creation
  • Row-level security basics
LAB
Build a financial KPI dashboard with time-series analysis
DAY
05

Business Reporting & AI Insights

Tie it all together with SQL basics, AI-powered insights, and the storytelling skills that make your dashboards get used.

  • SQL basics for Power BI analysts
  • AI insights & smart narratives
  • Q&A natural language queries
  • Data storytelling techniques
  • Publishing & sharing
  • Portfolio preparation
CAPSTONE
Present your interactive business dashboard to the cohort
// What you'll walk away with

Three real projects. One transformed CV.

DELIVERABLE_01

Interactive Business Dashboard

A fully interactive multi-page Power BI dashboard with DAX measures, drill-throughs, and time intelligence.

DELIVERABLE_02

Data Storytelling Portfolio Piece

A documented case study showing your process from raw data to business insight — ready for interviews.

DELIVERABLE_03

SQL & Data Pipeline Skills

Working knowledge of SQL queries and Power Query pipelines that connect to real-world data sources.

// Is this for me?

Honest about who this works for.

Best for: Admin staff · graduates · business analysts · finance

This is for you if…

  • You can use Excel pivot tables at a basic level
  • You want to move into data analyst or BI roles
  • You work in admin, finance, or operations and want to upskill
  • NHS or public sector staff wanting digital transformation skills
  • You want a career with strong demand and £40k+ salaries

This is not for you if…

  • You've never opened Excel before (start with our Office course)
  • You already use DAX and Power Query daily
  • You want Python/R-based data science
  • You need a self-paced online course

Your next chapter starts a week on Monday.

Five days is all it takes. Reserve your spot on the next cohort.