Font size
WorksheetsPower BI Post-Test (HR-Sales)
Total questions: 10
Worksheet time: 50mins
What is the TOTAL MONTHLY INCOME of all current employees, shown WITHOUT any display unit?
(a)
What is the AVERAGE Distance From Home for all current employees, accurate to 3 decimal places?
(a)
What is the oldest age of our EX-EMPLOYEES?
(a)
What is the AVERAGE age of our current employees?
(a)
Which JOB ROLE is having the highest ATTRITION RATE?
Human Resources
Laboratory Technician
Research Scientist
Sales Representative
What is the AGE GROUP having the highest number of FEMALE EX-EMPLOYEES?
Under 25
25 - 34
45 - 54
Over 55
Focusing on FEMALE EX-EMPLOYEES, which two surveys did most of them rated the lowest? [Rating 1 is the lowest]
Work Life Balance
Relationship Satisfaction
Job Satisfaction
Job Involvement
Environment Satisfaction
How many CURRENT EMPLOYEES have waited for 15 YEARS since last promotion?
(a)
Based on the satisfactions survey results, what is the main reason of happiness to majority of CURRENT EMPLOYEES? You need to add the count of Rating 3 and Rating 4 for each survey
Work Life Balance
Relationship Satisfaction
Job Satisfaction
Job Involvement
What is the AGE GROUP majority of CURRENT EMPLOYEES coming from?
Under 25
25 - 34
35 - 44
45- 54
