How toryigithan-blip/sql-datawarehouse-project works
The documented product is a SQL Server sales data warehouse: ERP/CRM CSV data is loaded into Bronze, cleansed and standardized in Silver, then modeled for analytics in Gold. The checked-in tree contains Bronze and Silver SQL scripts, but no Gold implementation or report files; those documented capabilities are shown without assigning them an unsupported source path. Relationships are based on the README, since no source excerpts were provided.
Main entry points: proc_load_bronze.sql Bronze loading · proc_load_silver.sql Silver cleansing
Components 9
Raw ingestion
- Bronze schema
scripts/bronze/ddl_bronze.SQL - Bronze loading
scripts/bronze/proc_load_bronze.sql - Database setup
scripts/init.database.sql
Data preparation
- Silver schema
scripts/silver/ddl_silver.sql - Silver cleansing
scripts/silver/proc_load_silver.sql
Analytics
- Gold star model
- SQL analytics
Other components
- ERP/CRM CSVs
- Decision-makers
Connections 5
- ERP/CRM CSVs → Bronze loading: loads raw data
README.md - Bronze loading → Silver cleansing: cleans and standardizes
README.md - Silver cleansing → Gold star model: prepares for modeling
README.md - Gold star model → SQL analytics: supports reporting
README.md - SQL analytics → Decision-makers: delivers insights
README.md