Route Efficiency Analysis & Visualization

Objective

Evaluate route efficiency, sales discipline, and recommend an optimal visit sequence to optimize logistics operations.

Project Details

• Analyzed travel vs in-store time to measure route efficiency and evaluated sales discipline (plan adherence, punctuality, missed visits).
• Identified routing inefficiencies such as backtracking, zig-zagging, and long jumps.
• Developed a route optimization approach that improved efficiency by 9%.
• Built dashboards in Looker Studio and a custom web application to enhance route visualization and overcome Looker Studio limitations.
• Automated Excel-based calculations using Google Apps Script, reducing manual processing time by up to 3x.

Comments (2)