Staple Chat is an AI data-analysis tool I designed: ask a question in plain language, get an answer straight from your connected data. What follows is how we identified the problem, designed our way to this product, and turned it into one of the company's biggest selling points.
The bottleneck was never the data. It was translation.
The obvious brief was "build a better dashboard." Twenty-three interviews with finance, ops, and compliance killed it.
One line from our CEO: "we should be able to chat with documents." Turning it into a product was mine. I scoped v1 with the CEO and PM:
The safe version was a chatbot bolted onto the dashboards, an assistant in the corner of the maze. We rejected it early.
"Excluding returns and taxes" carries real business logic. The system should translate intent, not make users do it. But a translation you can't see is just a black box, and finance won't sign off on numbers they can't audit.
Every tool we studied put visualization somewhere else: a tab, a builder, an export. But the point is the follow-up. "Now break that down by outlet" only feels natural if you never left the thread.
Power users needed their own data on the table: invoices, POS exports, P&L, outlet masters, ready to be questioned. The lazy version is a setup wizard; the clever-looking version sprays settings through the chat. We did neither.
A chat interface has a dirty secret: an empty input box is scarier than a bad dashboard. New users don't know what to ask, so they ask nothing and leave.
Every dataset lives in its own space: invoices in one, reviews in another. You land on the workspace you've built, and adding more is one click away.
Add opens a picker of files and tables: everything a new space should see, chosen before the first question is asked.
Sources land in the Data panel. Nothing has been asked yet, but the conversation can start.
The real question, typed the way you'd say it out loud, with no syntax or field names. It answers with a reasoning drawer, the prose, and a table where every figure traces back to its rows.
A follow-up becomes a real message, answered by a chart that renders inline. You never leave the conversation.
Custom business rules, like "treat anything below three stars as negative," quietly applied to every answer.
Time-to-insight went from 15 minutes to 2, not because people got faster, but because the tour of five dashboards stopped existing.
Chat removes the dashboard, but you're still typing. The next step I designed was voice.
Nobody wanteda better dashboard.