Inspiration Supply chain disruptions cost the global economy billions annually. Traditional dashboards are great at showing us the problem (Red Alerts!), but they stop there. We asked: "What if the dashboard could fix the problem itself?" We wanted to bridge the gap between Insight (Tableau) and Action (Salesforce).

What it does Sentinel Flow is a "Command Center" for supply chain managers.

Detects: It connects to the trailverse live database to calculate real-time Risk Scores for inventory across global warehouses. Visualizes: A high-impact map instant highlights Critical (Red) versus Stable (Blue) regions. Acts: The core innovation is the Sentinel Guardian Extension. When a manager selects high-risk items, the extension activates. With one click, it triggers a secure webhook to Salesforce Flow, re-routing inventory from healthy hubs to at-risk locations automatically. How we built it Tableau Cloud: The core visualization platform. Data Layer: Connected to Heroku PostgreSQL (trialverse) to fetch live Supply Chain inventory and sales data. Logic: Used complex LOD (Level of Detail) expressions in Tableau to calculate [Risk Score] and [Disruption Category]. Extensions API: Built a custom JavaScript/HTML5 extension hosted on GitHub Pages that listens for MarkSelectionChanged events and triggers external actions. Hosting: Used GitHub Pages to serve the secure extension to the Tableau Dashboard. Challenges we ran into Getting the Tableau Extensions API to reliably detect selection events across different worksheet types was tricky. We implemented a hybrid "Active Listening" approach in JavaScript to ensure the "Mitigate" button only activates when valid risk data is selected, with a failsafe mode for demonstration reliability.

Accomplishments that we're proud of We successfully built a System of Action. It's not just a chart; it's a tool that does work. We're also proud of the "Mission Control" aesthetic—making enterprise software feel like a sci-fi interface.

What's next for Sentinel Flow AI Agents: Integrating Tableau Agent to suggest which suppliers to switch to before we even click the button. Write-back: Updating the SQL database directly from the dashboard to flag orders for quality review.

Built With

Share this project:

Updates