{"repo":"AmirhosseinHonardoust/Employee-Performance-Analytics","free":true,"listed":false,"github":"https://github.com/AmirhosseinHonardoust/Employee-Performance-Analytics","clone":"git clone https://github.com/AmirhosseinHonardoust/Employee-Performance-Analytics.git","description":"Analyze employee performance and productivity using SQL and Python. Build HR dashboards to evaluate departmental KPIs, efficiency trends, and workload balance. Generates actionable insights through data visualization and KPI aggregation for business decision-making.","language":"Python","stars":33,"topics":["analytics-pipeline","business-intelligence","data-analysis","data-storytelling","data-visualization","employee-performance","hr-analytics","kpi-dashboard","performance-metrics","portfolio-project"],"license":"MIT","category":"analytics","readme_excerpt":"Employee Performance Analytics (SQL + Python) Analyze employee performance and departmental productivity using SQL (SQLite) for KPI aggregation and Python for analytics and visualization. This project transforms HR data into actionable business insights , identifying high performers, efficiency trends, and departmental KPIs. --- Overview This project demonstrates how to: - Use SQL for feature engineering and KPI calculation - Use Python for data analysis and visualization - Deliver data-driven HR insights in an end-to-end workflow --- Objectives - Compute department-level performance indicators - Assess employee efficiency and attendance - Visualize relationships between workload, tasks, and ratings - Generate clean and ready-to-use summary reports --- Project Structure --- Dataset Description Column Description --------- ------------- employee id Unique employee identifier name Employee name department Department name (Engineering, Sales, etc.) role Role title date Record date (YYYY-MM-DD) tasks completed Number of tasks completed hours worked Hours worked on that day rating Daily performance rating (1–5) projects Active projects absences 1 if absent, else 0 The dataset ( employees.csv ) is synthetic, generated with realistic departmental trends and biases. --- SQL Logic: src/queries.sql The SQL script creates views and extracts three analytical datasets: 1. department kpis – Department-level KPIs: - Average rating - Tasks per department - Total hours - Absence rates 2. empl","default_branch":null,"files":null,"tree":[],"storefront":"/r/AmirhosseinHonardoust","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/AmirhosseinHonardoust/Employee-Performance-Analytics/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}