CREATING DASHBOARD FOR CLOCKSTER
Working as a data analyst team for the HR department in a medical company. The data provided by the HR department includes 10–15 parameters per day per year (arrival/departure time, vacations, sick days, time off, etc.) on 1000+ employees of the company
- Determine which divisional workers are the most and the least disciplined (data cleansing using SQL and Excel)
- Utilizing Power BI, create a representation of the weeks and months where the majority of employees were missing or late (either for sick leave or vacation)
- Find metrics for data manipulation and analysis to answer each business objective
- Provide insights & suggestions for improvements in based on the information gained. Which heads of departments tend to forgive employees for lack of discipline? Are there any favorites for any heads of departments (perhaps some employees are always forgiven for being late, given time off, etc.)?