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

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

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

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

Data Warehousing and Integration Part 1

Курс от Northeastern University
Уровень не указан≈ 23.1 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course will cover various topics in data engineering in support of decision support systems, data analytics, data mining, machine learning, and artificial intelligence. You will study on-premises data warehouse architecture, dimensional modeling of data warehouses, Extract-Transform-Load (ETL) integration from source systems to data warehouse, On-line Analytical Processing (OLAP) systems, and the evolving world of data quality and data governance. It offers you an opportunity to design, develop and maintain cloud-based data pipelines. Both on-premises and cloud-based platforms will be used to illustrate and implement data engineering techniques using operational and analytical data warehouses.

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

Data WarehousingRelational DatabasesData ModelingSQLDatabase DesignData IntegrationData AnalysisData ArchitectureExtract, Transform, LoadOperational Data StoreData QualityData MiningData GovernanceQuery LanguagesData Management

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

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

01Database Concepts 110 материалов

Getting Started

Welcome to Data Warehousing & Integration Part 1ЧтениеCourse OverviewВидеоMeet Your Instructor: Venkat KrishnamurthyВидеоSyllabus - Data Warehousing & Integration Part 1Чтение

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

Venkat Krishnamurthy

Professor

Data Warehousing and Integration Part 1
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 23.1 ч

7 модулей

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

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

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

Lesson 1: Introduction to Data Warehouses

Module 1 OverviewЧтениеIntroduction to Data WarehousesЧтениеIntroduction to Data WarehousesВидео

Lesson 2: Conceptual Database Design

Conceptual Database DesignЧтениеAssess Your Learning: Conceptual Database ModelingЗадание
02Database Concepts 26 материалов

Lesson 1: Logical Database Design

Module 2 OverviewЧтениеLogical Database DesignЧтениеNormalizationВнешний инструментAssess Your Learning: Logical Database DesignЗадание

Lesson 2: SQL

SQLЧтениеAssess Your Learning: SQLЗадание
03Data Warehouse Concepts10 материалов

Lesson 1: Multidimensional Model

Module 3 OverviewЧтениеMultidimensional ModelЧтениеMental Image of Multidimensional CubeВидеоThe Multidimensional ModelВнешний инструмент

Lesson 2: Measures and Summarizability

Measures and SummarizabilityЧтениеSummarizabilityВидеоAssess Your Learning: Measures & SummarizabilityЗадание

Lesson 3: OLAP Operations on a Multidimensional Model

OLAP Operations on a Multidimensional ModelЧтение

Lesson 4: Data Warehouse and Architecture

Data Warehouse and ArchitectureЧтениеAssess Your Learning: OLAP OperationsЗадание
04Conceptual Design 19 материалов

Lesson 1: Design Conceptual Multidimensional Models

Module 4 OverviewЧтениеDesign Conceptual Multidimensional ModelsЧтениеAssess Your Learning: Conceptual Modeling 1Задание

Lesson 2: Primary and Secondary Events

Primary and Secondary EventsВидеоPrimary and Secondary EventsЧтениеAssess Your Learning: Primary and Secondary EventsЗадание

Lesson 3: Additivity of Measures

Additivity of MeasuresВидеоAdditivity of MeasuresЧтениеAssess Your Learning: Additivity of MeasuresЗадание
05Conceptual Design 29 материалов

Lesson 1: Balanced and Unbalanced Hierarchies

Module 5 OverviewЧтениеBalanced and Unbalanced HierarchiesЧтениеBalanced and Unbalanced HierarchiesВидео

Lesson 2: Generalized Hierarchies

Generalized HierarchiesВидео

Lesson 3: Alternative and Parallel Hierarchies

Alternative HierarchiesВидеоParallel HierarchiesВидеоAssess Your Learning: Conceptual Modeling of HierarchiesЗадание

Lesson 4: Advanced Modeling Concepts

Advanced Modeling ConceptsЧтениеAssess Your Learning: Advanced Modeling ConceptsЗадание
06Logical Modeling20 материалов

Lesson 1: Logical Modeling of Data Warehouse

Module 6 OverviewЧтениеLogical Modeling of Data WarehouseЧтениеIntroduction to Logical Modeling in Data WarehousingВидеоTypes of ROLAP SchemasВнешний инструментDifferent ROLAP Schemas ConclusionВидеоAssess Your Learning: Logical ModelingЗадание

Lesson 2: Keys in ROLAP

Introduction to Surrogate KeysЧтениеBenefits of Surrogate KeysЧтениеImplementation of Surrogate Keys in a Data WarehouseЧтениеSurrogate KeysВидео

Lesson 3: Consistency in Data Warehouses

Importance of Data ConsistencyВидеоImportance of Data ConsistencyЧтениеChallenges & Best Practices for Maintaining and Ensuring Data ConsistencyЧтениеConsistency in a Data Warehouse ExampleВидео

Lesson 4: Prepopulating Dimensions

Understanding Prepopulating DimensionsЧтениеThe Process of Prepopulating Time and Geography DimensionsЧтениеBenefits of Prepopulating Time and Geography DimensionsЧтениеPrepopulating DimensionsЧтениеPrepopulating Dimensional Data ExampleВидеоAssess Your Learning: Keys, Consistency and Prepopulating DimensionsЗадание
07Slowly Changing Dimensions17 материалов

Lesson 1: Logical Representation of Hierarchies

Module 7 OverviewЧтениеIntroduction to Conceptual & Logical ModelsЧтениеModeling Various Types of HierarchiesВидеоMapping ProcessЧтениеConclusionЧтение

Lesson 2: Advanced Modeling Concepts

Advanced Modeling ConceptsЧтение

Lesson 3: Slowly Changing Dimensions: A Comprehensive Guide

Understanding Slowly Changing DimensionsЧтениеTypes of Slowly Changing DimensionsЧтениеBenefits of Managing Slowly Changing DimensionsЧтениеSCD Best PracticesВидеоTranslating between SCDsВидеоSteps for Translating Between SCD TypesЧтение

Lesson 4: SQL for OLAP

Performing OLAP queries with SQLЧтениеAssess Your Learning: Logical Representation of Hierarchies and Advanced conceptsЗадание

Part 1: Complete

Congratulations! Чтение
Examples of Translating Between SCD TypesВидео
Conclusion Видео