Skip links

Modern Data Landscape Executive Reporting

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 

  • 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​​
  • 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​
Real Estate​
20 (for Power BI)
Middle East​
Systems used​
Oracle Primavera, ONSITE, Yardi, Salesforce, Oracle Financials, Informatica MDM, Dev Hub
Project Management, Finance and Procurement