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)
What is Dimensional Model?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock