This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Data Warehouse Concepts
Section 1: Introduction to the Course
Section Introduction
Introduction to the Course (1:38)
Section 2: Data Warehousing
Section Introduction
What is a Data Warehouse? (1:40)
Why should you have a Data Warehouse? (1:40)
Is Data Warehouse still relevant in the age of big data? (1:45)
Data Warehouse Characteristics (4:35)
The Basic Data Warehouse Diagram (2:03)
Data Warehouse and SlicingDice (1:29)
How a Data Warehouse works in Practice (14:24)
Quiz
Section 3: Introduction to SQL
Section Introduction
Introduction to SQL (0:52)
The Skeleton of a SQL Query (8:20)
Quiz
Section 4: Introduction to Business Intelligence (BI)
Section Introduction
What is Business Intelligence? (2:11)
An extended explanation about BI (1:58)
The uses of Business Intelligence
Data Visualization in practice with SlicingDice (30:29)
Quiz
Section 5: Data Warehouse Architecture
Section Introduction
Introduction to Data Architecture (9:41)
Centralized architecture (4:04)
Federated architecture (1:52)
Multi-tiered architecture (2:16)
Components of a data warehouse (2:52)
The staging area (2:58)
Quiz
Section 6: Introduction to Operational Data Store
Section Introduction
What is ODS? (2:53)
Features and benefits of ODS (4:54)
Differences between OLTP, OLAP, ODS, DWH, DM (3:23)
Quiz
Section 7: OLAP (Online Analytical Processing)
Section Introduction
What is OLAP? (3:01)
OLAP Cube (2:23)
Basic OLAP operations (3:44)
OLAP vs OLTP (3:50)
Quiz
Section 8: Data Marts
Section Introduction
What is Data Mart? (1:43)
Differences between DW and Data Mart (2:46)
Advantages and disadvantages of a data mart (2:27)
Quiz
Section 9: Data Modeling
Section Introduction
Introduction to Data Modeling (5:11)
Introduction to Inmon and Dimensional Approach (3:10)
Inmon Relational Data Model (6:20)
Dimensional Data Model (14:27)
Big Data Modeling (6:01)
Quiz
Section 10: Modeling your data on SlicingDice
How Data Modeling works on SlicingDice
Dimensions, Entities and Columns on SlicingDice (6:08)
Relational and Non-relational Databases (2:19)
Modeling your data on Slicingdice: Database Creation (4:47)
Modeling your data on SlicingDice: Loading Job (5:30)
Section 11: Metadata
Section Introduction
What is metadata? (1:50)
Benefits of metadata (1:20)
Types of metadata (1:47)
Quiz
Section 12: Entity Relational Data Model
Setion Introduction
What is Entity Relational Data model? (1:45)
The uses of Entity Relational Data Model (2:20)
The features of Entity Relational Data Model (3:43)
Quiz
Section 13: Dimensional Data Model
Section Introduction
What is Dimensional Model? (1:15)
Features of Dimensional Model (3:24)
Getting Started with Dimensional Data Model (7:39)
Quiz
Section 14: Introduction to Indexes
Section Introduction
What are Indexes? (1:46)
Section 15: ETL (Extract, Load & Transfrom)
Section Introduction
Introduction to ETL (2:41)
Extracting Data (3:52)
Transforming Data (2:25)
Loading Data (2:09)
Why ETL became infamous? (3:00)
How SlicingDice's Data Loading & Sync Module Works (24:32)
Quiz
Section 16: BI, DW and ETL approach
Section Introduction
BI and DW Implementation Approach (2:10)
Knowledge capture sessions (2:37)
Requirements gathering (2:52)
Architectures Phases (2:34)
Data Model (1:15)
ETL Phase (1:44)
Data Access (2:00)
Deploy (1:15)
Section 17: Conclusion
The End (0:44)
Introduction to Data Architecture
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
