SQL Data Warehouse Project

Built an end-to-end SQL data warehouse in PostgreSQL to consolidate sales data from CRM and ERP source systems and create a reliable foundation for analytics and reporting.

The portfolio project follows a Medallion Architecture, moving data through three layers:
🥉 Bronze (Raw): Ingested the source CSV files and preserved the data in its original form.
🥈 Silver (Cleaned & Transformed): Applied data quality checks, cleansing, standardization, validation, and transformations to prepare the data for analysis.
🥇 Gold (Business-Ready): Integrated the cleaned data into a Star Schema consisting of fact and dimension views optimized for analytics and reporting.

What I Built Include:
- Designed the data warehouse architecture and database schemas.
- Developed SQL-based ETL processes to load data from CRM and ERP sources.
- Performed data quality validation and addressed inconsistencies, duplicates, invalid dates, and missing values.
- Created the Silver layer with cleaned and standardized datasets.
- Built Gold-layer fact and dimension views using dimensional modeling.
- Documented the Medallion Architecture and resulting Star Schema.
- Created the foundation for SQL-based customer, product, and sales analysis.

The project demonstrates my approach to SQL, ETL, data quality, data modeling, and modern data warehouse architecture from source data through business-ready datasets.

For the full project, SQL scripts, datasets, documentation, and implementation details, visit my GitHub:
https://github.com/JerielIri2/sql-dwh-analytics-project.git