# itstheprashant/sales-customer-dashboard architecture

> Architecture diagram of the GitHub repository itstheprashant/sales-customer-dashboard, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-08-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/itstheprashant/sales-customer-dashboard
- Repository: https://github.com/itstheprashant/sales-customer-dashboard

## Overview

##### Project type and high-level purpose
- This is a **Business Intelligence/data-visualization** project built in **Tableau Desktop**, published to **Tableau Public**.
- Purpose: ingest static CSV datasets, build interactive dashboards (Sales & Customer), and deliver them to business users for KPI tracking and customer insights.

##### File structure
- **Datasets/** : Four CSV files (Orders, Customers, Products, Location).
- **Requirements for Dashboard.pdf** : Functional/visual requirements.
- **README.md** : Documentation & links.

##### Extract architectural insights from README
- Data source relationships (Orders↔Customers↔Products↔Location).
- Two dashboards (Sales, Customer) sharing the same data model.
- Interactive filters (Year, Category/Sub-category, Region/State/City).
- Deployment: published to Tableau Public.

##### Main components & interactions
a. **Data Layer**
b. **Tableau Data Model**
- Shows joins/relationships between the four tables.
c. **Dashboard Layer**
- Two dashboard modules:
- Sales Dashboard
- Customer Dashboard
d. **Interactivity Layer**
- Filters & parameters (Year selector, Category/sub-category, Region/state/city).
e. **Presentation/Consumer Layer**
- Tableau Public (hosted web UI)
- End users (Executives, Sales Managers, Marketing team)
f. **External Services**
- Tableau Public server (for hosting).
- Web browser (user interface).

##### Architectural patterns & design principles
- **Star schema**–style data model within Tableau.
- **Layered architecture:** Data → Data Model → Visualization components → Presentation to end users.
- **Re-use of data source** for both dashboards to ensure consistency.
- **Parametrization & filtering** for dynamic slicing of the same data.

##### Relevant technologies/frameworks
- Tableau Desktop (& Tableau Public)
- CSV (flat-file data stores)
- Calculated fields, parameters, filters (Tableau features)
- Possibly an external data-prep tool (if used) or manual CSV maintenance.

1. Layout the **Data Layer** on the left.
2. Center the **Tableau Data Source** block showing table joins.
5. To the far right, illustrate **Tableau Public** and connect dashboards → Tableau Public.

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Data Layer
    subgraph "Data Layer"
        style DataPrep fill:#ADD8E6,stroke:#000
        OrdersCSV["Orders.csv"]:::dataLayer
        CustomersCSV["Customers.csv"]:::dataLayer
        ProductsCSV["Products.csv"]:::dataLayer
        LocationCSV["Location.csv"]:::dataLayer
        DataPrep["Data Prep"]:::dataLayer
    end

    %% Tableau Data Model
    TableauDS["Tableau Data Source<br/>(Star Schema)"]:::tableauLayer

    %% Dashboards & Filters
    subgraph "Dashboards & Filters"
        style Filters fill:#FFFACD,stroke:#000
        Filters["Filters & Parameters"]:::filters

        style Dashboards fill:#90EE90,stroke:#000
        SalesDash["Sales Dashboard"]:::tableauLayer
        CustomerDash["Customer Dashboard"]:::tableauLayer

        Icons["UI Assets<br/>(Navigation & Filter Icons)"]:::tableauLayer
        Images["UI Assets<br/>(Additional Images)"]:::tableauLayer
    end

    %% Requirements & Documentation
    Requirements["Requirements"]:::external
    README["README & Links"]:::external

    %% Presentation & Users
    TableauPublic("Tableau Public"):::external
    subgraph "End Users"
        Exec["Executives"]:::presentation
        SalesMgr["Sales Managers"]:::presentation
        Marketing["Marketing Team"]:::presentation
    end

    %% Connections
    OrdersCSV --> DataPrep
    CustomersCSV --> DataPrep
    ProductsCSV --> DataPrep
    LocationCSV --> DataPrep
    DataPrep --> TableauDS
    TableauDS --> Filters
    TableauDS --> SalesDash
    TableauDS --> CustomerDash
    Filters --> SalesDash
    Filters --> CustomerDash
    Icons -.-> Filters
    Images -.-> SalesDash
    SalesDash --> TableauPublic
    CustomerDash --> TableauPublic
    TableauPublic --> Exec
    TableauPublic --> SalesMgr
    TableauPublic --> Marketing
    Requirements --> TableauDS
    README --> TableauDS

    %% Click Events
    click OrdersCSV "https://github.com/itstheprashant/sales-customer-dashboard/blob/main/Datasets/Orders.csv"
    click CustomersCSV "https://github.com/itstheprashant/sales-customer-dashboard/blob/main/Datasets/Customers.csv"
    click ProductsCSV "https://github.com/itstheprashant/sales-customer-dashboard/blob/main/Datasets/Products.csv"
    click LocationCSV "https://github.com/itstheprashant/sales-customer-dashboard/blob/main/Datasets/Location.csv"
    click TableauDS "https://github.com/itstheprashant/sales-customer-dashboard/blob/main/Sales & Customer Dashboard.twbx"
    click Requirements "https://github.com/itstheprashant/sales-customer-dashboard/blob/main/Requirements for Dashboard.pdf"
    click Icons "https://github.com/itstheprashant/sales-customer-dashboard/tree/main/Icons/"
    click Images "https://github.com/itstheprashant/sales-customer-dashboard/tree/main/images/"
    click README "https://github.com/itstheprashant/sales-customer-dashboard/blob/main/README.md"

    %% Class Definitions
    classDef dataLayer fill:#ADD8E6,stroke:#000,stroke-width:1px
    classDef tableauLayer fill:#90EE90,stroke:#000,stroke-width:1px,stroke-dasharray: 5 5
    classDef filters fill:#FFFACD,stroke:#000,stroke-width:1px
    classDef external fill:#FFD700,stroke:#000,stroke-width:1px
    classDef presentation fill:#FFA500,stroke:#000,stroke-width:1px
```
