Hey #datafam During the week I got my hands dirty with a new project, the project explored employee dataset. The challenge? Tackling a multi-faceted employee dataset scattered across four Excel workbooks. 📈💻
1
0
5
Replies
Here's a glimpse into what I've accomplished: 🔗 Consolidated all data into a single workbook with four worksheets. 🔍 Developed a robust data model, establishing relationships across the board.
1
0
1
📊 Conducted in-depth analyses: 1. Explored the intriguing correlation between "Training Duration(Days)" and "Training Cost" using a dynamic scatter plot. 2️⃣ Dug deep into performance metrics by creating a multi-level pivot table, breaking down "Performance Score"
1
0
0
3️⃣ Leveraged pivot tables to unveil the average "Engagement Score" per year. 4️⃣ Visualized the distribution of "Exit Year" for terminated employees with an insightful line chart. 5️⃣ Calculated the total training cost for employees in specific locations.
1
0
2
6️⃣ Delivered a powerful HR dashboard offering a comprehensive overview of key metrics — from headcount to performance and training costs.
0
0
1