This repository contains the HR Data Analysis project . The analysis focuses on attendance data, providing insights into employee presence, work from home percentages, and sick leave percentages. The Power BI report named "HR Attendance Data Analysis" showcases various visualizations and metrics to facilitate a comprehensive understanding of the attendance patterns.
- Project Description
- How to Access the Power BI Report
- Key Visualizations and Metrics
- Usage
- Contributing
The HR Data Analysis project focuses on analyzing attendance data for employees in the given project. The Power BI report, named "HR Attendance Data Analysis," provides interactive visualizations and key metrics for better insights into employee attendance patterns.
-
Clone this repository to your local machine:
git clone https://github.com/hiteshchinu/HR-Attendance-Data-Analysis.git
-
Open the "HR data analytics.pbix" file using Power BI Desktop.
-
Explore the interactive report to gain insights into employee attendance data.
-
Attendance Table: Detailed information about employee attendance, including Employee Code, Name, Date, Attendance Value, WFH Count, Month, SL Count, and Day of the Week.
-
Slicer for Months: Allows users to filter data based on selected months.
-
Attendance Percentage: Calculated percentage of attendance based on working days.
-
WFH Percentage: Calculated percentage of Work From Home (WFH) days with respect to working days.
-
Sick Leave Percentage: Calculated percentage of Sick Leave (SL) days with respect to working days.
-
Graphs for Presence %, WFH %, Sick Leave % by Date: Visual representations of attendance trends over time.
Feel free to explore the Power BI report interactively. Utilize the slicer to analyze data for specific months and delve into key metrics and visualizations. If you have any questions or suggestions, please reach out.
Contributions are welcome! If you have improvements or additional insights to share, please open an issue or submit a pull request.