Modern Data Modelling in Power BI (free full day in-person course)

FULL - RSVP here on meetup does not provide your place – you must have registered at the official registration page here.

This is a full day free training on data modelling in Power BI. Data Modelling is the core skill needed to build good, correct Power BI reports. We will firstly build a basic semantic model (fact, dimension, and dates tables, based on the star schema pattern). We will then use AI agents via the Power BI Model Context Protocol (MCP) server to directly improve and document our model.

Please bring a full charged laptop with Power BI Desktop installed.

Agenda
10am - Welcome and introduction
10:15am - Set up Power BI and AI tools
We set up and configure the software and environment that we need to firstly build a semantic model in Power BI, then the extra steps if we want an AI to directly improve it.

• Install Power BI Desktop (preferred) or sign into Power BI online
• Install VSCode and the Power BI MCP server (so we can use agentic AI to improve a model)
• Install Claude Desktop and configure it to control the MCP server

11:30am - Build a basic model
We build a star schema data model (dimension, fact, date tables) from scratch either in Power BI Desktop or Power BI online. We will use sample data with almost perfect data quality so we can focus on modelling and not data cleaning.
1pm - Lunch
1:30pm Discussion: Review our model. How can we improve it?
2pm - Use an Agentic AI and the Power BI MCP to directly improve our model
We use an AI (either Claude or GitHub Copilot) and the Power BI Model Context Protocol (MCP) Server to directly improve a Power BI semantic model (tables, columns, measures, formats, relationships, hierarchies) with natural language instructions.
3:45pm - Wrap up and next steps
4pm - Finish