How haiderabbasi6357-cloud/sql-datawarehouse-project works
This is a SQL Server ETL warehouse: raw CRM and ERP CSVs are loaded into Bronze, transformed in Silver, and modeled as a Gold star schema for BI and SQL reporting. The README documents these relationships and data-quality checks; no source excerpts were available, so the graph uses documented capabilities and tree-supported paths without inferring finer-grained SQL calls.
Main entry points: checks Data Quality Checks · procedure_load Bronze Load · table_defining Bronze Tables · silver_ddl Silver Tables
Components 10
ETL Layers
- Bronze Load
scripts/bronze/procedure_load - Bronze Tables
scripts/bronze/table_defining - Silver Cleaning
scripts/silver/Cleaning Raw Data - Silver Tables
scripts/silver/silver_ddl
Warehouse And Quality
- Gold Analytics
scripts/gold/Analytic Views - Analytics Warehouse
- Data Quality Checks
tests/checks
Other components
- BI And SQL Reporting
Connections 11
- CRM CSVs → Bronze Load: bulk loads
- ERP CSVs → Bronze Load: bulk loads
- Bronze Load → Bronze Tables: loads raw data
- Bronze Tables → Silver Cleaning: cleans and transforms
- Silver Cleaning → Silver Tables: standardizes data
- Silver Tables → Gold Analytics: models data
- Gold Analytics → Analytics Warehouse: publishes star schema
- Analytics Warehouse → BI And SQL Reporting: serves analytics
- Data Quality Checks → Bronze Tables: validates
- Data Quality Checks → Silver Tables: validates
- Data Quality Checks → Analytics Warehouse: validates