ADB Lecture 8
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt Play1/4
There's no tags or description
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
5 Terms
What is Data Warehousing?
A Data Warehouse is a central place that stores large amounts of historical data from different systems for analysis and decision-making.
What are the typical layers of Data Warehouse Architecture?
1. Data Sources
Databases, APIs, logs, ERP systems
2. ETL Layer (Extract, Transform, Load)
Cleans and integrates data
3. Data Storage (Warehouse)
Structured, historical data
4. Presentation Layer (reports)
BI tools, dashboards, OLAP
What does the Star Schema contain?
One Fact Table in the center
Multiple Dimension Tables around it
What are the Star Schema dimensions?
Product (name, category)
Customer (region, age)
Date (day, month, year)