When working with logistics data, it would often become neccessary to quickly and effectively calculate the mileage or time to travel between two points. This automates those two functions, performing them by using Javascript within Google Sheet's Script Feature
A snapshot of a PDF export of a data visualization for a logistics client. This data has been altered to protect the client's privacy.
Without revealing customer data, this example shows the kind of SQL Queries I use on a daily basis. This example shows the top three performing carriers based on their on time percentage, their number of trucks, and their service rating. More advanced queries can be completed with a little elbow grease.