By Published On: December 12, 2025Categories:

Data Modeling in the Age of AI: Fundamentals to ChatGPT & Copilot

This is the modern way to learn data modeling: combining classic BI best practices with AI-powered productivity.

You’ll be redirected to Udemy for secure checkout and lifetime access.

What our students say:

This was a very in-depth course. The instructor knows his stuff and I found the demonstrations of how to use AI in the data modeling process very helpful. If you want to learn data modeling and also how AI impacts data modeling, this course is recommended.
– Vera

Excellent combination of data modeling foundations, hands-on exercises and AI demonstration.
– Anthony

Now I finally understand MicroStrategy Workstation!
– Marc

Master Data Modeling Foundations — Enhanced by AI

Learn the core principles of data modeling (facts, dimensions, star schemas, warehouses) and see how AI tools like ChatGPT support and accelerate the process.

Use AI as a Modeling Co-Pilot

Discover how to use AI to generate, validate, and refine data models — from schema design to documentation and SQL generation.

Design Models Ready for Analytics & AI

Build data models that work for modern BI, lakehouse architectures, and AI-driven analytics — not just traditional reporting.

  • Understand data modeling fundamentals: conceptual, logical & physical models

  • Learn how to use Artificial Intelligence (Copilot & ChatGPT) in every step of the Data Modeling process

  • Learn ETL & ELT basics and understand how they shape your data models

  • Practice hands-on ETL flows with free tools (Apache Hop)

  • Work through a capstone project combining all skills

What you will learn:

Understand the core principles of data modeling: facts, dimensions, star schemas, data warehouses, and why they still matter in the age of AI.

Learn how to move from business requirements to conceptual, logical, and physical data models — with clarity and structure.

Explore modern data architectures and how data modeling adapts to data lakes, lakehouses, and hybrid BI platforms.

Deep dive into additive vs semi-additive measures, slowly changing dimensions (SCDs), conformed dimensions, and modeling best practices.

See how AI tools like ChatGPT can assist with schema design, validation, documentation, and SQL generation — used responsibly and effectively.

Practice building data models using tools like MySQL Workbench and real databases — turning diagrams into working tables.

About your instructor:

Hi, I’m Dr. Florian Detzel — BI architect, reporting pro, data governance expert, and Udemy instructor. I hold a PhD in Information Systems and bring teaching skills and practical industry experience into my courses.
I specialize in Power BI, Microsoft Fabric, Process Mining, and data governance with Purview.
My goal is to teach modern analytics in a clear, practical, and accessible way.

Perfect Companion Courses

Copilot in Microsoft Fabric & Power BI: AI-Powered Analytics

Microsoft Purview: Data Governance & Data Catalog

Master AI-driven insights, dashboards, SQL, and data modeling with Microsoft Copilot in Fabric and Power BI.

Strong analytics relies on trusted data. If you want to build governance, data quality, and lineage that supports your AI work in Power BI & Fabric, this course is the ideal next step.