We use Metabase (featured in the image) and for the most part non-tech people do it fact use it. What helped us implement it was having 'office hours' where I walked people through examples of how to use it "This is how to get sales at a specific location or in a state". While it hasn't solved every problem/query/export, a large portion of requests that went in the direction of engineering before no longer make it that far. Other reasons to love metabase, you can self host it and use your GSuite SSO.