Embedded Files
Project Overview
This project analyzes employee attendance patterns, work-from-home preferences, and sick leave trends at Atliq Technologies. The goal of the analysis is to uncover insights that help optimize office space utilization, support flexible work policies, and improve overall workforce management.
Objective
The objective of this project was to analyze HR data to understand employee presence trends, remote work preferences, and sick leave patterns. These insights help HR teams make data-driven decisions that improve workplace efficiency and employee satisfaction.
Tools & Technologies
• Microsoft Excel – Data preprocessing
• Power BI – Dashboard visualization
• Power Query – Data transformation
• DAX – Measures and calculations
Skills Demonstrated
• HR Data Analysis
• Data Visualization
• Dashboard Development
• Data Transformation
• Business Insight Generation
Project Demonstration
An interactive Power BI dashboard was developed to visualize employee presence trends, work-from-home patterns, and sick leave percentages. Dashboard screenshots and project links are included to demonstrate the analysis.
Dataset
The dataset provided by the HR department of Atliq Technologies contains information about employee presence, work-from-home records, and sick leave percentages. The data was analyzed to identify attendance trends and workplace behavior patterns.
Key Insights
Employee Presence
Overall employee presence rate is 91.83%, indicating strong workplace attendance.
Work From Home (WFH)
Around 10% of employees prefer working remotely, highlighting the importance of flexible work policies.
Sick Leave Trends
Sick leave percentage is 1.10%, suggesting good employee health and low absenteeism.
Weekly Attendance Patterns
Monday: Highest presence rate (93.21%) showing strong start to the work week.
Tuesday: Similar high presence (93.03%).
Wednesday & Thursday: Stable attendance mid-week.
Friday: Slightly lower presence (90.19%).
Business Insights & Recommendations
Schedule important meetings and team activities on Mondays and Tuesdays when employee presence is highest.
Utilize Fridays for maintenance or flexible work schedules due to slightly lower attendance.
Implement or strengthen work-from-home policies to support employee flexibility.
Introduce employee wellness programs to maintain low absenteeism and improve workplace well-being.
Outcome
The analysis provided valuable insights into workforce behavior and attendance trends. These findings help organizations optimize office space utilization, plan team collaboration activities effectively, and implement flexible workplace strategies that enhance employee productivity and satisfaction.
Google Sites
Report abuse