Tools and scripts for analyzing HR data using Excel and Power BI.
Welcome to the HR Data Analyst project! This repository contains Excel workbooks and Power BI reports for analyzing HR data to gain insights into workforce dynamics, employee attrition, and other key HR metrics. The goal is to use data-driven techniques to improve HR decision-making and strategic planning.
HR-Data-Analyst aims to:
- Analyze employee data to identify trends and patterns.
- Develop dashboards for visualizing HR metrics.
- Segment employees based on various attributes.
- Create interactive reports for strategic HR insights.
- Data Cleaning: Excel workbooks with macros and formulas for cleaning and preprocessing raw HR data.
- Exploratory Data Analysis (EDA): Excel and Power BI files for visualizing and understanding data distributions.
- Employee Segmentation: Techniques for segmenting employees into meaningful groups.
- Interactive Dashboards: Dashboards built with Power BI for interactive data exploration.
This project utilizes various datasets, including:
- Employee demographic data
- Job role and performance data
- Survey responses
- Compensation and benefits data
- Microsoft Excel
- Microsoft Power BI Desktop
git clone https://github.com/yourusername/HR-Data-Analyst.git
cd HR-Data-Analyst