7 min read
Discovery Chat

Danylo Borodchuk
Co-Founder, COO

Your analyst isn't slow — your architecture made every question a support ticket. Here's how self-serve fixes it.
You built your data team into a ticket queue
You need a number before tomorrow's board prep. You Slack your analyst. She's working through requests from product, finance, and sales — all equally urgent, all equally time-sensitive. Your question enters a queue. You wait.
Three days later, you get the answer. By then, you've already made the decision without it.
This isn't your analyst's fault. It's the architecture. You centralized analytics because that made sense at the start — one person, one source of truth, consistent definitions. Smart choice for a team of 15. But centralized means every question funnels through one team. And once a data team becomes a ticket queue, they stop doing analysis and start doing triage.
The data team bottleneck is one of the most predictable failure modes in early-stage companies. And the fix isn't more headcount.
How centralized teams become bottlenecks
At an early stage, centralization is the right call. You need one definition of "revenue." One way to calculate retention. One source of truth. A single analyst enforces that. They write the queries. They own the metrics. Decision-making is fast because there's one throat to choke.
This works fine until the company starts making more than a handful of decisions a week.
Finance needs ARR by segment. Product needs funnel drop-off data. Sales wants win rates by persona. Growth is investigating churn. Marketing is asking about attribution. Everyone's request is legitimate. Everyone's urgent. And there's one person with the keys to the warehouse.
The bottleneck isn't a work ethic problem. It's a throughput problem. One person can serve five requests a week with real analytical depth. Or they can serve twenty requests a week with surface-level dashboards. Most analysts end up doing the latter — churning out charts rather than producing insight — because the queue demands it.
The natural response is to hire analyst #2. And #3. But adding people to a centralized system doesn't fix the bottleneck. It redistributes it. Suddenly you have three people writing queries, and each one defines metrics slightly differently because the definitions live in their heads, not in a system. You've traded a slow organization for an inconsistent one.
There's a deeper problem too. In a centralized model, the people closest to the business decisions — founders, heads of growth, product leads — have the least direct access to data. The person who needs to move fastest is gated behind the person who needs to be most careful. That's a structural mismatch that hiring can't solve.
The hybrid trap
Some teams try to split the difference. A central analytics team owns the warehouse and the definitions. Embedded analysts sit inside product, finance, and sales to handle requests faster.
This reduces queue time — the embedded analyst answers faster because they're in the room. But it creates a new failure mode: definition drift.
The embedded analyst in product thinks "revenue" includes certain things the central team excludes. The embedded analyst in finance calculates retention differently from the one in sales. Six months in, every cross-team meeting becomes a reconciliation exercise. "When you say churn, do you mean logo churn or net revenue churn?" A question nobody should ever have to ask twice, let alone every Monday.
Hybrid works — but only with expensive infrastructure to keep definitions synchronized. A semantic layer. Shared metric definitions. Governance tooling. Most early-stage teams skip that investment and end up with organizational complexity masquerading as analytical maturity.
What the real fix looks like
The actual solution isn't more analysts or a fancier org chart. It's self-serve access to governed data.
"Self-serve" gets a bad reputation because most implementations are ungoverned. You give everyone Looker access and they build their own dashboards with their own definitions, creating the consistency problem you were trying to avoid. That's self-serve without guardrails. It's worse than centralized.
The version that works has two components. First, a semantic layer — a system that defines every metric once and enforces that definition across every query, dashboard, and alert. "Revenue" means the same thing whether the founder asks or the intern asks. "Retention" is calculated the same way in every context. The definitions live in a system, not in someone's head.
Second, a query interface that non-technical users can actually operate. Not SQL. Not a dashboard builder. A way to ask a question in plain language and get an answer that's governed by the semantic layer.
This is how we built discovery chat at Lopus. The founder asks: "What's our net retention by cohort this quarter?" Discovery chat translates that plain English into SQL, pulls from the semantic layer's definition of "net retention," and returns the answer. Fast. Accurate. Consistent with what everyone else in the company would see if they asked the same question.
No queue. No three-day wait. No reconciliation arguments on Monday morning.
What happens to your analysts
Self-serve doesn't eliminate analysts. It changes what they do — and the change is dramatic.
Instead of writing forty one-off queries a week, the analyst focuses on making the semantic layer correct. They define metrics rigorously. They validate definitions against the business logic. They audit the data flowing in. They do the actual analytical work that justifies their salary — investigating why churn spiked, identifying which segments are underperforming, building the models that predict behavior.
That's more strategic work. More interesting work. And it scales. One analyst with a well-maintained semantic layer can support a company of 150+ people. Two analysts without one will struggle to support 30.
The shift requires investment — in the semantic layer, in the query interface, in the governance process. It's not free. But the return is concrete: the founder who needs a number at 9 AM on Monday has it by 9:01, not by Wednesday. And it's the same number that finance, product, and sales would get if they asked the same question.
How to know if you're stuck
Two signals that your data team architecture has become the bottleneck:
Your analyst spends more than 50% of their time on recurring reports and ad hoc query requests — and less than 50% on actual analysis. They're a query engine, not a strategist.
You've made a decision in the last month where someone said "I couldn't get the data in time, so we went with our gut." That's not a data culture problem. That's an access problem. And it's solvable.
The ticket queue was the right first system. It's not the right second system. The sooner you make the shift, the sooner data starts moving at the speed of decisions instead of the speed of analyst availability.





