I've spent so much of my career as a data gopher, so I really appreciate this. It always works much, much better when people have direct access to data... but success always relied on getting business users to be a bit more technical.
I built a version of this in my org as a slack bot. It has access to BigQuery and I worked with it to document and define the key tables, so when a user asks a question it has a "library" to figure out how to answer it. Then it will respond directly in Slack (plus respond to f/up questions in the thread) and if it's a bigger/more detailed question it can create the report in Metabase and send a link.
One thing I don't have is the governance aspect, so I may give this a spin to see if this is a good middle layer.
I built a version of this in my org as a slack bot. It has access to BigQuery and I worked with it to document and define the key tables, so when a user asks a question it has a "library" to figure out how to answer it. Then it will respond directly in Slack (plus respond to f/up questions in the thread) and if it's a bigger/more detailed question it can create the report in Metabase and send a link.
One thing I don't have is the governance aspect, so I may give this a spin to see if this is a good middle layer.