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)
Section Introduction
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
