# jotis86/people-analytics-project architecture

> Architecture diagram of the GitHub repository jotis86/people-analytics-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-03-31). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/jotis86/people-analytics-project
- Repository: https://github.com/jotis86/people-analytics-project

## Overview

##### Project Type and Purpose
- The system combines interactive data analysis and visualization using Power BI with data cleaning, processing, and additional analysis performed in Python. There is also an interactive web app powered by Streamlit.
- This is a full-stack analytics project that integrates multiple tools – Power BI for interactive dashboards, Python (with Pandas, Matplotlib, and Seaborn) for data cleaning and visualizations, and Streamlit for dynamic web presentation.

##### Break Down the File Structure to Identify Key Components
- The “app/” directory contains the web app (Streamlit) that serves results to end users.
- The “assets/” folder holds related images and branding assets.
- The “data/” folder contains raw and processed data (e.g., raw CSVs or Excel files).
- The “notebook/” directory contains Jupyter notebooks used for data cleaning and visualization with Python.
- The “powerbi/” directory contains Power BI project files (dashboard.pbix, related media such as clip.mp4) to create interactive dashboards.
- The “summary_report/” folder holds the summary insights and supporting documentation (its own README and images).
- Other files like “requirements.txt”, “README.md”, and “LICENSE” provide project documentation and dependency management.

##### Main Components and Their Relationships
a. Data Sources:
– Raw data is stored in the “data” and “notebook” directories (data.xlsx, data_cleaned.xlsx, csv files).
b. Data Processing and Transformation:
– Jupyter notebooks in “notebook/” perform cleaning and visualization tasks using Python (Pandas for cleaning; Matplotlib/Seaborn for plotting).
c. Reporting and Visualization:
d. Web Application:
– Streamlit app in “app/” provides an interactive front-end that displays the processed and visualized data to end users.
e. Supporting & Presentation Layers:
– “assets/” hold related images.
– “summary_report/” provides conclusive insights and a report.

##### Architectural Patterns and Design Principles
- Separation of Concerns: Different directories clearly separate data ingestion and cleansing (notebooks, data), visualization (Power BI, notebooks), and presentation (Streamlit web app).
- ETL Flow: Data goes through extraction (data files), transformation (cleaning notebooks and Python scripts), and loading (streamlit app and Power BI dashboards).
- Integration Points: Although each analysis tool (Python, Power BI, and Streamlit) works with preprocessed data, they are integrated into the overall People Analytics platform.
- Modularity: Each component (data processing, visualization, web presentation) is decoupled for easier maintenance and future scalability.

## Diagram (Mermaid)

```mermaid
flowchart TD
    subgraph "Data Sources"
        DF("Data Files"):::storage
        NB("Notebooks (Raw Data)"):::storage
    end

    subgraph "Python Data Processing"
        DC("Data Cleaning (Python)"):::process
        DV("Data Visualization (Python)"):::process
        DC --> DV
    end

    DF -->|"extracts"| DC
    NB -->|"provides raw data"| DC

    DV -->|"feeds"| PB("Power BI Dashboard"):::dashboard
    DV -->|"feeds"| SA("Streamlit App"):::web

    subgraph "Supporting & Presentation"
        AS("Assets"):::assets
        SR("Summary Report"):::report
    end

    AS -->|"provides_assets"| SA
    PB -->|"aggregates"| SR
    SA -->|"aggregates"| SR

    click DF "https://github.com/jotis86/people-analytics-project/tree/main/data/"
    click NB "https://github.com/jotis86/people-analytics-project/tree/main/notebook/"
    click DC "https://github.com/jotis86/people-analytics-project/blob/main/notebook/data_cleaning.ipynb"
    click DV "https://github.com/jotis86/people-analytics-project/blob/main/notebook/data_visualization.ipynb"
    click PB "https://github.com/jotis86/people-analytics-project/tree/main/powerbi/"
    click SA "https://github.com/jotis86/people-analytics-project/tree/main/app/"
    click AS "https://github.com/jotis86/people-analytics-project/tree/main/assets/"
    click SR "https://github.com/jotis86/people-analytics-project/tree/main/summary_report/"

    classDef storage fill:#FFECB3,stroke:#BF360C,stroke-width:2px;
    classDef process fill:#BBDEFB,stroke:#0D47A1,stroke-width:2px;
    classDef dashboard fill:#C8E6C9,stroke:#1B5E20,stroke-width:2px;
    classDef web fill:#F8BBD0,stroke:#880E4F,stroke-width:2px;
    classDef assets fill:#DCEDC8,stroke:#33691E,stroke-width:2px;
    classDef report fill:#FFF9C4,stroke:#F57F17,stroke-width:2px;
```
