This repository contains the source code and data for an HR Analytics Dashboard developed using Power BI, Power Query, and DAX. The dashboard provides a comprehensive analysis of employee attendance patterns, work-from-home trends, and leave utilization based on three months of real-world data. By employing advanced analytics techniques, the dashboard offers valuable insights to support evidence-based HR strategies and decision-making processes.
- Attendance Analysis: Evaluate presenteeism rates, absenteeism rates, and work-from-home percentages to gauge employee engagement levels.
- Leave Utilization: Analyze different types of leaves taken by employees, identifying patterns and trends.
- Trend Analysis: Conduct in-depth trend analyses to recognize recurring patterns and proactively manage workforce challenges.
- Data Visualization: Utilize interactive charts, graphs, and tables to present complex data in an easily understandable format.
- Data Cleansing and Transformation: Implement Power Query for data cleansing and transformation, ensuring accurate and reliable analysis.
- Complex Calculations: Utilize DAX for implementing complex calculations and measures, facilitating detailed trend analysis.
- Power BI
- Power Query
- DAX
- Clone the repository:
git clone https://github.com/uuvedant4/hr-analytics.git
- Open the project in Power BI.
- Load the provided dataset into the Power BI model.
- Run the analysis and explore the insights gained from the HR analytics dashboard.
Contributions are welcome! Feel free to open issues or submit pull requests to help improve this HR analytics dashboard. Please follow the contribution guidelines when contributing to this project.
This project is licensed under the MIT License.