# zellyirigon/sql-data-warehouse-powerbi architecture

> Architecture diagram of the GitHub repository zellyirigon/sql-data-warehouse-powerbi, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/zellyirigon/sql-data-warehouse-powerbi
- Repository: https://github.com/zellyirigon/sql-data-warehouse-powerbi

## Overview

This repository describes a SQL Server warehouse and Power BI reporting workflow: source CSVs are loaded into bronze, cleaned in silver, shaped into gold views, then consumed by a semantic model and reports. The README also describes database setup and the major reporting capabilities. Source excerpts were unavailable, and several documented directories and assets are absent from the supplied tree, so those components use only supported paths where possible; edges reflect README statements, not inspected implementations.

Main entry points: [`scripts`](https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts) (Bronze load), [`scripts/init_database.sql`](https://github.com/zellyirigon/sql-data-warehouse-powerbi/blob/main/scripts/init_database.sql) (Initialize schemas), [`scripts/ddl_bronze.sql`](https://github.com/zellyirigon/sql-data-warehouse-powerbi/blob/main/scripts/ddl_bronze.sql) (Bronze tables), [`dataset`](https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/dataset) (CRM and ERP CSVs)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_warehouse["SQL Warehouse"]
  node_bronze["Bronze load"]
  node_bronze_ddl["Bronze tables<br/>[ddl_bronze.sql]"]
  node_silver["Silver load"]
  node_gold_dims["Gold dimensions"]
  node_gold_fact["Gold sales fact"]
end

subgraph group_reporting["Power BI Reporting"]
  node_semantic["Semantic model"]
  node_measures["DAX measures"]
  node_reports["Report pages"]
end

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

node_analyst(("Analyst"))
node_csv["CRM and ERP CSVs"]
node_database[("SQL Server")]

node_analyst -->|"runs setup"| node_init
node_init -->|"creates schemas"| node_database
node_csv -->|"bulk loads"| node_bronze
node_bronze_ddl -->|"defines tables"| node_database
node_bronze -->|"loads raw data"| node_database
node_bronze -->|"loads next"| node_silver
node_silver -->|"writes cleaned data"| node_database
node_gold_dims -->|"defines views"| node_database
node_gold_fact -->|"defines view"| node_database
node_semantic -->|"connects to"| node_gold_dims
node_semantic -->|"connects to"| node_gold_fact
node_semantic -->|"includes"| node_measures
node_measures -->|"supports"| node_reports
node_analyst -->|"views"| node_reports

click node_csv "https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/dataset"
click node_init "https://github.com/zellyirigon/sql-data-warehouse-powerbi/blob/main/scripts/init_database.sql"
click node_bronze "https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts"
click node_bronze_ddl "https://github.com/zellyirigon/sql-data-warehouse-powerbi/blob/main/scripts/ddl_bronze.sql"
click node_silver "https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts"
click node_gold_dims "https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts"
click node_gold_fact "https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts"

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_bronze,node_bronze_ddl,node_silver,node_gold_dims,node_gold_fact toneBlue
class node_semantic,node_measures,node_reports,node_database toneAmber
class node_init toneMint
class node_analyst toneIndigo
class node_csv toneTeal
```

## Components

### SQL Warehouse

- [Bronze load](https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts): `scripts`
- [Bronze tables](https://github.com/zellyirigon/sql-data-warehouse-powerbi/blob/main/scripts/ddl_bronze.sql): `scripts/ddl_bronze.sql`
- [Silver load](https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts): `scripts`
- [Gold dimensions](https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts): `scripts`
- [Gold sales fact](https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/scripts): `scripts`

### Power BI Reporting

- **Semantic model**
- **DAX measures**
- **Report pages**

### Database Setup

- [Initialize schemas](https://github.com/zellyirigon/sql-data-warehouse-powerbi/blob/main/scripts/init_database.sql): `scripts/init_database.sql`

### Other components

- **Analyst**
- [CRM and ERP CSVs](https://github.com/zellyirigon/sql-data-warehouse-powerbi/tree/main/dataset): `dataset`
- **SQL Server**

## Connections

- Analyst → Initialize schemas: runs setup (evidence: `README.md`)
- Initialize schemas → SQL Server: creates schemas (evidence: `README.md`)
- CRM and ERP CSVs → Bronze load: bulk loads (evidence: `README.md`)
- Bronze tables → SQL Server: defines tables (evidence: `README.md`)
- Bronze load → SQL Server: loads raw data (evidence: `README.md`)
- Bronze load → Silver load: loads next (evidence: `README.md`)
- Silver load → SQL Server: writes cleaned data (evidence: `README.md`)
- Gold dimensions → SQL Server: defines views (evidence: `README.md`)
- Gold sales fact → SQL Server: defines view (evidence: `README.md`)
- Semantic model → Gold dimensions: connects to (evidence: `README.md`)
- Semantic model → Gold sales fact: connects to (evidence: `README.md`)
- Semantic model → DAX measures: includes (evidence: `README.md`)
- DAX measures → Report pages: supports (evidence: `README.md`)
- Analyst → Report pages: views (evidence: `README.md`)
