SQL Data Warehouse & Analytics Project — Designed and implemented a scalable PostgreSQL-based Data Warehouse following the Medallion Architecture (Bronze, Silver, Gold). Built ETL pipelines using SQL to integrate ERP and CRM data, applied Star Schema modeling for analytical efficiency, and performed SQL-based EDA and reporting to derive insights on customer behavior, product performance, and sales trends. Strengthened skills in Data Engineering, SQL Optimization, and Business Analytics through a complete end-to-end solution.
1️⃣ Database Exploration:
Understood the overall database structure and relationships between fact and dimension tables.
2️⃣ Dimensions Exploration:
Analyzed customer and product dimension tables to study their characteristics and attributes.
3️⃣ Date Range Exploration:
Identified the time period covered by the data to ensure consistent and valid analysis.
4️⃣ Measures Exploration:
Examined key performance metrics and their value distributions.
5️⃣ Magnitude Exploration:
Assessed the scale and variation of different numerical measures.
6️⃣ Ranking Analysis:
Identified top-performing customers and products based on sales metrics.
7️⃣ Change Over Time Analysis: