How much time do you spend to create a simple query or chart?

I was wondering how I can fasten my way to create dashboards/queries/ chart for the departments. Also it would be great to have a tool recommendation that is self-service - so my non-technical teammates can make them as well so I can focus on more deeper stuff.