cancel
Showing results for 
Search instead for 
Did you mean: 

Dashboards for HR

Former Member
0 Kudos

Good Day

I have a request to build a dashboard for HR that will show performance appraisals (KPIs) for departments, managers and employees. Requirements are that when a user selects the department they should be able to view managers KPIs then when they select managers they should be able to view their reporting lines KPI.

I was thinking of doing individual dashboards for each then put them on top of each other and use dynamic visibility to trigger which chart should be displayed. I have been doing research on the possibility of this and found that performance might be affected as there are about 18 departments, with about 30 managers each. I am now stuck, please advise a newbie on how i can do this report or if there is a way to overcome this performance issue, and by the way I am using Bex queries but will later move to universes.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182541
Active Contributor
0 Kudos

I have created a similar dashboard based on your requirement. Its very simple as its create a 3 query's.

1. Department with "Year" as Prompt

2. Managers with "Year & Department" as Prompt

3. Employees with "Year, Department & Managers" as Prompt.

Now call all these query's to the dashboard and pass the selection values from each and every chart to the below chart.

Ex: column chart for department, by selecting any values from the department pass the values to the managers so that it changes dynamically, by selecting managers it should bring employees underneth it.

Hope this helps!!!

For your Reference I am attaching the screenshots of the dashboard what i have designed.

Former Member
0 Kudos

Hi Thangadurai,

Thank you for your feedback, i am trying to implement something similar to yours but am stuck at how to structure my data in the spreadsheet,

former_member182541
Active Contributor
0 Kudos

What is your source ? Raw Excel data or any DB ?

Former Member
0 Kudos

my source is Bex query mapped to excel

former_member182541
Active Contributor
0 Kudos

Mine is also the same, use the BEx Query and create the dashboard using Query browser connection. Kindly let me know where you are stuck up ?