How can we make the file upload and validation process more efficient so law enforcement investigators can quickly determine if the Call Detail Record (CDR) files have complete data to be plotted on a map?
GeoTime Glimpse is a visual analytics tool that allow investigators to map the date and location of a person of interest's cellphone activity to determine if the lead is worth pursuing. CDR files usually come as a zipped package of nondescript Excel or CSV files. The CDRs must be accompanied by matching tower files, which contain the geolocation coordinates, to be plotted on a map. With the state of the tool at the time, investigators had no easy way of determining the completeness of the files without further investigating the amount of plotted events across different charts.
Working directly with a company partner, engineering team lead, and customer support manager, we iterated on hand-drawn user flow sketches from the point of login to the file validation screen to determine the sequence and how to present information, where we can cut down on screens, what functionalities are needed, etc.
We wanted to support drag-and-drop from the beginning so investigators can upload all the files from their zipped folders at once. On the file validation screen, we explored listing each uploaded file and its status (e.g., "OK" or "Missing matching tower file") and aggregated visuals to help investigators determine the completeness of the files.
Once the team was aligned on the sketches, I began the high-fidelity designs on Figma and prototyping animations / interactions while the engineering team began developing the functionalities and rough layouts based on the sketches.
Our solutions were based on three key improvements:
- Load multiple files faster with drag and drop
- Easily assess the completeness of the files
- Go from logging-in to analyzing on a map quickly
Next Up: Equity Research for Portfolio ManagersView Case Study