9 karma · joined February 14, 2022
These things happen all the time. And yet most companies out there think that the solution is to just build a bunch of dashboards, foreseeing what everyone will ask in the future. And then nobody checks the dashboards. Or finds the right one. And then they have a team of SQL translators pulling data for ad-hoc questions. That's silly IMO.
I'm obviously biased as a founder of a self-service analytics company based on AI (https://www.veezoo.com). But this is just my 2 cents on a topic I really care about.
From my experience building Veezoo[1], natural language interfaces for data can be very powerful for business users as long as it explains back understandably what the query does, allows to modify them by clicking and it relies on a set of vetted dimensions/measures, e.g. in a semantic layer. Also, UX solutions[2] like Autocompletion (for discovery and disambiguation) are way more important for these more specific use cases of natural language interfaces than for an open-domain chatbot like ChatGPT. This usually helps a lot with the issues you've mentioned.
There are many questions that are hard to write a query for but are simple to formulate in a relatively precise way (or allow the user to correct it by clicking). This is especially useful for the average business user that doesnt know SQL or struggles with "precise" tools for data analytics.
Disclaimer: I'm one of the co-founders of Veezoo.