This project involved building a SQL data warehouse using the Medallion architecture—comprising the Bronze, Silver, and Gold layers. Data from two source systems (ERP and CRM), provided as CSV files, were ingested into a SQL Server database. The data were cleansed, standardized, normalized, and modelled into a star schema to ensure simplicity, flexibility, and optimization for reporting.
-
Notifications
You must be signed in to change notification settings - Fork 0
A SQL data warehouse Project using the Medallion architecture—comprising the Bronze, Silver, and Gold layers.
License
jotstolu/Sql-Data-Warehouse-Project
About
A SQL data warehouse Project using the Medallion architecture—comprising the Bronze, Silver, and Gold layers.
Topics
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published