Executive dashboard- simple KPIs from a large database
I want to create an executive high-level dashboard for top management reporting some simple KPIs.
The database is pretty big and tables are huge, but they only need to see some simple numbers like count of transactions or sum of some values.
So I don't need to fetch all the data, I was wondering if I still need to first load the data into qlik sense and then do the calculation or if there's any way to have the calculation in the database and only bring the numbers.
What do you suggest?
1- Creating a stored procedure in DB and make the report in there and bring that into qlik sense for visualization?
2- Bringing the necessary field into qlik and calculate everything in qlik side?