Consultancy Optimises SQL & R Workflows to enable faster access to more accurate data modelling, quicker responses to market demands and improved decision-making.
Context
A major global property consultancy, founded in London in 1986, operates across both residential and commercial real estate. Together with its international affiliates, it is one of the world’s largest property advisory networks, spanning more than fifty-five countries and supporting billions in real estate transactions annually.
The Challenge
As part of a broader digital transformation programme, the organisation introduced innovative technology into its data environment. However, internal teams lacked experience with the newly added systems, slowing down project delivery and impacting operational efficiency.
One critical process using SQL and R to calculate drive times between properties was particularly problematic. The workflow took between 2 and 3 days to complete, causing bottlenecks across teams that relied on this data.
The Solution
To address these challenges, specialised SQL technical support for property workflows was provided through targeted consultancy and direct guidance.
Key improvements included:
- Optimising the SQL and R scripts powering the property drive-time calculations
- Enhancing the workflow structure to make it more efficient and dependable
- Supporting internal teams with practical training and best-practice recommendations
By improving the underlying technical processes and offering expert support, the organisation could adopt the innovative technology faster without requiring staff to learn everything from the ground up.
The Results & Benefits
- Ninety-five percent Faster Processing – The previous 2–3-day operation now completes in just 3 hours.
- Real-Time, Frequent Updates – The workflow now runs overnight instead of weekly or monthly ensuring teams always have the most up-to-date property data.