Case Study: Avison Young cuts geospatial query times with Blue Orange Digital

Avison Young cuts geospatial queries from 45 minutes to 5 seconds with Blue Orange Digital

Avison Young, a real estate advisor, faced significant challenges in pricing properties due to inefficient geospatial data analysis. Their analysts struggled to tie foot traffic and spending data to property valuations, with complex queries taking up to 45 minutes to run. This slow process hindered their ability to produce timely client reports. Blue Orange Digital was engaged to address these issues.

Blue Orange Digital built a graph data store on AWS Neptune to link properties, locations, and observed behavior, enabling geospatial queries to run in just seconds. They also implemented an automated data ingestion pipeline using AWS Glue and Astronomer. This solution reduced complex geospatial queries from 45 minutes to 5 seconds and cut the time to add a new data source from 4-6 weeks to just 2-3 days. The work by Blue Orange Digital saved analysts 70% of the time previously spent on data preparation and queries.

Avison Young