# syeedakudhsia8/asset-management architecture

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

- Interactive diagram: https://gitdiagram.com/syeedakudhsia8/asset-management
- Repository: https://github.com/syeedakudhsia8/asset-management

## Overview

##### Project type and purpose
- This is an Exploratory Data Analysis (EDA) pipeline for commercial real estate asset management.
- It’s not a multi-tier web application or microservice suite but rather a data-processing/visualization workflow that ingests raw Excel data, applies Python/SQL transformations, and publishes charts in Tableau.

##### File structure
Top-level files reveal the main actors:
- Asset_Management_Dataset.xlsx → the raw data source
- Asset_EDA_Analysis.ipynb → Jupyter notebook containing Python/Pandas exploratory code and Matplotlib plots
- business_questions.sql → standalone SQL queries for business logic
- README.md/.gitignore/LICENSE → documentation and repository metadata

##### README for additional insights
- Data: Excel workbook with four sheets (Asset_Managers, Properties, Gross_Values, Property_Details)
- Tools: Python (Pandas, Matplotlib), SQL, Tableau Public, Jupyter

##### Main components & interactions
a. Data Source (Excel file)
b. Processing Layer
- Jupyter Notebook with Python
- Key libraries: pandas, matplotlib
c. Query Layer
- SQL scripts run against the same dataset (could be via SQLite/enterprise RDBMS)
d. Visualization Layer
- Inline notebook charts
- Tableau Public Dashboard
e. Versioning & Collaboration
- Git/GitHub for code and notebook tracking

Relationships:
- Excel → loaded by pandas in Jupyter → DataFrame transformations → inline plots
- Excel → ingested by SQL engine via business_questions.sql → query results
- Transformed data/results → exported (CSV/JSON or direct connector) → Tableau Public → published dashboard
- Git tracks .ipynb, .sql, README, supporting files

##### Architectural patterns & design principles
- Batch-oriented ETL pipeline (Extract from Excel, Transform via Python/SQL, Load to viz)
- Separation of concerns:
- Data ingestion/cleaning (Python notebook)
- Business logic (SQL scripts)
- Visualization (Matplotlib vs. Tableau)
- Modular components that could be swapped (e.g., swap Excel for a database, swap Tableau for another BI tool)

##### Essential elements
- Callouts for major libraries/frameworks (pandas, matplotlib, SQL engine, Tableau Public)
- A note on environment (e.g., Python 3.x virtual environment, Jupyter server)

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Data Source Layer
    subgraph "Data Source Layer"
        Excel[(Asset_Management_Dataset.xlsx)]:::dataSource
    end

    %% Processing & Query Layer
    subgraph "Processing & Query Layer"
        Notebook["Asset_EDA_Analysis.ipynb\n(Jupyter/Python)"]:::processing
        SQL["business_questions.sql\n(SQL Engine)"]:::processing
    end

    %% Visualization Layer
    subgraph "Visualization Layer"
        NotebookChart["Inline Matplotlib Plots"]:::visualization
        Tableau[("Tableau Public Dashboard")]:::visualization
    end

    %% Versioning & Collaboration
    subgraph "Versioning & Collaboration"
        README["README.md"]:::tooling
        Gitignore[".gitignore"]:::tooling
        License["LICENSE"]:::tooling
    end

    %% Data Flows
    Excel -->|"DataFrame"| Notebook
    Notebook -->|"Matplotlib plots"| NotebookChart
    Excel -->|"SQL result set"| SQL
    NotebookChart -->|"CSV/JSON export"| Tableau
    SQL -->|"CSV/JSON export"| Tableau

    %% Collaboration Links
    README -.-> Notebook
    README -.-> SQL
    Gitignore -.-> Notebook
    Gitignore -.-> SQL
    License -.-> Notebook
    License -.-> SQL

    %% Click Events
    click Excel "https://github.com/syeedakudhsia8/asset-management/blob/main/Asset_Management_Dataset.xlsx"
    click Notebook "https://github.com/syeedakudhsia8/asset-management/blob/main/Asset_EDA_Analysis.ipynb"
    click SQL "https://github.com/syeedakudhsia8/asset-management/blob/main/business_questions.sql"
    click README "https://github.com/syeedakudhsia8/asset-management/blob/main/README.md"
    click Gitignore "https://github.com/syeedakudhsia8/asset-management/blob/main/.gitignore"
    click License "https://github.com/syeedakudhsia8/asset-management/tree/main/LICENSE"

    %% Styling
    classDef dataSource fill:#AED6F1,stroke:#1F618D,color:#154360;
    classDef processing fill:#A9DFBF,stroke:#27AE60,color:#145A32;
    classDef visualization fill:#FAD7A0,stroke:#D68910,color:#7D6608;
    classDef tooling fill:#D5D8DC,stroke:#566573,color:#1C2833;
```
