Welcome to the HR Analytics Project repository for Atliq Technologies! In this project, we analyzed the attendance data of the last 3 months to provide insights to the HR Generalist. By leveraging data extraction, transformation, and loading techniques, we generated valuable insights using Power BI Desktop.
Problem Statement
Atliq Technologies' HR Generalist sought insights from the attendance data, collected in key format over the last 3 months. The objective was to gain insights into employee attendance patterns, determine retention strategies, and identify reasons behind sick leave percentages. Additionally, the analysis aimed to differentiate between Work From Home (WFH) and Work From Office (WFO) percentages.
Data Source
The attendance data was provided in the form of an Excel file. The data underwent Extract, Transform, and Load (ETL) operations to prepare it for analysis.
Steps Followed
- Understanding Problem:
- Defined the scope of the analysis, focusing on attendance patterns, retention strategies, and sick leave percentages.
- Data Gathering and Transformation:
- Collected the attendance data from the provided Excel file.
- Utilized ETL operations to clean and transform the data into a suitable format for analysis.
- Creating Metrics using DAX:
- Implemented Data Analysis Expressions (DAX) to create key metrics, including attendance percentages, sick leave percentages, WFH percentages, and more.
- Dashboarding with Power BI Desktop:
- Utilized Power BI Desktop to visualize the data and create interactive dashboards.
- Developed visualizations to provide insights into attendance trends, sick leave reasons, WFH vs. WFO percentages, and more.
How to Use the Dashboard
- Download Power BI Desktop: If you haven't already, download and install Power BI Desktop(https://www.microsoft.com/en-us/download/details.aspx?id=58494).
- Clone or Download this Repository: Clone this repository to your local machine using Git or download it as a ZIP file.
- Open the Power BI Project: Open the .pbix file using Power BI Desktop. This file contains the pre-configured dashboard and data connections.
- Explore the Dashboard: Once the data is loaded, explore the interactive dashboard. Navigate through the different visualizations, filters, and slicers to gain insights into attendance patterns and related metrics.
Project Outcome
The analysis presented in this dashboard will empower Atliq Technologies to make data-driven decisions regarding employee retention strategies. By understanding attendance patterns, reasons for sick leaves, and the balance between WFH and WFO percentages, the company can implement targeted actions to improve employee satisfaction and well-being.
Feel free to explore the dashboard and leverage the insights for HR planning and decision-making.
Acknowledgments
Special thanks to Codebasics team for the valuable tutorials and guidance during the development of this project. You can find the tutorials here(https://www.youtube.com/watch?v=ru1qeDO_qrc&list=PLeo1K3hjS3uuVQccZa7yFwK3ltoGQOWbM).