Build a Fishbowl Shipping Dashboard with AI (Ship Today, On-Time %, At-Risk Orders)
Build a Fishbowl shipping dashboard with AI — what has to ship today, your on-time percentage and at-risk orders, live from your database.
Read the full write-up, with the steps and screenshots →
Transcript
Auto-generated from the video. Timestamps jump to that moment in the clip.
- 0:06Hello and welcome! In this video we're going to be making a dashboard for the shipping team.
- 0:12Let's get started. So we've got a TV set up in the shipping department and we
- 0:17want to give them
- 0:18some information to kind of help them manage their time and process. Got a few
- 0:23notes here
- 0:24from the manager of what we want to put in front of them and we're going to try to build that.
- 0:28But first, we need to adopt this TV that I have here on the right over to the
- 0:33ILC MCP
- 0:34so that we can manage it using Claude here on the left.
- 0:39First things first, let's adopt it.
- 0:40So I'm going to tell it, ILC MCP, enable TV code VMSGY8.
- 0:48Name it shipping TV
- 0:54in.
- 0:56the, let's call it Hoboken,
- 1:01if I spell it right, Hoboken,
- 1:07New Jersey Location.
- 1:15Now the location is important to use because we have a little widget in there to add
- 1:20some
- 1:21weather.
- 1:22I thought that was nice.
- 1:23Let's create.
- 1:24our first prompt so let's make a page make a page for
- 1:30this TV or shipping
- 1:33dashboard first metric how
- 1:40many shipments went out today
- 1:54Okay, I don't want to preview it, I just want to publish it, perfect,
- 2:06so that'll load here
- 2:07in a second, amazing, we've
- 2:12got our little metric here, let's add another one, add another
- 2:17one, or what has she
- 2:20in the last last seven days
- 2:36okay awesome looks like that added now let's add another one let's add
- 2:41our on
- 2:42time performance add a gauge showing
- 2:50Showing our on -time rate, on -time shipping
- 2:56rate over the last seven days.
- 3:11Okay, maybe we should give it a target.
- 3:13Yes, add a target line.
- 3:16for 95%.
- 3:27Well, something for us to address later.
- 3:32Then let's add another thing.
- 3:34Let's add a pie chart for what carriers we
- 3:39shipped
- 3:40over the last seven days.
- 3:53Cool, now we've got a little pie chart, works.
- 3:57Now let's do something, add a table of shipments
- 4:03from today, like the ship num, order,
- 4:09ship
- 4:10to name.
- 4:12The carrier, cartons, count, and
- 4:17time shipped.
- 4:19Newest first.
- 4:31Perfect.
- 4:33And let's give it some feedback.
- 4:36Can we help the layout?
- 4:38There is a bit of...
- 4:40empty space maybe
- 4:46the on time shipping can be on the
- 4:51same row as the shipments
- 4:54out and shipped seven days and
- 4:59the carrier plus ship today table
- 5:05is on its
- 5:07own
- 5:09row below that okay
- 5:19that looks a lot better then take that much time to kind
- 5:23of correct and make things look the way that we want it to and I think we can
- 5:27ship this before I do let's tell the shipping team add
- 5:34a message to
- 5:38Reminder, don't forget the dry ice or
- 5:43cold items.
- 5:55Perfect. Now we've got a reminder there.
- 5:57We have the weather, we have our time, we have our metrics that we want to track.
- 6:02I think it looks good.
- 6:03This looks good.
- 6:04ship it. If this is something that you're interested in for your fishbowl, your business,
- 6:09give us a shout. Love to talk about some ideas you have or any other ideas you might
- 6:14want to
- 6:16explore within the fishbowl ecosystem. Happy to hear about it. Reach
- 6:21out. Thanks. Have a good one.
- 6:33Thank you.