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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Design Data Models for BI Reporting · LearnSpace
Назад в каталог
courseraАнализ данных

Design Data Models for BI Reporting

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

О курсе

Did you know that poorly designed data models are responsible for 80% of business intelligence project failures? This Short Course was created to help data management and engineering professionals accomplish effective self-service BI reporting through dimensional modeling. By completing this course, you'll be able to design intuitive star schema data models that eliminate complex joins, accelerate query performance, and empower business users to drag-and-drop fields directly in visualization tools like Tableau. You'll master the foundational skills of identifying business processes, structuring fact and dimension tables, and implementing surrogate key relationships. By the end of this course, you will be able to: Create a star schema data model to enable self-service business intelligence reporting This course is unique because it bridges the gap between technical data engineering and business user needs, focusing on practical implementation that directly supports analyst workflows and dashboard creation. To be successful in this project, you should have a background in basic database concepts and familiarity with SQL queries.

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

Star SchemaPerformance TuningDatabase DesignBusiness ProcessBusiness IntelligenceDashboardDashboard CreationSelf Service TechnologiesData ModelingBusiness ReportingData WarehousingBusiness Intelligence Software

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

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

01Module 1: Star Schema Fundamentals7 материалов
Discovering Your Data Modeling Journey and BI GoalsDIALOGUEDimensional Modeling Principles and Star Schema ComponentsЧтениеIdentifying Business Processes and Defining Model GrainВидеоFact and Dimension Table Design Patterns Чтение

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

Professionals in the Industry

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

Design Data Models for BI Reporting
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 2.1 ч

2 модулей

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

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Пушту, Испанский, Дари, Японский

Часть программы вашего университета
Creating Star Schema Relationships and Surrogate KeysВидео
Star Schema Design for Self-Service AnalyticsЛабораторная
Star Schema Design Knowledge Check Задание
02Module 2: BI Model Implementation6 материалов
Exploring Your BI Modeling Implementation StrategyDIALOGUEImplementing Slowly Changing Dimensions and Advanced Design PatternsЧтениеDocumenting Data Models for Business Intelligence SuccessВидеоImplement Complete Star Schema with DocumentationЗаданиеImplementation Strategy Knowledge CheckЗаданиеStar Schema Design Mastery AssessmentЗадание