I do think the Data Explorer plugin can do exactly what you want here, but it unfortunately requires some SQL know-how to set up the queries. Once you have the queries you want you can make them available to any group of users as you prefer.
https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516/279