Loading repository data…
OmarRagab7 / repository
HR_project_-DEPI-
I'm excited to share our latest HR Analytics project, developed as part of our graduation project in DEPI – Digital Egypt Pioneers Initiative. In this project, we utilized Tableau, Jupyter Notebook, Power Query, and SQL to analyze and visualize HR data interactively.
#data#dataanalytics#datacleaning#datamodelling#datavisualisation#jupyter-notebook
Live repository statistics
★ 0Stars
⑂ 0Forks
◯ 0Open issues
◉ 0Watchers
31/100
OPENREPOHUB HEALTH SIGNAL
Limited signals
A transparent discovery signal based on current public GitHub metadata.
Recent activity35% weight
10
Community adoption25% weight
0
Maintenance state20% weight
100
License clarity10% weight
0
Project information10% weight
75
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
README preview
💡 About the Project
This project was developed as part of the Digital Egypt Pioneers Initiative (DEPI) under the supervision of industry experts. It focuses on analyzing HR data using Python (Jupyter Notebook), SQL Server, Excel, and Tableau, along with other essential data analytics tools.
🚀 Tech Stack
This project harnesses powerful tools for seamless data processing, analysis, and visualization:
- 🐍 Python (Pandas, NumPy, Matplotlib, Seaborn) - Data manipulation & insightful trend visualization.
- 🗄️ SQL Server - Fast & efficient data extraction, transformation, and complex querying.
- 📊 Excel (Power Query & Pivot Tables) - Smart data cleaning, transformation, and dynamic analysis.
- 📈 Tableau - Interactive dashboards, real-time insights, and visually compelling analytics.
📊 HR Analytics Dashboard
🖥️ Visual Representation:
📌 The dashboards below provide an interactive overview of these key HR metrics:
)
🔹 Key Insights from the Dashboard
- 👥 Total Hired: 2,458 | 📉 Turnover: 12.9% | 💰 Avg. Training Cost: $558.6
- 📊 Gender Headcount: Male: 44% ($65,444) | Female: 56% ($64,793)
- 😊 Employee Satisfaction: Highest: 369 (Female) | Lowest: 243 (Male)
- 📈 Performance by Age: Most employees fully meet expectations; few need improvement (PIP)
- 🏢 Highest Turnover Departments: Sales, Production, Software Engineering
- Includes voluntary, involuntary, resignation, & retirement
🎥 Explore More About the Dashboard
🔹 Watch the interactive dashboard video: Here