Employee Presence Analysis

Background Case

HR manager faces challenges in managing and understanding employee attendance data in his company. Previously, this process involved manual processing of complex and large Excel files, causing complexity and high time consumption. HR manager aims to enhance efficiency and understanding by adopting a data dashboard to analyze employee attendance, work-from-home trends, and sick leave percentages.

Source Data

The primary data source is Excel file obtained from a dataset for employee attendance from a company named AtliQ. The data includes information on employee attendance, including attendance percentages, work-from-home habits, sick leave, and more.

Data Transformation

  • Extracting relevant fields such as employee names, presence, work-from-home, and sick leave information for focused analysis.
  • Integrating additional data points, including dates, days of the week, and specific employee details, to enhance the granularity of the dataset.
  • Add calculated fields for metrics such as attendance percentage (presence, work-from-home, and sick leave), enabling a deeper understanding of employee attendance dynamics.
  • Remove Week Off and etc to align the dataset with the calendar to accurately represent workdays and facilitate date-based analysis.

Menu Product

This menu focuses on sales analysis based on products. It contains three sub-menus:

  • Pareto Analysis: Utilizes the Pareto Principle to identify the products that contribute the most to total sales. This analysis helps determine which products are most important to focus on.
  • Correlation: Analyzes the correlation between various products and other factors influencing sales. This visualization helps understand the relationships between products and other variables.
  • Remove Week Off and etc to align the dataset with the calendar to accurately represent workdays and facilitate date-based analysis.

Dashboard

  • Importing Excel data into Power BI starts the visualization process.
  • Insights into presence, work-from-home, and sick leave patterns are delivered through visual cards and tables.
  • Create interactive line charts to represent presence, work-from-home and sick leave trends.
  • Bar charts are used to visually depict the percentage of presence, work-from-home, and sick leave by day.
  • Create a calculated month-over-month.
  • Create filter.

Automated Notifications and Updates

  • Implement a system to send email notifications if the presence falls below 80%
  • Set up automatic data updates, ensuring the dashboard reflects the latest information
  • Incorporate notifications to alert stakeholders of data updates

Insights

  • Observe a decreasing trend in presence leading up to June
  • Observe a increasing trend in work-from-home and sick leave leading up to June
  • Highlighting employee presence based on specific days of the week, with Monday having the highest presence
  • Highlighting employee work-from-home on specific days of the week, with Friday having the highest work-from-home
  • Highlighting employee sick leave based on specific days of the week, with Monday having the highest sick leave
  • Sending notifications via email if presence falls below 80%
  • Automatic data updates, including notifications

Recommendations

  • Recommend scheduling team activities on Mondays, a day with typically high employee attendance, to enhance collaboration.
  • Enhance work flexibility by adopting a hybrid work model. Consider designating Fridays as remote work days, providing employees the flexibility to work from home. Additionally, explore rotating work models to optimize office space utilization.
  • Utilize Fridays, characterized by lower attendance, for maintenance and infrastructure improvements without disrupting daily operations.