Skip to content

A project focuses on generating insights for HR generalist based on attendance sheet of past three months.

Notifications You must be signed in to change notification settings

madhumitagupt/HR-Analytics-Dashboard-PowerBI

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

HR-Analytics Project- Atliq Technologies

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

  1. Understanding Problem:
  • Defined the scope of the analysis, focusing on attendance patterns, retention strategies, and sick leave percentages.
  1. 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.
  1. Creating Metrics using DAX:
  • Implemented Data Analysis Expressions (DAX) to create key metrics, including attendance percentages, sick leave percentages, WFH percentages, and more.
  1. 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

  1. 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).
  2. Clone or Download this Repository: Clone this repository to your local machine using Git or download it as a ZIP file.
  3. Open the Power BI Project: Open the .pbix file using Power BI Desktop. This file contains the pre-configured dashboard and data connections.
  4. 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).

About

A project focuses on generating insights for HR generalist based on attendance sheet of past three months.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published