Data Modeling with AI: Fundamentals to ChatGPT & Copilot

About this course

The world of data is changing fast. On one side, organizations still rely on proven data modeling and business intelligence fundamentals — star schemas, facts and dimensions, data warehouses, and ETL pipelines. On the other side, AI tools like ChatGPT and GitHub Copilot are transforming the way we design, implement, and optimize data models.

This course brings both worlds together. It gives you a solid foundation in traditional data modeling while showing you how to use AI as a co-pilot in your daily work. You’ll learn how to design conceptual, logical, and physical models, build data warehouses and data marts, and understand how ETL and OLAP vs. OLTP systems shape your architecture. At the same time, you’ll discover how ChatGPT and Copilot can help you brainstorm schemas, generate SQL code, check data quality, and even document your models.

Unlike many theory-heavy courses, this one is practical and hands-on. You’ll work with free tools like MySQL Workbench and dbdiagram to create your models, build ETL flows with Apache Hop, and connect your data to Power BI for analytics. You’ll also tackle realistic dirty datasets, practicing data cleansing and transformation just like you would in a real project.

The highlight of the course is the FastBite Capstone Project, a simulated food delivery business. You’ll start from raw source data, design the dimensional model, implement a data warehouse in MySQL, build ETL flows to populate your fact and dimension tables, and finally connect to Power BI to answer real business questions. Along the way, you’ll learn how to use AI tools as your assistant: to suggest schema designs, classify facts and dimensions, generate transformation logic, and write documentation.

By

Prices, discounts and availability are set by Udemy. We may earn a commission when you purchase through links on this site.