People that run businesses and care about data don't want dashboards, they want spreadsheets. Lately I've been having some success with creating "user friendly" data views in big query and giving out access to them with connected Google sheets. If anyone wants to make a nice graph, pivot table or add their formulas to the workbooks they're free to do so using a tool they're already familiar with. The the data is backed by the database and can update on its own so we're not constantly sending out new versions of exported files.