Skip to content

Latest commit

 

History

History
21 lines (15 loc) · 769 Bytes

README.md

File metadata and controls

21 lines (15 loc) · 769 Bytes

Retail Store - Data Warehouse Project

Self-Promotion Project

Considering as a Case Study for interview and learning

In this project i used the Kimball Techniques - "Bottom to TO"P approach. By building from dimension and then the fact table as a business process.

End to End architecture

alt text

Data Warehouse Schema Overview

alt text

Technologies involve:

- Oracle Database

- Docker

- Red Hat Enterprose Linux 9

- Azure - using as PaaS - BLOB container files storage

BI: Visualiation Data with python and Microsoft BI

IDE: pyCharm, DataGrip