Data Modeling with AI for Power BI

On-Site

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.

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)

The outline may be adjusted on customer request.

Contact us

Prefer email? Write to info@sqlbi.com.