# shivharis2007-dot/sql-project-iit-patna architecture

> Architecture diagram of the GitHub repository shivharis2007-dot/sql-project-iit-patna, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-10). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/shivharis2007-dot/sql-project-iit-patna
- Repository: https://github.com/shivharis2007-dot/sql-project-iit-patna

## Overview

This repository documents a sales-analysis project combining SQL queries, spreadsheet cleaning and enrichment, and a planned Tableau dashboard. The principal workflow is to prepare order data, analyze business questions, and report findings; the README also records validation metrics and key decisions. The tree does not match several paths in the README, and no source excerpts were provided, so relationships below rely on documented statements only. Tableau is explicitly not yet built or published.

Main entry points: [`corrected code`](https://github.com/shivharis2007-dot/sql-project-iit-patna/tree/main/corrected%20code) (Business Queries), [`spreadsheet_notes (2).md`](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/spreadsheet_notes%20(2).md) (Clean And Enrich), [`README.md`](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/README.md) (Sales Findings), [`dashboard_spec.md`](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/dashboard_spec.md) (Dashboard Specification)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Spreadsheet Data"]
  node_enriched_orders["Enriched Orders"]
  node_spreadsheet_process["Clean And Enrich"]
  node_clean_orders["Completed Orders<br/>[orders_clean.csv]"]
  node_spreadsheet_notes["Spreadsheet Results"]
end

subgraph group_sql["SQL Analysis"]
  node_sql_queries["Business Queries"]
  node_pending["Pending Orders"]
  node_missing_amount["Missing Amounts"]
  node_top_orders["Top Completed Orders"]
  node_customer_segment["Customer Segment"]
  node_headline_kpis["Headline KPIs"]
  node_status_counts["Orders By Status"]
  node_strong_products["Strong Products"]
  node_region_customers["Regional Customer Stats"]
  node_enriched_orders_sql["Enriched Order Query"]
  node_customers_without_orders["Customers Without Orders"]
  node_monthly_summary["Monthly Region Summary"]
  node_item_tiers["Item Contribution Tiers"]
  node_rep_performance["Rep Target Performance"]
end

subgraph group_reporting["Reporting"]
  node_findings["Sales Findings<br/>[README.md]"]
  node_dashboard_spec["Dashboard Specification<br/>[dashboard_spec.md]"]
end

node_analyst(("Analyst"))
node_tableau["Tableau Public"]

node_analyst -->|"cleans and enriches"| node_spreadsheet_process
node_enriched_orders -->|"spreadsheet input"| node_spreadsheet_process
node_spreadsheet_process -->|"produces completed output"| node_clean_orders
node_spreadsheet_process -->|"documents formulas and checks"| node_spreadsheet_notes
node_analyst -->|"runs business analyses"| node_sql_queries
node_sql_queries -->|"includes"| node_pending
node_sql_queries -->|"includes"| node_missing_amount
node_sql_queries -->|"includes"| node_top_orders
node_sql_queries -->|"includes"| node_customer_segment
node_sql_queries -->|"includes"| node_headline_kpis
node_sql_queries -->|"includes"| node_status_counts
node_sql_queries -->|"includes"| node_strong_products
node_sql_queries -->|"includes"| node_region_customers
node_sql_queries -->|"includes"| node_enriched_orders_sql
node_sql_queries -->|"includes"| node_customers_without_orders
node_sql_queries -->|"includes"| node_monthly_summary
node_sql_queries -->|"includes"| node_item_tiers
node_sql_queries -->|"includes"| node_rep_performance
node_analyst -->|"reviews"| node_findings
node_spreadsheet_notes -->|"supports validation"| node_findings
node_findings -.->|"informs planned visualization"| node_dashboard_spec
node_dashboard_spec -.->|"planned publication"| node_tableau

click node_enriched_orders "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/orders_enriched.csv"
click node_spreadsheet_process "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/spreadsheet_notes%20(2).md"
click node_clean_orders "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/orders_clean.csv"
click node_spreadsheet_notes "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/spreadsheet_notes%20(2).md"
click node_sql_queries "https://github.com/shivharis2007-dot/sql-project-iit-patna/tree/main/corrected%20code"
click node_pending "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql01_pending_orders.sql"
click node_missing_amount "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql02_missing_amount.sql"
click node_top_orders "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql03_top5_completed_orders.sql"
click node_customer_segment "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql04_target_customer_segment.sql"
click node_headline_kpis "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql05_headline_kpis.sql"
click node_status_counts "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql06_orders_by_status.sql"
click node_strong_products "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql07_strong_products.sql"
click node_region_customers "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql08_customer_stats_by_region.sql"
click node_enriched_orders_sql "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql09_orders_enriched.sql"
click node_customers_without_orders "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql10_customers_without_orders.sql"
click node_monthly_summary "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql11_region_month_summary.sql"
click node_item_tiers "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql12_item_contribution_tier.sql"
click node_rep_performance "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql13_rep_target_performance.sql"
click node_findings "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/README.md"
click node_dashboard_spec "https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/dashboard_spec.md"

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_enriched_orders,node_spreadsheet_process,node_clean_orders,node_spreadsheet_notes toneBlue
class node_sql_queries,node_pending,node_missing_amount,node_top_orders,node_customer_segment,node_headline_kpis,node_status_counts,node_strong_products,node_region_customers,node_enriched_orders_sql,node_customers_without_orders,node_monthly_summary,node_item_tiers,node_rep_performance toneAmber
class node_findings,node_dashboard_spec toneMint
class node_analyst,node_tableau toneIndigo
```

## Components

### Spreadsheet Data

- [Enriched Orders](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/orders_enriched.csv): `orders_enriched.csv`
- [Clean And Enrich](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/spreadsheet_notes%20(2).md): `spreadsheet_notes (2).md`
- [Completed Orders](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/orders_clean.csv): `orders_clean.csv`
- [Spreadsheet Results](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/spreadsheet_notes%20(2).md): `spreadsheet_notes (2).md`

### SQL Analysis

- [Business Queries](https://github.com/shivharis2007-dot/sql-project-iit-patna/tree/main/corrected%20code): `corrected code`
- [Pending Orders](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql01_pending_orders.sql): `corrected code/sql01_pending_orders.sql`
- [Missing Amounts](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql02_missing_amount.sql): `corrected code/sql02_missing_amount.sql`
- [Top Completed Orders](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql03_top5_completed_orders.sql): `corrected code/sql03_top5_completed_orders.sql`
- [Customer Segment](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql04_target_customer_segment.sql): `corrected code/sql04_target_customer_segment.sql`
- [Headline KPIs](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql05_headline_kpis.sql): `corrected code/sql05_headline_kpis.sql`
- [Orders By Status](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql06_orders_by_status.sql): `corrected code/sql06_orders_by_status.sql`
- [Strong Products](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql07_strong_products.sql): `corrected code/sql07_strong_products.sql`
- [Regional Customer Stats](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql08_customer_stats_by_region.sql): `corrected code/sql08_customer_stats_by_region.sql`
- [Enriched Order Query](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql09_orders_enriched.sql): `corrected code/sql09_orders_enriched.sql`
- [Customers Without Orders](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql10_customers_without_orders.sql): `corrected code/sql10_customers_without_orders.sql`
- [Monthly Region Summary](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql11_region_month_summary.sql): `corrected code/sql11_region_month_summary.sql`
- [Item Contribution Tiers](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql12_item_contribution_tier.sql): `corrected code/sql12_item_contribution_tier.sql`
- [Rep Target Performance](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/corrected%20code/sql13_rep_target_performance.sql): `corrected code/sql13_rep_target_performance.sql`

### Reporting

- [Sales Findings](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/README.md): `README.md`
- [Dashboard Specification](https://github.com/shivharis2007-dot/sql-project-iit-patna/blob/main/dashboard_spec.md): `dashboard_spec.md`

### Other components

- **Analyst**
- **Tableau Public**

## Connections

- Analyst → Clean And Enrich: cleans and enriches (evidence: `README.md`)
- Enriched Orders → Clean And Enrich: spreadsheet input (evidence: `README.md`)
- Clean And Enrich → Completed Orders: produces completed output (evidence: `README.md`)
- Clean And Enrich → Spreadsheet Results: documents formulas and checks (evidence: `README.md`)
- Analyst → Business Queries: runs business analyses (evidence: `README.md`)
- Business Queries → Pending Orders: includes (evidence: `README.md`)
- Business Queries → Missing Amounts: includes (evidence: `README.md`)
- Business Queries → Top Completed Orders: includes (evidence: `README.md`)
- Business Queries → Customer Segment: includes (evidence: `README.md`)
- Business Queries → Headline KPIs: includes (evidence: `README.md`)
- Business Queries → Orders By Status: includes (evidence: `README.md`)
- Business Queries → Strong Products: includes (evidence: `README.md`)
- Business Queries → Regional Customer Stats: includes (evidence: `README.md`)
- Business Queries → Enriched Order Query: includes (evidence: `README.md`)
- Business Queries → Customers Without Orders: includes (evidence: `README.md`)
- Business Queries → Monthly Region Summary: includes (evidence: `README.md`)
- Business Queries → Item Contribution Tiers: includes (evidence: `README.md`)
- Business Queries → Rep Target Performance: includes (evidence: `README.md`)
- Analyst → Sales Findings: reviews (evidence: `README.md`)
- Spreadsheet Results → Sales Findings: supports validation (evidence: `README.md`)
- Sales Findings → Dashboard Specification: informs planned visualization (evidence: `README.md`)
- Dashboard Specification → Tableau Public: planned publication (evidence: `README.md`)