Return to Office Case Study Header

Return-To-Office (RTO) Distance Dashboard

Built a geospatial analytics dashboard to quantify the impacts of commuting distance/time and support policy decisions on office return thresholds.

What impact will the RTO policy have on current employees?

  • How many employees live within X miles/minutes of each office?
  • Who is most impacted (e.g., long commutes), and where are employee hotspots?
  • What is the capacity of a reporting location?

What types of data were used?

  • Employees home addresses
  • Reporting location addresses
  • Capacity at each location
  • Geographic data

Process

Normalized Employee and Location Addresses

Removed special characters and whitespaces

→ parsed the address into individual parts

→ generalized each part of the address

→ combined the parts

Google Maps API

Made API call to retrieve the rooftop longitude and latitude for each address

Whose closest?

Calculated the haversine distance from each location to each employee and clustered them to the nearest location.

Dashboard

OVERVIEW TAB: Infographics based on location capacity and employees as well as drill down section showing employee details.

MAP TAB Added the data to a Oracle FDI dashboard with dynamic coloring based on locations and individual employees with filters based on the requirments

Results

  • Informed leadership decision on RTO threshold by quantifying impact tradeoffs in a visually intuitive way
  • Identified offices with the highest commute burden and supported targeted exceptions
  • Reduced manual analysis time (e.g., from days to minutes)
  • Improved transparency: consistent metric definitions and scenario analysis
View Resume CONTACT ME