Video

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

October 31, 20266:41
The Ship Today Dashboard, built live in one chat with ILC MCP.

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.

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