How hamzehalzurayqat/sql_data_wearhouse works
This SQL Server warehouse turns CRM and ERP CSVs into analytics-ready Gold views through Bronze ingestion and Silver cleaning, normalization, deduplication, and business rules. Analysts use the Gold customer/product dimensions and sales fact for reporting; the EDA script explores the built Gold layer and its findings are summarized in a report. Relationships are based on README documentation only: no source excerpts were available to verify finer-grained SQL behavior.
Main entry points: create_views Gold analytical views · load_bronze.sql Bronze loader · ddl_bronze.sql Bronze tables · load_silver.sql Silver transformations
Components 11
Warehouse layers
- Bronze loader
scripts/bronze/load_bronze.sql - Bronze tables
scripts/bronze/ddl_bronze.sql - Silver transformations
scripts/silver/load_silver.sql - Silver layer
scripts/silver/ddl_silver_layer
Analytics
- Gold analytical views
scripts/gold/create_views - Business reporting
Exploratory analysis
- Gold-layer exploration
EDA/EDA.sql - EDA findings
Exploratory_Data_Analysis_(EDA)_Report.md
Other components
- Analyst
Connections 10
- CRM CSVs → Bronze loader: loads CSVs
README.md - ERP CSVs → Bronze loader: loads CSVs
README.md - Bronze loader → Bronze tables: loads raw data
README.md - Bronze tables → Silver transformations: transforms data
README.md - Silver transformations → Silver layer: cleans and loads
README.md - Silver layer → Gold analytical views: curates views
README.md - Analyst → Gold analytical views: queries
README.md - Gold analytical views → Business reporting: supports analysis
README.md - Gold analytical views → Gold-layer exploration: explores after build
README.md - Gold-layer exploration → EDA findings: summarizes findings
README.md