How ramakrishnachepuri/sql_datawarehouse works
Project type and purpose
• This is a Data Warehouse & Analytics project implementing a Medallion Architecture (Bronze, Silver, Gold layers).
• The goal is to ingest raw CSV data from ERP and CRM sources into SQL Server, apply progressive transformations, and deliver business-ready fact and dimension tables for reporting and analytics.
File structure
• datasets/
– Source_Crm/*.csv (customer and product data, sales details)
– Source_erp/*.csv (ERP extracts for customers, locations, product categories)
• scripts/
– Bronze/ddl_bronze.sql & proc_load_bronze.sql (raw‐data table creation and load logic)
– Silver/ddl_silver.sql & proc_load_silver.sql (cleansing/standardization logic)
– Gold/Create ddl_gold.sql (star schema table DDLs)
• docs/data_catalog.md (detailed data dictionary)
• test/quality_checks_*.sql (data quality rules for silver and gold layers)
• README.md (project overview, architecture, and requirements)
README for architectural insights
• Confirms a three-layer Medallion approach:
– Bronze: raw ingestion
– Silver: cleansing & normalization
– Gold: star‐schema modeling for analytics
• Highlights SQL Server as the target platform and CSV as source format
• Emphasizes ETL pipelines, data modeling, and SQL-based analytics