Problem Statement
Our client, a leading US-based PE firm specializing in the real estate sector, wanted us to pull data from multiple sources and integrate it to build dashboards and derive meaningful business-driven insights for their portfolio investments spread across ten states in the United States of America. Traditionally, the PE firm relied upon labor-intensive research methods by maintaining as many Excel files as the number of sources and portfolio sites. The JMI Analytics Team was roped in to simplify the entire workflow process, delivering value and offering solutions in three broad areas:
- 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.
- To grasp the key real-estate operational metrics at a micro-level to disseminate derived insights to the intended regional property managers.
- Build a detailed tenant profile for each tenant across property sites.