How amr-walid/sqlserver-datawarehouse-project works
This repository describes a SQL Server sales warehouse built around a Bronze–Silver–Gold workflow: CSV data from ERP and CRM is loaded raw, cleansed and integrated, then modeled for analytics. The graph includes database initialization, layer DDL, the documented Bronze and Silver load stages, and reporting as a product capability. Source excerpts were unavailable, so links reflect README-documented behavior; the reporting implementation has no corresponding source path in the supplied tree.
Main entry points: proc_load_bronze.sql Bronze Load · init_database.sql Initialize Database · ddl_bronze.sql Bronze DDL · ddl_silver.sql Silver DDL
Components 11
Database Setup
- Initialize Database
scripts/init_database.sql
Bronze Ingestion
- Bronze DDL
scripts/bronze/ddl_bronze.sql - Bronze Load
scripts/bronze/proc_load_bronze.sql
Silver Preparation
- Silver DDL
scripts/silver/ddl_silver.sql - Silver Load
scripts/silver/proc_load_silver.sql - Silver SQL Query
scripts/silver/SQLQuery7.sql
Gold Analytics
- Gold DDL
scripts/gold/ddl_gold.sql - Analytics Reporting
Other components
- ERP/CRM CSVs
- SQL Server Warehouse
- Business Stakeholders
Connections 10
- Initialize Database → SQL Server Warehouse: initializes
- ERP/CRM CSVs → Bronze Load: supplies CSVs
- Bronze Load → SQL Server Warehouse: loads raw data
- Bronze DDL → SQL Server Warehouse: defines Bronze
- Silver Load → SQL Server Warehouse: cleans and integrates
- Silver DDL → SQL Server Warehouse: defines Silver
- Silver SQL Query → SQL Server Warehouse: queries
- Gold DDL → SQL Server Warehouse: defines Gold model
- SQL Server Warehouse → Analytics Reporting: provides analytical data
- Analytics Reporting → Business Stakeholders: delivers insights