# utkarshlimbachiya-03/sales-analytics-using-azure-databricks architecture

> Architecture diagram of the GitHub repository utkarshlimbachiya-03/sales-analytics-using-azure-databricks, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-19). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks
- Repository: https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks
- Video tour (about a minute): https://gitdiagram.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/video

## Overview

This repository documents a two-phase retail-sales analytics workflow: cloud ingestion, quality investigation and cleaning produce persisted Delta data, which is then continued locally for SQL-based business analysis. The README supports the stages and their relationships, but no notebook contents were provided; notebook-to-stage assignments are therefore limited to what their filenames suggest, and the graph does not assert unverified implementation details.

Main entry points: [`Utkarsh_Sales Project.ipynb`](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/Utkarsh_Sales%20Project.ipynb) (Local data reading), [`DeltaLake.ipynb`](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/DeltaLake.ipynb) (Quality and cleaning), [`notebook/data_quality_investigation.ipynb`](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/notebook/data_quality_investigation.ipynb) (Data quality investigation), [`notebook/data_analysis.ipynb`](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/notebook/data_analysis.ipynb) (Sales analysis)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_cloud["Cloud processing"]
  node_adls[("Azure Data Lake")]
  node_databricks["Azure Databricks"]
  node_quality_cleaning["Quality and cleaning<br/>[DeltaLake.ipynb]"]
  node_delta[("Delta Lake data")]
end

subgraph group_local["Local analysis"]
  node_local_reading["Local data reading"]
  node_quality_investigation["Data quality investigation"]
  node_sales_analysis["Sales analysis"]
  node_performance["Sales performance"]
end

subgraph group_outcomes["Business outcomes"]
  node_findings["Findings and direction<br/>[README.md]"]
end

node_analyst(("Analyst"))
node_raw_sales[("Raw sales data")]

node_analyst -->|"provides data"| node_raw_sales
node_raw_sales -->|"ingested to"| node_adls
node_adls -->|"processed in"| node_databricks
node_databricks -->|"runs"| node_quality_cleaning
node_quality_cleaning -->|"persists cleaned data"| node_delta
node_delta -->|"continues locally"| node_local_reading
node_local_reading -->|"supports assessment"| node_quality_investigation
node_local_reading -->|"supports analysis"| node_sales_analysis
node_sales_analysis -->|"examines patterns"| node_performance
node_performance -->|"informs direction"| node_findings
node_quality_investigation -->|"informs decisions"| node_findings

click node_quality_cleaning "https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/DeltaLake.ipynb"
click node_local_reading "https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/Utkarsh_Sales%20Project.ipynb"
click node_quality_investigation "https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/notebook/data_quality_investigation.ipynb"
click node_sales_analysis "https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/notebook/data_analysis.ipynb"
click node_performance "https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/notebook/sales_performance.ipynb"
click node_findings "https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/README.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_adls,node_databricks,node_quality_cleaning,node_delta toneBlue
class node_local_reading,node_quality_investigation,node_sales_analysis,node_performance,node_raw_sales toneAmber
class node_findings toneMint
class node_analyst toneIndigo
```

## Components

### Cloud processing

- **Azure Data Lake**
- **Azure Databricks**
- [Quality and cleaning](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/DeltaLake.ipynb): `DeltaLake.ipynb`
- **Delta Lake data**

### Local analysis

- [Local data reading](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/Utkarsh_Sales%20Project.ipynb): `Utkarsh_Sales Project.ipynb`
- [Data quality investigation](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/notebook/data_quality_investigation.ipynb): `notebook/data_quality_investigation.ipynb`
- [Sales analysis](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/notebook/data_analysis.ipynb): `notebook/data_analysis.ipynb`
- [Sales performance](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/notebook/sales_performance.ipynb): `notebook/sales_performance.ipynb`

### Business outcomes

- [Findings and direction](https://github.com/utkarshlimbachiya-03/sales-analytics-using-azure-databricks/blob/main/README.md): `README.md`

### Other components

- **Analyst**
- **Raw sales data**

## Connections

- Analyst → Raw sales data: provides data (evidence: `README.md`)
- Raw sales data → Azure Data Lake: ingested to (evidence: `README.md`)
- Azure Data Lake → Azure Databricks: processed in (evidence: `README.md`)
- Azure Databricks → Quality and cleaning: runs (evidence: `README.md`)
- Quality and cleaning → Delta Lake data: persists cleaned data (evidence: `README.md`)
- Delta Lake data → Local data reading: continues locally (evidence: `README.md`)
- Local data reading → Data quality investigation: supports assessment (evidence: `README.md`)
- Local data reading → Sales analysis: supports analysis (evidence: `README.md`)
- Sales analysis → Sales performance: examines patterns (evidence: `README.md`)
- Sales performance → Findings and direction: informs direction (evidence: `README.md`)
- Data quality investigation → Findings and direction: informs decisions (evidence: `README.md`)
