HDB Property Intelligence Platform
- Designed a Medallion Architecture (Bronze → Silver → Gold) using Databricks and Delta Lake
- Integrated resale, rental, property inventory, and housing supply datasets into a unified analytical model
- Built a Star Schema with fact and dimension tables optimized for Power BI reporting
- Created business-ready metrics including property age, price per sqm, rental trends, demand indicators, and investment scores
- Implemented data cleansing, standardization, surrogate key mapping, and dimensional modeling
- Developed interactive dashboards helping users compare towns, evaluate affordability, identify rental yield opportunities, and monitor market trends
Business Value: Enabled home buyers, investors, and analysts to make data-driven property decisions by bringing multiple housing datasets into a single decision-support platform.
