We use Qlik as powerBI which is alot faster than using grafana.. It loads the relevant data from queries to its own specific format which is then held in ram.. pretty much like redis works, so whenever you load new data, you reload the "apps" so they have the latest data in memory and when you do filtering and complex calculations it is really fast..