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

API Trace View

How I Cut 22.3 Seconds Off an API Call with Sentry 🕒

Struggling with slow API calls? Dan Mindru walks through how he used Sentry's new Trace View feature to shave off 22.3 seconds from an API call.

Get a practical walkthrough of how to identify bottlenecks, split tasks into multiple parallel tasks, identify slow AI model calls, and more.

Read more →

Top comments (3)

Collapse
 
adriens profile image
adriens

Collapse
 
adriens profile image
adriens

Collapse
 
adriens profile image
adriens

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay