Centralizing and transforming data with a unified data warehouse for Real Estate Investment Trust

The client, India's first publicly listed retail real estate investment trust, manages a vast portfolio of 17 Grade A urban consumption centers, two hotel assets, and three office assets, covering approximately 9.9 million square feet of gross leasable area across 14 cities. They faced significant challenges managing their expansive portfolio due to scattered data across various departments and vendors. This lack of a centralized data management system hindered their ability to perform business intelligence (BI) and predictive analysis, limiting the data’s potential use for marketing, sales, and brand partnerships.

After a cost-benefit analysis, Azure was identified as the most suitable platform for the data transformation and storage solution. Nexdigm designed and implemented a comprehensive data architecture, including the development of automated Azure cloud pipelines within Azure Data Factory (ADF) and Azure Databricks for data extraction, while Azure SQL served as the central data warehouse.

The implementation of a centralized data warehouse significantly reduced dependency on external vendors for data access. With all data integrated into Power BI, the performance of dashboards improved drastically, enabling timely and more effective business decisions. This newfound agility allowed the client to generate real-time insights, providing valuable information to both brands and investors.