Situation
Our client, a leading US-based PE firm specialized in the real estate sector wanted us to pull-in data from multiple sources and integrate them to build dashboards and derive meaningful business-driven insights for their portfolio investments spread across ten states in United States of America.
- Consolidation of financial and operational data from multiple sources for investment sites spanning multiple states.
- Understanding the financial health of portfolio sites by building interactive dashboards.
Solution
- The JMI Team re-worked the entire data inflow process for data processing by building a data lake for quick and easy access of requisite data.
- Performed extensive data pre-processing steps to convert unstructured and semi-structured data coming in from various sources into a structured human readable format for data processing.
- Derived intelligent KPIs based on current and historical financial data and build interactive visual dashboards.
- Individual property-wise profile rich dashboards were built based on clustering techniques. These dashboards also helped to understand tenant behavioural patterns at the granular level. Predictive analytics based on ML were employed to classify tenants based on propensity to make late payments and default on loans.
Outcome
- Intelligent KPIs and insights derived from financial metrics helped the client optimize financial health of portfolio investments and also showcase the findings to potential investors. This led to a substantial growth in interest from prospective investors.
- Dashboards developed to gauge real-estate operational efficiency helped the client achieve more granular control over the functioning of property managers enabling data-driven decision making.
Sample Works
