# amr-walid/sqlserver-datawarehouse-project architecture

> Architecture diagram of the GitHub repository amr-walid/sqlserver-datawarehouse-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-29). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/amr-walid/sqlserver-datawarehouse-project
- Repository: https://github.com/amr-walid/sqlserver-datawarehouse-project

## Overview

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: [`scripts/bronze/proc_load_bronze.sql`](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/bronze/proc_load_bronze.sql) (Bronze Load), [`scripts/init_database.sql`](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/init_database.sql) (Initialize Database), [`scripts/bronze/ddl_bronze.sql`](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/bronze/ddl_bronze.sql) (Bronze DDL), [`scripts/silver/ddl_silver.sql`](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/silver/ddl_silver.sql) (Silver DDL)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_setup["Database Setup"]
  node_init["Initialize Database<br/>[init_database.sql]"]
end

subgraph group_bronze["Bronze Ingestion"]
  node_bronze_ddl["Bronze DDL<br/>[ddl_bronze.sql]"]
  node_bronze_load["Bronze Load"]
end

subgraph group_silver["Silver Preparation"]
  node_silver_ddl["Silver DDL<br/>[ddl_silver.sql]"]
  node_silver_load["Silver Load"]
  node_silver_query["Silver SQL Query<br/>[SQLQuery7.sql]"]
end

subgraph group_gold["Gold Analytics"]
  node_gold_ddl["Gold DDL<br/>[ddl_gold.sql]"]
  node_reporting["Analytics Reporting"]
end

node_sources(("ERP/CRM CSVs"))
node_sqlserver[("SQL Server Warehouse")]
node_stakeholders(("Business Stakeholders"))

node_init -->|"initializes"| node_sqlserver
node_sources -->|"supplies CSVs"| node_bronze_load
node_bronze_load -->|"loads raw data"| node_sqlserver
node_bronze_ddl -->|"defines Bronze"| node_sqlserver
node_silver_load -->|"cleans and integrates"| node_sqlserver
node_silver_ddl -->|"defines Silver"| node_sqlserver
node_silver_query -->|"queries"| node_sqlserver
node_gold_ddl -->|"defines Gold model"| node_sqlserver
node_sqlserver -->|"provides analytical data"| node_reporting
node_reporting -->|"delivers insights"| node_stakeholders

click node_init "https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/init_database.sql"
click node_bronze_ddl "https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/bronze/ddl_bronze.sql"
click node_bronze_load "https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/bronze/proc_load_bronze.sql"
click node_silver_ddl "https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/silver/ddl_silver.sql"
click node_silver_load "https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/silver/proc_load_silver.sql"
click node_silver_query "https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/silver/SQLQuery7.sql"
click node_gold_ddl "https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/gold/ddl_gold.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_init toneBlue
class node_bronze_ddl,node_bronze_load,node_sqlserver toneAmber
class node_silver_ddl,node_silver_load,node_silver_query toneMint
class node_gold_ddl,node_reporting toneRose
class node_sources,node_stakeholders toneIndigo
```

## Components

### Database Setup

- [Initialize Database](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/init_database.sql): `scripts/init_database.sql`

### Bronze Ingestion

- [Bronze DDL](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/bronze/ddl_bronze.sql): `scripts/bronze/ddl_bronze.sql`
- [Bronze Load](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/bronze/proc_load_bronze.sql): `scripts/bronze/proc_load_bronze.sql`

### Silver Preparation

- [Silver DDL](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/silver/ddl_silver.sql): `scripts/silver/ddl_silver.sql`
- [Silver Load](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/silver/proc_load_silver.sql): `scripts/silver/proc_load_silver.sql`
- [Silver SQL Query](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/silver/SQLQuery7.sql): `scripts/silver/SQLQuery7.sql`

### Gold Analytics

- [Gold DDL](https://github.com/amr-walid/sqlserver-datawarehouse-project/blob/main/scripts/gold/ddl_gold.sql): `scripts/gold/ddl_gold.sql`
- **Analytics Reporting**

### Other components

- **ERP/CRM CSVs**
- **SQL Server Warehouse**
- **Business Stakeholders**

## Connections

- 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