# tusharsonkamble30/swynex-final-data-analytics-project architecture

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

- Interactive diagram: https://gitdiagram.com/tusharsonkamble30/swynex-final-data-analytics-project
- Repository: https://github.com/tusharsonkamble30/swynex-final-data-analytics-project

## Overview

This repository documents a retail-sales analytics case study: prepare a cleaned dataset, explore sales patterns, and present results in a Power BI dashboard for business decisions. The README describes cleaning and validation, analysis of categories, payments, channels, time trends and outliers, plus dashboard KPIs, visuals and slicers. The tree contains the cleaned workbook, notebook and dashboard artifacts, but no cleaning source code; relationships below rely on README documentation rather than inspected implementation.

Main entry points: [`data/cleaned_retail_store_sales.xlsx`](https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/data/cleaned_retail_store_sales.xlsx) (Cleaned Sales Data), [`dashboard/SWYNEX-Interactive-Dashboard.pbix`](https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/dashboard/SWYNEX-Interactive-Dashboard.pbix) (Interactive Dashboard), [`analysis/EDA_Retail_Sales.ipynb`](https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/analysis/EDA_Retail_Sales.ipynb) (Sales Exploration), [`dashboard/SWYNEX-Interactive-Dashboard.pdf`](https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/dashboard/SWYNEX-Interactive-Dashboard.pdf) (Dashboard Export)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Sales Data"]
  node_cleaned["Cleaned Sales Data"]
end

subgraph group_analysis["Exploratory Analysis"]
  node_eda["Sales Exploration"]
end

subgraph group_dashboard["Business Dashboard"]
  node_powerbi["Interactive Dashboard"]
  node_dashboard_pdf["Dashboard Export"]
end

node_kaggle(("Kaggle Dataset"))
node_business_users(("Business Decision Makers"))

node_kaggle -->|"provides source"| node_cleaned
node_cleaned -->|"analyzed in"| node_eda
node_cleaned -->|"feeds dashboard"| node_powerbi
node_powerbi -->|"supports decisions"| node_business_users
node_powerbi -->|"exported as"| node_dashboard_pdf

click node_cleaned "https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/data/cleaned_retail_store_sales.xlsx"
click node_eda "https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/analysis/EDA_Retail_Sales.ipynb"
click node_powerbi "https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/dashboard/SWYNEX-Interactive-Dashboard.pbix"
click node_dashboard_pdf "https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/dashboard/SWYNEX-Interactive-Dashboard.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_cleaned toneBlue
class node_eda toneAmber
class node_powerbi,node_dashboard_pdf toneMint
class node_kaggle,node_business_users toneIndigo
```

## Components

### Sales Data

- [Cleaned Sales Data](https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/data/cleaned_retail_store_sales.xlsx): `data/cleaned_retail_store_sales.xlsx`

### Exploratory Analysis

- [Sales Exploration](https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/analysis/EDA_Retail_Sales.ipynb): `analysis/EDA_Retail_Sales.ipynb`

### Business Dashboard

- [Interactive Dashboard](https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/dashboard/SWYNEX-Interactive-Dashboard.pbix): `dashboard/SWYNEX-Interactive-Dashboard.pbix`
- [Dashboard Export](https://github.com/tusharsonkamble30/swynex-final-data-analytics-project/blob/main/dashboard/SWYNEX-Interactive-Dashboard.pdf): `dashboard/SWYNEX-Interactive-Dashboard.pdf`

### Other components

- **Kaggle Dataset**
- **Business Decision Makers**

## Connections

- Kaggle Dataset → Cleaned Sales Data: provides source (evidence: `README.md`)
- Cleaned Sales Data → Sales Exploration: analyzed in (evidence: `README.md`)
- Cleaned Sales Data → Interactive Dashboard: feeds dashboard (evidence: `README.md`)
- Interactive Dashboard → Business Decision Makers: supports decisions (evidence: `README.md`)
- Interactive Dashboard → Dashboard Export: exported as (evidence: `README.md`)
