/HR-Data-analyst-Reports

Hr Data analyst

HR-Data-Analyst

Tools and scripts for analyzing HR data using Excel and Power BI.

Table of Contents

  1. Introduction
  2. Project Overview
  3. Features
  4. Data Sources
  5. Installation
  6. Usage
  7. Contributing
  8. License
  9. Contact

Introduction

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.

Project Overview

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.

Features

  • 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.

Data Sources

This project utilizes various datasets, including:

  • Employee demographic data
  • Job role and performance data
  • Survey responses
  • Compensation and benefits data

Installation

Prerequisites

  • Microsoft Excel
  • Microsoft Power BI Desktop

Clone the Repository

git clone https://github.com/yourusername/HR-Data-Analyst.git
cd HR-Data-Analyst