Blog

Build a Fishbowl Shipping Dashboard with AI (Ship Today, On-Time %, At-Risk Orders)

Israel LopezOctober 31, 20263 min
The Ship Today Dashboard, built live in one chat with ILC MCP.

Everything upstream exists to make the truck. The shipping desk needs a single view of what has to leave today and what’s at risk of missing the cutoff.

In this video I don’t build a report. I ask ILC MCP for the Ship Today Dashboard and it builds it live, against a Fishbowl database, writing the queries itself. No Jasper editor, no paid reporting add-on, no ticket to a consultant.

That’s the point of the dual approach: Fishbowl’s built-in reporting is rigid, and anything custom usually means iReport/Jasper or a third-party tool. Here the AI reads the live data through the MCP and lays the numbers out for you.

The Ship Today Dashboard puts the shipping questions on one screen:

  • Orders that must ship today
  • On-time ship percentage
  • At-risk orders near the cutoff
  • Open shipments by carrier

The demo runs on representative sample data, so nothing here is a real customer’s numbers — but it’s the same build you’d run against your own Fishbowl.

More on building live against Fishbowl this way: How to write 4 reports with AI in Fishbowl.