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 & BI for managers
Section 1: Introduction to the Course
Section Introduction
The Course Content (1:23)
Section 2: Data Warehousing
Section Introduction
A Short Story about Data Warehouse (1:40)
Why should you have a Data Warehouse? (1:40)
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: 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)
Architecture (9:41)
Quiz
Section 5: 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 6: ETL (Extract, Load & Transfrom)
Section Introduction
Introduction to ETL (2:41)
Extracting Data (3:52)
Transforming Data (2:25)
Loading Data (2:09)
How SlicingDice's Data Loading & Sync Module Works (24:32)
Quiz
Section 7: Business Intelligence (BI)
Section Introduction
Introduction to Business Intelligence (2:11)
How SlicingDice's Built-in Data Visualization Module works (30:29)
Section 8: Final Project
Section Introduction
A Data Warehouse and Business Intelligence project (0:55)
Your turn: What you need to do to create your DW & BI project
Section 9: Conclusion
The End (0:47)
Why should you have a Data Warehouse?
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock