Early in my time managing the Data team at Stripe, @jeffbalogh built a tool called Hubble with massive impact. Here’s what it did:
- there was a big textarea to type a SQL query into
- it showed results in a table
- it cached the results, and gave the query + results a permalink 75% of the value came from that. Sounds simple, but the simplicity was a huge part of it.
Another 15% came from the ability to toggle simple chart views instead of the table.
Most of the remaining 10% was that you could search through a log of everyone else’s queries. I’m mentioning this because most orgs could build this in a couple of days, but not many seem to have, and I think they should.
(Something that in theory does this and more, but is encumbered with a lot more complexity and clicks, doesn’t count).