In this practical case study, we explore the analysis of real-world data provided by Atliq Technologies, a highly regarded software and data solution company. The dataset specifically examines employee working preferences and sick leave percentages, with the ultimate aim of optimizing office space utilization and promoting employee engagement through team-building activities.
Atliq Technologies is a software and data solution company with a strong reputation for technological expertise.
Dhaval (co-founder), Pinali (HR).
The dataset provided by the HR department offers valuable insights into employee working preferences and sick leave patterns.
For this project, we utilized advanced tools and technologies to analyze the HR data, including Excel for data preprocessing, Power BI for data visualization and creating measures/calculations using DAX (Data Analysis Expressions), and Power Query for data transformation.
Let's delve into these findings to extract meaningful conclusions.
-
Overall Presence: An impressive overall employee presence rate of approximately 91.83% demonstrates a strong commitment to in-office work. This reflects the dedication and professionalism of the workforce at Atliq Technologies.
-
Working from Home (WFH): Around 10% of employees prefer the flexibility of working from home. This insight underscores the importance of providing a work-from-home option to promote employee satisfaction and achieve a healthy work-life balance.
-
Sick Leave (SL) Percentage: The sick leave percentage stands at a commendable 1.10%, indicating a culture of strong attendance and minimal sick leave instances among employees.
-
Day of the Week and Presence Percentage: Analyzing presence percentages by day of the week reveals interesting patterns: Fridays show a slightly lower presence percentage of 90.19% compared to other weekdays. Mondays witness a high presence percentage of 93.21%, signaling a positive start to the workweek. Saturdays and Sundays have a 0.00% presence percentage, as weekends are non-working days. Thursdays and Wednesdays demonstrate presence percentages of 90.72% and 92.11% respectively, indicating consistent attendance mid-week. Tuesdays mirror Mondays, with a presence percentage of 93.03%.
Based on the data analysis, the following insights and recommendations can guide effective decision-making:
Leverage higher attendance rates on Mondays and Tuesdays to plan team-building exercises and essential meetings that require maximum employee presence. This approach optimizes office space utilization and fosters collaboration.
Utilize Fridays and Thursdays, which exhibit slightly lower attendance rates, to focus on office maintenance and organize activities that require fewer employees. This strategy ensures efficient space management without disrupting regular work.
Considering the 10% preference for remote work, implementing or strengthening a work-from-home policy can offer employees flexibility and contribute to overall satisfaction and work-life balance.
While the low sick leave percentage indicates good employee health, introducing wellness programs and initiatives can further nurture a healthy work environment, reduce sick leave instances, and promote employee well-being.
In conclusion, the insightful data analysis empowers Atliq Technologies to optimize office space utilization, foster employee engagement, and enhance work-life balance. By leveraging these findings, the company can make informed decisions regarding team activities, maintenance schedules, work-from-home policies, and wellness programs. These measures will ultimately lead to a more productive and satisfied workforce.
