Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have a requirement to create an executive dashboard taking in KPIs from 15 different dashboards.
The Background:
> There are around 40 KPIs in 15 different dashboards
> There are many users who have access to some or all the dashboards
> If they want to look at say 5 different KPIs, they will have to open say 3 to 5 dashboards
> So the need is to create an executive dashboard of shorts, which will have all the KPIs in once place
> The users will now have to open just one dashboard, to know about everything at a high level
The Requirement:
> One dashboard that shows all the KPIs in one place
> If the user wants to do further analysis, should be able to click on the KPI and navigate to the relevant detailed dashboard
> Not all users have rights to see all 40 KPIs, so a section access mechanism needs to be there so that users see only the KPIs they are authorized to
Tools at Our Disposal:
> Qlik Sense Enterprise on Windows (where all the 15 dashboards are hosted currently)
> Qlik Cloud (no apps as of now, we are just starting our Qlik Cloud journey)
> Qlik NPrinting
Appreciate if anyone could guide us on how to proceed to address this requirement.
Regards,
Bhaskar
there will be multiple solutions for this. one i can thik of is for each dashboard to compute for the KPIs in the load script and write it t a QVD file. you will then have 15 QVD files with your 40 KPIs spread among them. your EIS dashboard will then read all these 15 QVDs one advantage of this approach is that your numbers will always align. but the assumption is that your KPI can be computed a load time.
another sophisticated albeit more complicated solution is to create a mashup that reads the objects in your 15 dashboards - specifically the KPIs and present it in one page (or more)
the 1st one is of course simpler