This is the landing page for the Modern Data Modelling With Power BI and AI Agents course. It contains links to set up instructions, tutorials, exercises and resources for the course.
Set up and configure the tools of modern data modelling: Power BI Desktop, the Power BI Modeling MCP server, VSCode and Claude Desktop.
Build a semantic model from scratch using Power BI Desktop, then Power BI Online
Reflect and Review on the semantic model we have just built. How can we improve it?
Improve with Agentic AI and the Power BI Modeling MCP server.
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.
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.
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.