# piyush-nr-tiwari/sql_host_behaviour_analysis architecture

> Architecture diagram of the GitHub repository piyush-nr-tiwari/sql_host_behaviour_analysis, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-22). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/piyush-nr-tiwari/sql_host_behaviour_analysis
- Repository: https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis

## Overview

This repository is an analysis project, not a software runtime. Its stated focus is comparing Airbnb Superhosts with other hosts; the tree also contains query, dashboard, and presentation deliverables. The README does not describe how those artifacts relate or how the analysis is performed, so their connections are omitted.

Main entry points: [`README.md`](https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/README.md) (Host behavior analysis)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_analysis["Analysis subject"]
  node_project_scope["Host behavior analysis<br/>[README.md]"]
  node_host_segments["Superhosts vs others<br/>[README.md]"]
end

subgraph group_deliverables["Project deliverables"]
  node_queries["Analysis queries"]
  node_dashboard["Texas US dashboard"]
  node_presentation["Project presentation"]
end

node_project_scope -->|"compares"| node_host_segments

click node_project_scope "https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/README.md"
click node_host_segments "https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/README.md"
click node_queries "https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/Host%20Behavioural%20Project%20Ananlysis%20-%20Queries.pdf"
click node_dashboard "https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/Texas%20US%20-%20Dashboard.xlsx"
click node_presentation "https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/Host%20Behavioural%20analysis%20Project%20Presentation.pptx"

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_project_scope,node_host_segments toneBlue
class node_queries,node_dashboard,node_presentation toneAmber
```

## Components

### Analysis subject

- [Host behavior analysis](https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/README.md): `README.md`
- [Superhosts vs others](https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/README.md): `README.md`

### Project deliverables

- [Analysis queries](https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/Host%20Behavioural%20Project%20Ananlysis%20-%20Queries.pdf): `Host Behavioural Project Ananlysis - Queries.pdf`
- [Texas US dashboard](https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/Texas%20US%20-%20Dashboard.xlsx): `Texas US - Dashboard.xlsx`
- [Project presentation](https://github.com/piyush-nr-tiwari/sql_host_behaviour_analysis/blob/main/Host%20Behavioural%20analysis%20Project%20Presentation.pptx): `Host Behavioural analysis Project Presentation.pptx`

## Connections

- Host behavior analysis → Superhosts vs others: compares (evidence: `README.md`)
