In-house BI rebuild · 9 months live
I rebuilt the BI function so the company answers its own data questions.
Before
About 20 data questions reaching BI each week.
Stakeholders waited for BI to answer data questions.
The team had planned an additional hire.
Now
1 or 2 data questions reaching BI each week.
10+ people outside BI now get their own answers from agents.
No additional hire was needed.
What keeps it reliable
Written rules: a constitution, a fixed structure, and defined workflows. My teammate works through the same system every day.
How the Team Brain works.
Agents answer questions and run checks using the shared knowledge base the BI team maintains.
Data sources, Amplitude, Refiner, HubSpot, Stripe, Segment and BigQuery, connect to Hex. The knowledge base in git, 405 verified entries, is compiled into the Hex agent context of 106 guides, and stakeholders ask Hex agents in plain language. Each week, gaps found in agent chats are checked, approved, and added back to the knowledge base. 33 agent workflows, 11 on a schedule, run on the knowledge base and catch breaking changes and tracking drift.