Modern Data Landscape Executive Reporting
Consolidating data from On-Prem source systems to Azure cloud to build sales performance, project management and financial dashboards for the real estate client’s Leadership
- Challenge
- Understand the key measures that the leadership of client tracks to understand the progress, risks and financials for In-Progress projects
- As they are depending on data to inform their decisions at a more granular and at real time level, they could not afford for those data signals to have manual manipulation from source transaction systems
- Solution
- Conducted business workshops with departments reporting frequently to Clients leadership, to identify and prioritize business KPIs
- Conducted workshops with source systems to define API or database connections to extract data and load in Azure data lake
- Client leadership can track CAPEX, handover status, risks and Financial performance across all projects, and drill down to individual project/master plans
Key Value to Business:
- Visibility and accessibility of Projects performance KPIs across LOBs in one view
- Decommissioned On-Prem Data Center / Warehouse, and saved on costs by using Data lake cheap storage
- Master data management concepts reduced the confusion business around projects and customers
- Reduced time to market or going to production by 4 times using Agile / DevOps capabilities