# debajyotiparui26/sql-datawarehouse-superstore architecture

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

- Interactive diagram: https://gitdiagram.com/debajyotiparui26/sql-datawarehouse-superstore
- Repository: https://github.com/debajyotiparui26/sql-datawarehouse-superstore

## Overview

This repository documents a Superstore sales warehouse and Power BI reporting suite. The main workflow loads CSV data into Bronze, transforms it through Silver into a Gold star schema, then uses that analytics layer for interactive reporting. The README describes the layer sequence and dashboard capabilities; SQL source excerpts were unavailable, so links between individual transformations and tables are limited to those documented relationships.

Main entry points: [`superstore_sales_ power_bi - Copy.pbix`](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix) (Power BI Suite), [`Scripts/02_create_raw_data_table_in_bronze_layer.sql`](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/02_create_raw_data_table_in_bronze_layer.sql) (Create Raw Table), [`Scripts/03_load_raw_data_in_bronza.sql`](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/03_load_raw_data_in_bronza.sql) (Load Raw Data), [`Scripts/04_silver_customer.sql`](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/04_silver_customer.sql) (Transform Customers)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingestion["Bronze Ingestion"]
  node_create_schemas["Create Schemas"]
  node_raw_table["Create Raw Table"]
  node_load_bronze["Load Raw Data"]
  node_bronze_data[("bronze.raw_superstore")]
end

subgraph group_silver["Silver Transformations"]
  node_silver_customer["Transform Customers"]
  node_silver_products["Transform Products"]
  node_silver_orders["Transform Orders"]
  node_silver_region["Transform Regions"]
  node_silver_dates["Transform Dates"]
  node_silver_data[("Silver Tables")]
end

subgraph group_gold["Gold Warehouse"]
  node_gold_customer["Customer Dimension"]
  node_gold_product["Product Dimension"]
  node_gold_date["Date Dimension"]
  node_gold_region["Region Dimension"]
  node_gold_sales["Sales Fact"]
  node_gold_schema[("Gold Star Schema")]
end

subgraph group_bi["Power BI Reporting"]
  node_powerbi_report["Power BI Suite"]
  node_sales_page["Sales Overview"]
  node_product_page["Product Insights"]
  node_regional_page["Regional Logistics"]
end

node_csv["Superstore CSV"]
node_report_user(("Report User"))

node_create_schemas -->|"enables schemas"| node_raw_table
node_raw_table -->|"creates table"| node_bronze_data
node_csv -->|"provides rows"| node_load_bronze
node_load_bronze -->|"loads raw data"| node_bronze_data
node_bronze_data -->|"raw source"| node_silver_customer
node_bronze_data -->|"raw source"| node_silver_products
node_bronze_data -->|"raw source"| node_silver_orders
node_bronze_data -->|"raw source"| node_silver_region
node_bronze_data -->|"raw source"| node_silver_dates
node_silver_customer -->|"cleans customers"| node_silver_data
node_silver_products -->|"cleans products"| node_silver_data
node_silver_orders -->|"cleans orders"| node_silver_data
node_silver_region -->|"cleans regions"| node_silver_data
node_silver_dates -->|"cleans dates"| node_silver_data
node_silver_data -->|"builds dimension"| node_gold_customer
node_silver_data -->|"builds dimension"| node_gold_product
node_silver_data -->|"builds dimension"| node_gold_date
node_silver_data -->|"builds dimension"| node_gold_region
node_silver_data -->|"builds fact"| node_gold_sales
node_gold_customer -->|"dimension table"| node_gold_schema
node_gold_product -->|"dimension table"| node_gold_schema
node_gold_date -->|"dimension table"| node_gold_schema
node_gold_region -->|"dimension table"| node_gold_schema
node_gold_sales -->|"fact table"| node_gold_schema
node_gold_schema -->|"feeds reporting"| node_powerbi_report
node_powerbi_report -->|"includes page"| node_sales_page
node_powerbi_report -->|"includes page"| node_product_page
node_powerbi_report -->|"includes page"| node_regional_page
node_report_user -->|"explores"| node_powerbi_report

click node_csv "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Datasets/Sample%20-%20Superstore.csv"
click node_create_schemas "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/01_create_databases_and%20schemas.sql"
click node_raw_table "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/02_create_raw_data_table_in_bronze_layer.sql"
click node_load_bronze "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/03_load_raw_data_in_bronza.sql"
click node_silver_customer "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/04_silver_customer.sql"
click node_silver_products "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/05_silver_products.sql"
click node_silver_orders "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/06_silver_orders.sql"
click node_silver_region "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/07_silver_region.sql"
click node_silver_dates "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/08_silver.dates.sql"
click node_gold_customer "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/09_gold_dim_customer.sql"
click node_gold_product "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/10_gold_dim_product.sql"
click node_gold_date "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/11_gold_dim_date.sql"
click node_gold_region "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/12_gold_dim_region.sql"
click node_gold_sales "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/13_gold_fact_sales.sql"
click node_powerbi_report "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix"
click node_sales_page "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix"
click node_product_page "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix"
click node_regional_page "https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix"

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_create_schemas,node_raw_table,node_load_bronze,node_bronze_data,node_report_user toneBlue
class node_silver_customer,node_silver_products,node_silver_orders,node_silver_region,node_silver_dates,node_silver_data toneAmber
class node_gold_customer,node_gold_product,node_gold_date,node_gold_region,node_gold_sales,node_gold_schema toneMint
class node_powerbi_report,node_sales_page,node_product_page,node_regional_page toneRose
class node_csv toneTeal
```

## Components

### Bronze Ingestion

- [Create Schemas](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/01_create_databases_and%20schemas.sql): `Scripts/01_create_databases_and schemas.sql`
- [Create Raw Table](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/02_create_raw_data_table_in_bronze_layer.sql): `Scripts/02_create_raw_data_table_in_bronze_layer.sql`
- [Load Raw Data](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/03_load_raw_data_in_bronza.sql): `Scripts/03_load_raw_data_in_bronza.sql`
- **bronze.raw_superstore**

### Silver Transformations

- [Transform Customers](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/04_silver_customer.sql): `Scripts/04_silver_customer.sql`
- [Transform Products](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/05_silver_products.sql): `Scripts/05_silver_products.sql`
- [Transform Orders](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/06_silver_orders.sql): `Scripts/06_silver_orders.sql`
- [Transform Regions](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/07_silver_region.sql): `Scripts/07_silver_region.sql`
- [Transform Dates](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/08_silver.dates.sql): `Scripts/08_silver.dates.sql`
- **Silver Tables**

### Gold Warehouse

- [Customer Dimension](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/09_gold_dim_customer.sql): `Scripts/09_gold_dim_customer.sql`
- [Product Dimension](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/10_gold_dim_product.sql): `Scripts/10_gold_dim_product.sql`
- [Date Dimension](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/11_gold_dim_date.sql): `Scripts/11_gold_dim_date.sql`
- [Region Dimension](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/12_gold_dim_region.sql): `Scripts/12_gold_dim_region.sql`
- [Sales Fact](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Scripts/13_gold_fact_sales.sql): `Scripts/13_gold_fact_sales.sql`
- **Gold Star Schema**

### Power BI Reporting

- [Power BI Suite](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix): `superstore_sales_ power_bi - Copy.pbix`
- [Sales Overview](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix): `superstore_sales_ power_bi - Copy.pbix`
- [Product Insights](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix): `superstore_sales_ power_bi - Copy.pbix`
- [Regional Logistics](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/superstore_sales_%20power_bi%20-%20Copy.pbix): `superstore_sales_ power_bi - Copy.pbix`

### Other components

- [Superstore CSV](https://github.com/debajyotiparui26/sql-datawarehouse-superstore/blob/main/Datasets/Sample%20-%20Superstore.csv): `Datasets/Sample - Superstore.csv`
- **Report User**

## Connections

- Create Schemas → Create Raw Table: enables schemas
- Create Raw Table → bronze.raw_superstore: creates table
- Superstore CSV → Load Raw Data: provides rows
- Load Raw Data → bronze.raw_superstore: loads raw data
- bronze.raw_superstore → Transform Customers: raw source
- bronze.raw_superstore → Transform Products: raw source
- bronze.raw_superstore → Transform Orders: raw source
- bronze.raw_superstore → Transform Regions: raw source
- bronze.raw_superstore → Transform Dates: raw source
- Transform Customers → Silver Tables: cleans customers
- Transform Products → Silver Tables: cleans products
- Transform Orders → Silver Tables: cleans orders
- Transform Regions → Silver Tables: cleans regions
- Transform Dates → Silver Tables: cleans dates
- Silver Tables → Customer Dimension: builds dimension
- Silver Tables → Product Dimension: builds dimension
- Silver Tables → Date Dimension: builds dimension
- Silver Tables → Region Dimension: builds dimension
- Silver Tables → Sales Fact: builds fact
- Customer Dimension → Gold Star Schema: dimension table
- Product Dimension → Gold Star Schema: dimension table
- Date Dimension → Gold Star Schema: dimension table
- Region Dimension → Gold Star Schema: dimension table
- Sales Fact → Gold Star Schema: fact table
- Gold Star Schema → Power BI Suite: feeds reporting
- Power BI Suite → Sales Overview: includes page
- Power BI Suite → Product Insights: includes page
- Power BI Suite → Regional Logistics: includes page
- Report User → Power BI Suite: explores