К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
AI-Driven Data Modeling Using ChatGPT and Copilot · LearnSpace
Назад в каталог
courseraАнализ данных

AI-Driven Data Modeling Using ChatGPT and Copilot

Курс от Packt
Средний≈ 19.6 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course features Coursera Coach! A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. This course empowers you to harness AI and modern tools for effective data modeling, improving your ability to design, analyze, and optimize databases and analytics systems. You'll gain practical experience using ChatGPT and GitHub Copilot to accelerate data model creation and documentation. The journey begins with foundational concepts, covering conceptual, logical, and physical data models, dimensional modeling, additivity, conformed and slowly changing dimensions, normalization, and star schema design. You will explore practical demonstrations in Power BI and diagramming tools, ensuring a strong grasp of data modeling principles. This course is ideal for data analysts, BI professionals, developers, and anyone seeking to leverage AI-assisted tools for data modeling. No prior experience is required, though familiarity with databases is helpful. By the end of the course, you will be able to design conceptual, logical, and dimensional models, implement ETL pipelines, document schemas, perform data quality checks, and integrate AI tools to streamline modeling workflows.

Навыки, которые вы освоите

Extract, Transform, LoadData ModelingData ArchitecturePower BIData WarehousingStar SchemaData MartData ValidationData LakesGenerative AI AgentsMySQL WorkbenchDatabase TheorySQLTest DataDatabase DesignApacheRelational DatabasesData QualityData PipelinesSQL Server Integration Services (SSIS)

Программа курса

9 модулей · 138 учебных материалов

01Introduction4 материалов

Introduction

Course PromoВидеоFull Course ResourcesЧтениеWelcome and Getting to Know Your LecturerВидеоWhat to Expect from This Course & Learning OutcomesВидео
02Data Modeling Fundamentals and Foundations

Учитесь у экспертов

Packt - Course Instructors

Преподаватель курса

AI-Driven Data Modeling Using ChatGPT and Copilot
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 19.6 ч

9 модулей

Язык: Английский

Часть программы вашего университета
38 материалов

Data Modeling Fundamentals and Foundations

Module IntroductionВидеоWhat Is a Data Model and Why Does It Matter?ВидеоWhy Do Data Models Matter?ВидеоConceptual Data ModelВидеоLogical Data ModelВидеоPhysical Data ModelВидеоLevels of Data Models: SummaryВидеоDimensional Modeling: IntroductionВидеоDimensional Modeling: ImportanceВидеоDimensional Modeling: Facts & DimensionsВидеоDimensional Model: How Facts and Dimensions Work TogetherВидеоData Model Demonstration in Power BIВидеоUnderstanding Additivity in FactsВидеоTypes of Additivity in PracticeВидеоAdditive Facts: ExampleВидеоSemi-Additive Facts: ExampleВидеоNon-Additive Facts: ExampleВидеоDemo: Additivity in Power BIВидеоWhy Additivity Matters in Business Intelligence in PracticeВидеоConformed Dimensions – A Key to Consistent AnalysisВидеоConformed Dimensions Applied in Power BIВидеоWhat Are Slowly Changing Dimensions (SCDs)?ВидеоTypes of Slowly Changing DimensionsВидеоSlowly Changing Dimensions – Type 0ВидеоSlowly Changing Dimensions – Type 1ВидеоSlowly Changing Dimensions – Type 2ВидеоSlowly Changing Dimensions – Type 3ВидеоNormalized ModelingВидеоNormalized Data Model – ExampleВидеоStar SchemaВидеоStar Schema – ExampleВидеоIntroduction to Data Modeling NotationsВидеоCommon Data Modeling NotationsВидеоCore Elements of Data ModelsВидеоCrow's Foot ExampleВидеоTools for Data ModelingВидеоUnderstanding Data Models and Dimensional Modeling BasicsDIALOGUEData Modeling Fundamentals and FoundationsЗадание
03Data Modeling Exercise15 материалов

Data Modeling Exercise

Case Study IntroductionВидеоIntroduction to dbdiagram.ioВидеоIntroduction to draw.ioВидеоSetting Up MySQL Database and MySQL WorkbenchВидеоThe Case Study OverviewВидеоAnalyzing the Case Study (Part 1)ВидеоAnalyzing the Case Study (Part 2)ВидеоDrawing the Conceptual Data ModelВидеоDrawing the Logical Data Model (in draw.io)ВидеоDrawing the Logical Data Model (in MySQL Workbench)ВидеоForward Engineering in MySQL WorkbenchВидеоDrawing the Dimensional Model (Part 1)ВидеоDrawing the Dimensional Model (Part 2)ВидеоBuilding a Star Schema for a Car Rental BusinessDIALOGUEData Modeling ExerciseЗадание
04Data Architecture Essentials21 материалов

Data Architecture Essentials

Module IntroductionВидеоWhat Is BI & Data Analytics Architecture?ВидеоBusiness Intelligence Architecture ModelВидеоKey Roles in Business Intelligence & Data ArchitectureВидеоWhy Do We Need Specialized Business Intelligence & Analytics Architecture?ВидеоWhat Is a Data Warehouse?ВидеоData Warehouse ArchitectureВидеоWhat Is a Data Mart?ВидеоData Mart Architectures MatterВидеоStovepipe Architecture – OverviewВидеоStovepipe Architecture – Pro & ConВидеоHub-and-Spoke Architecture – OverviewВидеоHub-and-Spoke Architecture – Pro & ConВидеоInmon vs. Kimball (and the Modern Blend)ВидеоWhat Is a Data Lake?ВидеоData Lake ArchitectureВидеоData Warehouse vs. Data LakeВидеоWhat Is a Data Lakehouse?ВидеоMetadata and Data GovernanceВидеоFoundations of Data Architecture for Business IntelligenceDIALOGUEData Architecture EssentialsЗадание
05Extract Transform Load (ETL), ELT, and OLAP & OLTP26 материалов

Extract Transform Load (ETL), ELT, and OLAP & OLTP

Module IntroductionВидеоIntroduction to ETL and ELTВидеоTypical TransformationsВидеоLoadВидеоThe Incremental LoadВидеоProcessing Deleted RecordsВидеоProcessing Deleted Records (Incremental Load)ВидеоWhat Is Online Transaction Processing (OLTP)?ВидеоWhat Is Online Analytical Processing (OLAP)?ВидеоOLTP vs. OLAP – Key DifferencesВидеоHow ETL & System Architecture Influence Data ModelsВидеоWhere Logic Lives – SCDs, Staging and AuditВидеоUnderstanding ETL Staging AreasВидеоWhy Timing Matters in ETLВидеоBatch ETL – Concepts and CharacteristicsВидеоReal-Time (Streaming) ETL/ELT – Concepts and CharacteristicsВидеоBatch ETL vs. Real-Time ETLВидеоChoosing the Right Approach: Business & Technical ConsiderationsВидеоWhat Is ETL Orchestration & Scheduling?ВидеоKey Components & Scheduling ApproachesВидеоBest Practices for ETL OrchestrationВидеоKey Factors Impacting ETL PerformanceВидеоOptimization Techniques & Best PracticesВидеоETL Tools OverviewВидеоConversational Foundations of ETL, ELT, and Data IntegrationDIALOGUEExtract Transform Load (ETL), ELT, and OLAP & OLTPЗадание
06ETL and Data Architecture Exercise in Apache Hop8 материалов

ETL and Data Architecture Exercise in Apache Hop

IntroductionВидеоSetting Up Apache Hop (Previously Pentaho)ВидеоSetting Up the Apache Hop Environment and Loading the DataВидеоDeveloping the ETL from the Source System to the Staging AreaВидеоDeveloping the ETL Pipeline from the Staging Area to the Data WarehouseВидеоConnecting Power BI to Our Dimensional Data ModelВидеоBuilding Basic ETL Pipelines with Apache HopDIALOGUEETL and Data Architecture Exercise in Apache HopЗадание
07Capstone Project – From Requirements to Data Model, to ETL to Power BI13 материалов

Capstone Project – From Requirements to Data Model, to ETL to Power BI

IntroductionВидеоIntroducing the CaseВидеоAnalyzing the CaseВидеоDrawing the Conceptual Data ModelВидеоDrawing the Logical Data ModelВидеоDrawing the Star SchemaВидеоSetting Up the Data EnvironmentВидеоSetting Up Apache Hop ProjectВидеоSetting Up the ETL Pipeline Using Metadata InjectionВидеоSetting Up the ETL Pipeline from the Staging Area to the Data WarehouseВидеоConnecting Power BI to the Star SchemaВидеоCapstone Project: End-to-End Data Modeling & ETL for Food Delivery AnalyticsDIALOGUECapstone Project – From Requirements to Data Model, to ETL to Power BIЗадание
08Data Modeling with Artificial Intelligence (AI), Copilot and ChatGPT10 материалов

Data Modeling with Artificial Intelligence (AI), Copilot and ChatGPT

IntroductionВидеоOverview: Data Modeling with GitHub CopilotВидеоDemo: Data Model and Idea Brainstorming with ChatGPTВидеоDemo: Schema Documentation and Glossary with GitHub CopilotВидеоDemo: Fact & Dimension Identification with GitHub CopilotВидеоDemo: ETL Definition with GitHub CopilotВидеоDemo: Data Quality Checks with ChatGPTВидеоSample and Test Data Generation with ChatGPTВидеоLeveraging AI Tools for Enhanced Data ModelingDIALOGUEData Modeling with Artificial Intelligence (AI), Copilot and ChatGPTЗадание
09Conclusion3 материалов

Conclusion

ConclusionВидеоFull Course Practice AssessmentЗаданиеFull Course AssessmentЗадание