How syeedakudhsia8/asset-management works
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)