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.