Video

Build a Fishbowl Purchasing Dashboard with AI (Open & Late POs, Top Vendors)

October 31, 20264:56
The Purchasing Pulse Dashboard, built live in one chat with ILC MCP.

A Fishbowl purchasing dashboard built live with AI: open and late POs and your top vendors, straight from your live 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 our purchasing department.
  2. 0:13So I've got my display, and on the left here I've got Claude, and on the right here I have my
  3. 0:18quote -unquote TV.
  4. 0:20And the purchasing department needs a dashboard for them to use inside their office, and we're
  5. 0:25going to do that for them.
  6. 0:27The first step is we need to...
  7. 0:28to adopt this TV into the platform and we've got a code here so I'm going to
  8. 0:32instruct the MCP to do that. Adopt enable
  9. 0:38TV code 2BUYAX.
  10. 0:52Let's call this purchasing.
  11. 0:57pit TV and and no
  12. 1:02pages right now
  13. 1:09okay so this one is what's interesting about this TV is that this this
  14. 1:14team is
  15. 1:14in Los Angeles so set the location to Los Angeles
  16. 1:19California
  17. 1:31We'll see some weather here in a second when we have our first metric to show.
  18. 1:35First thing, let's take a look at how many open POs we have.
  19. 1:38Make a metric for how many purchasers
  20. 1:44we have open right now.
  21. 1:53Okay, perfect, we've got our weather, we've got our open purchase orders, let's keep going.
  22. 2:00I need a metric for how many POs,
  23. 2:05open POs, are past their due date.
  24. 2:11Let's see what that gives us.
  25. 2:19Okay, look.
  26. 2:20like we've got 40 open purchase orders and 36 of them are past due okay let's
  27. 2:26let's take a look at how many POs did we issue
  28. 2:31today
  29. 2:39oh okay so see it answered me I should tell it that I want to add it as
  30. 2:45a metric
  31. 2:46to the T the dashboard to the page
  32. 2:57okay so we've got six that's good now let's
  33. 3:03add a chart of vendors add a bar
  34. 3:08chart of top my open
  35. 3:13PO dollars
  36. 3:21Okay, amazing, that looks pretty good, let's continue.
  37. 3:25Now add a small table listing the oldest
  38. 3:31past due POs, PO number, vendor,
  39. 3:37due date, oldest
  40. 3:46amazing we've got that little table there great and one thing
  41. 3:51you know and sometimes you know
  42. 3:53there might be a message that we need to put in front of the purchasing team to remind them
  43. 3:58something they see every day we could say a and b distribution
  44. 4:04closing for one month starting
  45. 4:08december 15th
  46. 4:12you know, and that could be a message that's just displayed on TVs or all TVs.
  47. 4:17But it could be something that is just part of the conversation that they'd be having
  48. 4:21inside a company and you want to remind some other people and, you know, we
  49. 4:26can do things
  50. 4:26like this. If this is something that you're interested in your fishbowl and want something
  51. 4:31for your team, give us a shout. Love to show you how we can get this in front of your team
  52. 4:36and we'll talk to you soon. Thanks. Bye.
  53. 4:40Thank you.