DEV Community

Cover image for 📊 Benefits of a historic wait time API: apigee developer portal & Streamlit
adriens
adriens

Posted on

📊 Benefits of a historic wait time API: apigee developer portal & Streamlit

🤔 Where we come from

We previously did release waiting time and offices as open data and APIs:

... yet we were only able to give the current waiting time snapshot:

Image description

Last year, while projecting myself as a customer, I found that it would be useful to

  1. 💾 Keep the historical data of waiting time in an database : we chose Opensearch to be able to get nice looking dashboards as quick as possible
  2. **🎀 Serve the data **as a nice looking API
  3. 🛒 Share the API on our portal developer on APIGEE
  4. ➿ Quickly build a first prototype on top of the API with students to get feedbacks (and give some bug bounties) so we could build a develper friendly API

👉 This post is all about this last this adventure with students.

🎯 The pitch

Essentially as a PO, what I wanted was to be able, from a web interface to

  • Pick any office
  • Be able to browse the historical data of the current day

... and this is what we got:

Image description

Image description

🍿 For impatients

💰 Benefits of historical wait time data

There are a lot of benefits and potential that come with wait time, both :

  • For the customer
  • For enterprise

🤗 Customer : trends benefits

Image description

Image description

🏢 Enterprise benefits and data-driven strategy

eg, from the service provider perspective, the main goal is to both:

  • 📉 Minimize customers wait time to smoother Customer Experience (which also relies on digitalization and self service)
  • 📈 Maximize service throughput : serve as much customers as possible with as less people a possible waiting in the office

So sharing live and historical wait time trends has a major impact and opens tremendous opportunities, see below some real life examples:

🔖 Resources

🧑‍🎓 More about University partnership

Top comments (6)

Collapse
 
adriens profile image
adriens

Collapse
 
adriens profile image
adriens

Collapse
 
adriens profile image
adriens

Collapse
 
adriens profile image
adriens

Collapse
 
adriens profile image
adriens

Collapse
 
adriens profile image
adriens