Data Modeling with AI for Power BI

Europe

Learn how to validate AI-generated data models to ensure they answer your business questions correctly. You learn how to guide AI tools, recognize potential problems, and determine whether the proposed model meets your reporting needs. Through practical examples, you become familiar with dimensional modeling, fact tables, dimensions, bridge tables, snapshots, and events. This course is for business users who want to create reliable Power BI models with AI without a technical data engineering background, and for practitioners who want to leverage AI to improve their productivity in data modeling for analytics.

This two-day classroom course is a practical introduction to the concepts of dimensional data modeling, which are needed to create good semantic models for Power BI and Fabric.

The goal of the classroom course is to introduce the different concepts with practical examples, using the AI to transform the existing data in the dimensional model that is appropriate to solve the business scenario considered. While the examples targets a semantic model for Power BI, the concepts learned are valid for any other tool for analytics.

The classroom course includes practical assignments: you will apply the concepts using your own laptop.

2027 Classroom Courses: Register Now

Secure your seat for any delivery date in the first half of 2027 and get an additional early-registration discount.

Full refund, guaranteed.
If you later decide not to attend, or if we cannot schedule a course in a location that works for you, we refund you in full. No risk.

How locations and dates are decided:
We use prepaid registrations to decide how many editions to run and where. A cluster of registrations in the same area is what places a course there. If we cannot run the course near you, you can get a full refund or consider attending another nearby city.

Why the discount:
The earlier you register, the clearer the picture we have for planning cities and number of editions. That is why early registrations receive an additional discount. This is not about collecting money before year-end; it is about making better decisions about where and how often to run the courses.

You can register now. We will announce cities and dates in January 2027, or as soon as the registrations give us a clear direction.

Topics

  • From a Business Question to a Star Schema
  • Entities, Keys, and Reliable Relationships
  • Reshaping Data for Analysis
  • Designing Useful Dimensions
  • Dates and Dimension Roles
  • Working with Multiple Fact Tables
  • Grain, Aggregation, and Information Loss
  • Combining Different Grains
  • Many-to-Many Relationships and Missing Activity
  • Expected Events and Actual Events
  • From Events to State
  • Balances and Periodic Snapshots
  • Dimensions That Change over Time (SCD)

Prerequisites

To get the most out of the classroom course, attendees should be familiar with the user interface of Power BI Desktop to import tables in semantic models from the dimensional models defined in the lectures and in the practical assignments. Previous knowledge of data modeling concepts is not required. DAX knowledge is not required.

Location to be announced

Europe

Teaching this course

Marco Russo & Alberto Ferrari

Consultants & Mentors
Trainer for 420 other courses at SQLBI

Looking for another city?

We bring our classroom courses to you all over the world. Here are the current scheduled classroom courses.
Please note that each classroom course is taught exclusively by SQLBI trainers in person. No external trainers are involved.
 London, England, GB Nov 24-26
London
 Amsterdam, NL Dec 1-3
Amsterdam
Other locations On-Site On-Site On-Site On-Site