# jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi- architecture

> Architecture diagram of the GitHub repository jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-, 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/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-
- Repository: https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-

## Overview

This is a retail customer-shopping analytics project. Its documented workflow turns raw shopping data into cleaned analysis, SQL business queries, a Power BI dashboard, and business insights for decision-makers. The graph uses the repository’s actual flat-file paths; some filenames differ from the README’s illustrative directory structure. Relationships are based on README statements only, since no source excerpts were provided.

Main entry points: [`Customer_Shopping_Behavior_Analysis.ipynb`](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/Customer_Shopping_Behavior_Analysis.ipynb) (Python analysis), [`customer_behavior_dashboard.pbix`](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_behavior_dashboard.pbix) (Power BI dashboard), [`customer_shopping_behavior.csv`](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_shopping_behavior.csv) (Customer data), [`customer_behavior_sql_queries.sql`](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_behavior_sql_queries.sql) (Business queries)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Shopping Data"]
  node_raw_data["Customer data"]
end

subgraph group_analysis["Analytics Workflow"]
  node_python_analysis["Python analysis"]
  node_sql_db[("SQL database")]
  node_sql_queries["Business queries"]
end

subgraph group_bi["Business Intelligence"]
  node_dashboard["Power BI dashboard"]
end

subgraph group_outputs["Business Outputs"]
  node_business_problem["Business problem"]
  node_analysis_report["Analysis document"]
end

node_retail(("Retail stakeholders"))

node_raw_data -->|"analyzes"| node_python_analysis
node_python_analysis -->|"prepares data for"| node_sql_db
node_sql_queries -->|"queries"| node_sql_db
node_sql_db -->|"feeds analysis"| node_dashboard
node_dashboard -->|"presents insights"| node_retail

click node_raw_data "https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_shopping_behavior.csv"
click node_python_analysis "https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/Customer_Shopping_Behavior_Analysis.ipynb"
click node_sql_queries "https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_behavior_sql_queries.sql"
click node_dashboard "https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_behavior_dashboard.pbix"
click node_business_problem "https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/Business%20Problem%20%20Document.pdf"
click node_analysis_report "https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/Customer%20Shopping%20Behavior%20Analysis.pdf"

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_raw_data toneBlue
class node_python_analysis,node_sql_db,node_sql_queries toneAmber
class node_dashboard toneMint
class node_business_problem,node_analysis_report toneRose
class node_retail toneIndigo
```

## Components

### Shopping Data

- [Customer data](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_shopping_behavior.csv): `customer_shopping_behavior.csv`

### Analytics Workflow

- [Python analysis](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/Customer_Shopping_Behavior_Analysis.ipynb): `Customer_Shopping_Behavior_Analysis.ipynb`
- **SQL database**
- [Business queries](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_behavior_sql_queries.sql): `customer_behavior_sql_queries.sql`

### Business Intelligence

- [Power BI dashboard](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/customer_behavior_dashboard.pbix): `customer_behavior_dashboard.pbix`

### Business Outputs

- [Business problem](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/Business%20Problem%20%20Document.pdf): `Business Problem Document.pdf`
- [Analysis document](https://github.com/jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi-/blob/main/Customer%20Shopping%20Behavior%20Analysis.pdf): `Customer Shopping Behavior Analysis.pdf`

### Other components

- **Retail stakeholders**

## Connections

- Customer data → Python analysis: analyzes (evidence: `README.md`)
- Python analysis → SQL database: prepares data for (evidence: `README.md`)
- Business queries → SQL database: queries (evidence: `README.md`)
- SQL database → Power BI dashboard: feeds analysis (evidence: `README.md`)
- Power BI dashboard → Retail stakeholders: presents insights (evidence: `README.md`)
