1. Home
  2. Masterclasses
  3. Power BI

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.

Free after redundancy in Wales with Welsh Government ReAct+ funding

Check if you qualify Download course info (PDF)
5 daysAbout 40 hours, 9am to 5pm
IntermediateLevel
Maesteg or onlineLlynfi Enterprise Centre or live online
£0With ReAct+ funding

What you'll learn on the Power BI course.

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.

40hIntensive training
5Hands-on labs
3Portfolio deliverables
1:6Tutor ratio max

Five days, one step at a time.

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

  1. Day 1

    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

    LabBuild your first Power BI dashboard from raw Excel data

  2. Day 2

    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

    LabClean a messy NHS-style dataset into analysis-ready form

  3. Day 3

    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

    LabBuild an interactive sales dashboard with drill-through

  4. Day 4

    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

    LabBuild a financial KPI dashboard with time-series analysis

  5. Day 5

    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

    CapstonePresent your interactive business dashboard to the cohort

Interactive Power BI dashboard built on the free Power BI and Data Analyst course

Three real projects for your CV.

You leave with work you can show an employer, not just a certificate.

  • Interactive Business Dashboard

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

  • Data Storytelling Portfolio Piece

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

  • SQL & Data Pipeline Skills

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

Is this course right for you?

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

It's probably 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. Check you qualify, then reserve your place on the next Power BI course.

Reserve my place Check if you qualify