Power BI Post-Test (HR-Sales)

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