HR Analysis (A Full Data Analysis Project)

Table of Contents

• Introduction
• Project Steps
  • 1. Data Collection
  • 2. Data Cleaning by SQL
    • SQL Queries
  • 3. Connecting Tableau to PostgreSQL as a data source
  • 4. Visualize the Data by Tableau
    • Dashboards as PDF
    • Download Tableau Workbook

Introduction

In this project, I preprocessed an HR dataset and created three insightful Tableau dashboards to visualize the data. The objective was to clean and transform the raw data to make it suitable for analysis, and then present key insights in an interactive and user-friendly dashboard.

---

Project Steps

1. Data Collection :

The dataset was sourced from HR Dataset Kaggle.

ALL FEATURES
Employee_Name	EmpID	MarriedID	MaritalStatusID
GenderID	EmpStatusID	DeptID	PerfScoreID
FromDiversityJobFairID	Salary	Termd	PositionID
Position	State	Zip	DOB
Sex	MaritalDesc	CitizenDesc	HispanicLatino
RaceDesc	DateofHire	DateofTermination	TermReason
EmploymentStatus	Department	ManagerName	ManagerID
RecruitmentSource	PerformanceScore	EngagementSurvey	EmpSatisfaction
SpecialProjectsCount	LastPerformanceReview_Date	DaysLateLast30	Absences

2. Data Cleaning by SQL :

Data cleaning was performed to ensure the dataset was free from errors and inconsistencies.
The following steps were taken:

• Remove Duplicates
• Standardizing data
• Convert data types
• Check Missing/NULL Values

Overview of the SQL Database (PostgreSQL)

Download SQL queries: ../Data-Cleaning-SQL-Queries.sql

3. Connecting Tableau to PostgreSQL as a data source

4. Visualize the Data by Tableau

• Final Tableau Dashboards

Download as PDF: ../People-Analytics-Dashboard.pdf

• Download and Open the Tableau Workbook file on your own Tableau: ../HR-Data-Analysis-Tableau-Workbook.twbx