Zomalex | Data and AI Training

Home | Power BI | Excel | Python | SQL | Gen AI | Prices | Contact Us | LBAG | info@zomalex.co.uk

Modern Data Modelling in Power BI

Date: 27th April 2026
Time: 10am to 4pm
Location: Cathedral View, Carlisle Place, London SW1P 1NL Directions

Please register below. Please provide your full name and your email address. The course is limited to 30 places so please only register if you are fairly sure that you can attend. We will email you to confirm about one week before the event.

Description

This is a full day training on data modelling in Power BI on 27th April 2026. Data Modelling is the core skill needed to build good, correct Power BI reports. We will cover fact and dimension tables, the star schema pattern. We will write some DAX measures in the SAX Query View

If time allows, we will use AI assistants to help us improve our model and write DAX. We will also experiment with the Power BI Model Context Protocol (MCP) server to directly improve and document our model and write DAX. The course style will be guided hands-on follow-the instructor tutorial.

Please bring a full charged laptop.

So that we the course off to a flying start, we are running an optional 1-hour virtual session two weeks beforehand where we guide people through the setup of Power BI Desktop and a few other things that will be needed for the course. Most attendees will know how to do this already, but we want to make sure that everyone is ready to go on the day of the course

Agenda

10am - Welcome and introduction

10:15am - Set up software

• Install Power BI Desktop
• Sign into Power BI online
• Sign into an AI assistant e.g., Copilot, ChatGPT
• Install Claude Desktop

11am - Data Modelling Recap

• Build a star schema data model (dimension, fact, date tables). We will use sample data with almost perfect data quality so we can focus on modelling and not data cleaning.
• Define and measure and test it in the DAX Query View.

12pm - Using AI assistants to improve our model and write DAX

Ask an AI assistant to:

• Review our model and suggest improvements
• Write some DAX measures

Note that we will need to copy paste the results of these into Power BI

1pm - Lunch

1:45pm - Use the Power BI Model Context Protocol (MCP) to directly improve our model and write DAX

• Install Claude Desktop and connect it to our Power BI model using the Model Context Protocol (MCP)
• Install the Power BI MCP server
• Connect Claude to the MCP server
• Ask Claude to improve our model and write DAX measures

3:45pm - Wrap up and next steps

4pm - Finish