HR Data Analysis Project

Table of Contents

• Introduction
• Objective
• Data Source
• Tools Used
• Key Insights
• Repository Contents
• Example Queris

Introduction

Welcome to the HR Data Analysis project! This repository houses the documentation, SQL queries, and code for a comprehensive analysis of an HR dataset using MySQL. This project aims to provide valuable insights into various aspects of human resources, such as employee performance, attrition, and more.

Objective

The primary objective of this project is to perform data analysis on an HR dataset to help organizations gain a better understanding of their workforce and make data-driven decisions regarding employee management.

Data Source

The dataset used in this project consists of HR-related information, including employee details, performance metrics, and attrition data.

Tools Used

• MySQL: MySQL was the core tool used for data storage, querying, and analysis, allowing us to leverage the power of relational databases.
• SQL Queries: A series of SQL queries were designed to extract and manipulate data from the HR dataset.

Key Insights

The project has resulted in actionable insights regarding employee performance, factors influencing attrition, and other HR-related metrics. These findings are presented in the project documentation.

Repository Contents

• SQL Queries: This section contains SQL queries used for data extraction, transformation, and analysis.
• Documentation: The documentation provides a detailed explanation of the data analysis process and the insights gained from the project.
• Data: Raw and cleaned datasets, if applicable, are stored in this section.

Example queries

I have written SQL queries to find out information about employees.

1) Find the information of employees with their salary less than 50K.

2) Employees with their first name starting with the letter N.