# debopriya-ai/ibm-hr-analytics architecture

> Architecture diagram of the GitHub repository debopriya-ai/ibm-hr-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-07-24). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/debopriya-ai/ibm-hr-analytics
- Repository: https://github.com/debopriya-ai/ibm-hr-analytics

## Overview

##### Project type and purpose
- This is a BI/data-visualization project built in Tableau. Its purpose is to ingest HR data, run simple preprocessing (Excel/CSV), and surface interactive dashboards for attrition, job satisfaction, and demographics.

##### File structure
- Top-level files:
- ASSIGNMENT 2 DATA 1205_Final (1).pptx – a presentation export of key findings
- HR Data.zip – raw HR dataset (Excel or CSV)
- HR_Analytics_Dashboard_Tableau (1).twbx – the packaged Tableau workbook containing data extracts, dashboards, and visuals
- LICENSE, README.md – documentation

- There is no multi-tier codebase; it follows a simple data pipeline: raw data → preprocessing → Tableau workbook → presentation.

##### README for additional insights
- Confirms:
- Data volume: 1,470 employee records
- Key analyses: attrition, satisfaction, education
- Tools: Tableau for visualization; Excel/CSV for preprocessing
- Business impact metrics

##### Main components
a. Data Sources
– Excel/CSV files in HR Data.zip
b. Data Preprocessing Layer
– Ad-hoc transforms in Excel (cleanup, pivoting)
c. Tableau Desktop/Engine
– Connects to extracts, builds visualizations
– Twbx packaged workbook holds data extract + dashboard definitions
d. Tableau Server (optional) or File Distribution
– .twbx published to Server or shared directly
e. Presentation Layer
– PPTX slide deck for stakeholders
f. Consumers
– HR analysts, managers viewing dashboards in Tableau Reader/Server or PPT

##### Architectural patterns and design principles
- Simple ETL pipeline pattern (Extract→Transform→Load)
- Single-source of truth via packaged Twbx extract
- Separation of concerns:
- Data layer (raw files)
- Processing layer (Excel)
- Visualization layer (Tableau)
- Delivery layer (Server/Slides)

##### Relevant technologies
- Data: CSV/Excel
- ETL: Excel manual transforms or lightweight scripts (if any)
- BI tool: Tableau Desktop / Server / Reader
- Presentation: PowerPoint

## Diagram (Mermaid)

```mermaid
graph TD

    subgraph "Data Layer"
        DataSources["HR Data.zip"]:::data
    end

    subgraph "ETL Layer"
        Preprocessing["Data Cleansing (Excel)"]:::etl
    end

    subgraph "BI Layer"
        subgraph "Tableau Environment"
            TableauDesktop["Tableau Desktop & Engine"]:::bi
            TwbxWorkbook["TWBX Workbook & Data Extract"]:::bi
            TableauDesktop -->|"creates workbook"| TwbxWorkbook
        end
    end

    subgraph "Delivery Layer"
        TableauServer["Tableau Server (optional)"]:::delivery
        SlideDeck["PPTX Slide Deck"]:::delivery
    end

    subgraph "User Layer"
        HRAnalysts["HR Analysts & Managers"]:::users
    end

    subgraph "Project Documentation"
        README["README.md"]:::docs
        License["LICENSE"]:::docs
    end

    DataSources -->|"source files"| Preprocessing
    Preprocessing -->|"load extract"| TwbxWorkbook
    TwbxWorkbook -->|"publish workbook"| TableauServer
    TwbxWorkbook -->|"export PPTX"| SlideDeck
    TableauServer -->|"view dashboards"| HRAnalysts
    SlideDeck -->|"view slides"| HRAnalysts

    click DataSources "https://github.com/debopriya-ai/ibm-hr-analytics/blob/main/HR Data.zip"
    click TwbxWorkbook "https://github.com/debopriya-ai/ibm-hr-analytics/blob/main/HR_Analytics_Dashboard_Tableau (1).twbx"
    click SlideDeck "https://github.com/debopriya-ai/ibm-hr-analytics/blob/main/ASSIGNMENT 2 DATA 1205_Final (1).pptx"
    click README "https://github.com/debopriya-ai/ibm-hr-analytics/blob/main/README.md"
    click License "https://github.com/debopriya-ai/ibm-hr-analytics/tree/main/LICENSE"

    classDef data fill:#D6E9F8,stroke:#31708F;
    classDef etl fill:#DFF0D8,stroke:#3C763D;
    classDef bi fill:#FCF8E3,stroke:#8A6D3B;
    classDef delivery fill:#F2DEDE,stroke:#A94442;
    classDef users fill:#EEEEEE,stroke:#AAAAAA;
    classDef docs fill:#F5F5F5,stroke:#CCCCCC;
```
