# Build a Fishbowl Sales Dashboard with AI (Live Orders, Backorders & Top Customers)

> Watch a Fishbowl sales dashboard get built live by asking ILC MCP — live orders, backorders and top customers on one screen, no manual report building.

[Watch the video](https://customer-w58k7541hezxj5p9.cloudflarestream.com/d57f9c461a40829c8b406ec2d66a9f1f/iframe)

Sales wants one answer first thing in the morning: what's on the board today, and what's stuck. In Fishbowl that usually means exporting Sales Orders to Excel and rebuilding the same pivot every day.

In this video I don't build a report. I ask [ILC MCP](/fishbowl-mcp) for the Sales Floor 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 Sales Floor Dashboard puts the sales questions on one screen:

- Live and open orders by status
- Backorders and what's holding them
- Top customers by open value
- Revenue booked this week against last

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](/blog/write-fishbowl-reports-with-ai).

---

*From Israel Lopez Consulting (ILC). Custom Fishbowl Inventory integrations and software, and Fishbowl experts since 2015. Written by Israel Lopez, published October 31, 2026. Questions about this topic, or want to reach the people who wrote it? Visit https://israellopezconsulting.com/contact*