Data Modeling with AI: Fundamentals to ChatGPT & Copilot

Master business intelligence fundamentals, data warehouse & ETL. Use AI tools like ChatGPT & Copilot for data modeling!

What you'll learn
- Understand data modeling fundamentals: conceptual, logical & physical models
- Learn how to use Artificial Intelligence (Copilot & ChatGPT) in every step of the Data Modeling process
- Build star schemas, identify facts & dimensions, and master additivity
- Learn ETL & ELT basics and understand how they shape your data models
- Practice normalized vs. dimensional models and know when to use which
- Use MySQL Workbench and dbdiagram to design and implement models
- Practice hands-on ETL flows with free tools (Apache Hop)
- Work through a capstone project combining all skills

Requirements
- Just be curious, all foundations are provided in the course :-)

Description
The world of data is changing fast. On one side, organizations still rely on provendata 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 Copilotare transforming the way we design, implement, and optimize data models.

This course brings both worlds together. It gives you a solid foundation intraditional data modelingwhile showing you how to useAI as a co-pilotin your daily work. You’ll learn how to designconceptual, logical, and physical models, builddata warehouses and data marts, and understand howETL and OLAP vs. OLTP systemsshape 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 ispractical and hands-on. You’ll work with free tools likeMySQL Workbenchanddbdiagramto create your models, build ETL flows withApache Hop, and connect your data toPower BIfor analytics. You’ll also tacklerealistic dirty datasets, practicing data cleansing and transformation just like you would in a real project.

The highlight of the course is theFastBite Capstone Project, a simulated food delivery business. You’ll start from raw source data, design thedimensional model, implement adata 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 useAI tools as your assistant: to suggest schema designs, classify facts and dimensions, generate transformation logic, and write documentation.

By the end of this course, you will:

ApplyAI support with ChatGPT and Copilotat every stage of the modeling workflow

Confidently design and implementdata warehousesanddata marts

Masterdimensional modelingwith star schemas, SCDs, facts, dimensions, and additivity

Understand the role ofETL/ELT pipelinesand where to implement logic

Build aportfolio-ready projectthat proves your skills in data modeling and business intelligence

This is themodern way to learn data modeling: combiningclassic BI best practiceswithAI-powered productivity.

If you want to build strong foundations in data modeling and business intelligence, while also learning how to leverage AI tools to become a faster and smarter data professional, this course is for you.

Who this course is for:
- Students or career changers aiming for a career in BI, data engineering, or analytics
- Business Intelligence professionals who want to deepen their data modeling skills
- Data analysts who need to understand data warehouses and dimensional models
- Aspiring data engineers looking for hands-on practice with ETL and data architecture
- Students or career changers aiming for a career in BI, data engineering, or analytics
More Info