<aside> 💡

A Data warehouse is a Subject-Oriented, integrated, Time-Variant and non-volatile collection of data to support management’s decision making routes

• Subject-Oriented : Focuses on business area needs the data to save, report from
• Integrated : it combines multiple data sources together to form a coherent end-result
• Time-Variant : Means it can save historical data like previous transactions
• Non-Volatile : Means that it saves the data across time and system reboots

</aside>

Project Scope

Project Requirements

Data Architecture

Data Architectures & Routes

ETL

ETL (Extract, Transform, Load) Process Diagram

Schema Type & Structure

Schema Shape & Structure

DWH Stages

DWH Tasks

Brainstorming & Needs-Analysis with Situation Assessment