Case Study: Public Transportation Company achieves route and demand insights with Alteryx

Blending Data for Public Transportation Optimization

The Public Transportation Company in Panama, which moves more than 500,000 passengers a day across nearly 400 routes and 1,400 buses, needed to make sense of operational data that came from multiple systems with no clear common point of contact. Using Alteryx, the team set out to match bus locations, routes, stops, and transaction records despite inconsistent latitude/longitude data and time stamps.

Alteryx blended data from route, stop, pattern, AVL, and transaction sources so the company could analyze activity by route, bus, stop, and demand patterns. The solution enabled practical operational insights from previously disconnected data, and Alteryx was the only vendor among five that could deliver a workable answer to the challenge.