# gautam9798/customer_behavior_analysis architecture

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

- Interactive diagram: https://gitdiagram.com/gautam9798/customer_behavior_analysis
- Repository: https://github.com/gautam9798/customer_behavior_analysis

## Overview

This repository is an end-to-end customer-shopping analytics project. Its documented workflow uses Python for cleaning and exploratory analysis, SQL for business analysis and segmentation, and Power BI for interactive visualization; the README also reports findings and recommendations. The graph represents those documented stages and the available data and presentation artifacts. No source excerpts are available, so artifact-level handoffs and the presentation’s precise contents cannot be verified beyond the README’s workflow description.

Main entry points: [`customer_behavior_sql_queries.sql`](https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_behavior_sql_queries.sql) (SQL analysis), [`Customer_Shopping_Behavior_Analysis.ipynb`](https://github.com/gautam9798/customer_behavior_analysis/blob/main/Customer_Shopping_Behavior_Analysis.ipynb) (Python analysis), [`customer_behavior_dashboard.pbix`](https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_behavior_dashboard.pbix) (Power BI dashboard), [`customer_shopping_behavior.csv`](https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_shopping_behavior.csv) (Purchase data)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_preparation["Data preparation"]
  node_purchases["Purchase data"]
  node_python_analysis["Python analysis"]
end

subgraph group_analysis["Business analysis"]
  node_sql_analysis["SQL analysis"]
end

subgraph group_reporting["Reporting"]
  node_power_bi["Power BI dashboard"]
  node_presentation["Analysis presentation"]
end

node_analyst(("Analyst"))

node_purchases -->|"analyzes"| node_python_analysis
node_python_analysis -->|"prepares for"| node_sql_analysis
node_sql_analysis -->|"analyzes for"| node_power_bi
node_analyst -->|"explores"| node_power_bi
node_sql_analysis -.->|"informs"| node_presentation

click node_purchases "https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_shopping_behavior.csv"
click node_python_analysis "https://github.com/gautam9798/customer_behavior_analysis/blob/main/Customer_Shopping_Behavior_Analysis.ipynb"
click node_sql_analysis "https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_behavior_sql_queries.sql"
click node_power_bi "https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_behavior_dashboard.pbix"
click node_presentation "https://github.com/gautam9798/customer_behavior_analysis/blob/main/Customer-Shopping-Behavior-Analysis.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_purchases,node_python_analysis toneBlue
class node_sql_analysis toneAmber
class node_power_bi,node_presentation toneMint
class node_analyst toneIndigo
```

## Components

### Data preparation

- [Purchase data](https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_shopping_behavior.csv): `customer_shopping_behavior.csv`
- [Python analysis](https://github.com/gautam9798/customer_behavior_analysis/blob/main/Customer_Shopping_Behavior_Analysis.ipynb): `Customer_Shopping_Behavior_Analysis.ipynb`

### Business analysis

- [SQL analysis](https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_behavior_sql_queries.sql): `customer_behavior_sql_queries.sql`

### Reporting

- [Power BI dashboard](https://github.com/gautam9798/customer_behavior_analysis/blob/main/customer_behavior_dashboard.pbix): `customer_behavior_dashboard.pbix`
- [Analysis presentation](https://github.com/gautam9798/customer_behavior_analysis/blob/main/Customer-Shopping-Behavior-Analysis.pptx): `Customer-Shopping-Behavior-Analysis.pptx`

### Other components

- **Analyst**

## Connections

- Purchase data → Python analysis: analyzes (evidence: `README.md`)
- Python analysis → SQL analysis: prepares for (evidence: `README.md`)
- SQL analysis → Power BI dashboard: analyzes for (evidence: `README.md`)
- Analyst → Power BI dashboard: explores (evidence: `README.md`)
- SQL analysis → Analysis presentation: informs
