Employee Data Analysis

Solution

To explain the distribution of each variable to Lakshmi Devi, the COO, I would choose simple, clear chart types:

• (a) Department (Nominal Categorical Data)
  • Appropriate Chart: Bar Chart.
  • Explanation: "Lakshmi Devi garu, for 'Department', we will use a Bar Chart. The height of each bar shows the number of employees in that department. This gives a quick, straightforward view of our team sizes across Krishna Tech Solutions."

• (b) Years of Experience (Continuous Numerical Data)
  • Appropriate Chart: Histogram.
  • Explanation: "For 'Years of Experience,' a Histogram is best. It groups experience into ranges (e.g., 0-2 years, 2-5 years) and shows how many employees fall into each group. This helps us see if we have a young workforce, an experienced one, or a good mix."

• (c) Performance Rating (Ordinal Categorical Data)
  • Appropriate Chart: Bar Chart.
  • Explanation: "For 'Performance Rating,' we again use a Bar Chart. We'll order the bars logically from 'Needs Improvement' to 'Exceeds Expectations' so you can easily see the overall performance distribution, which is useful for planning."

Solution

To explore the relationship between Department and Performance Rating for Prasad Varma, I would recommend a 100% Stacked Bar Chart. This chart is excellent for comparing the proportional mix of performance ratings across departments of different sizes.

Why it's effective for Prasad Varma:

• Focus on Proportions: This chart excels at showing the relative performance mix, regardless of department size. It clearly shows that Data Analytics has the highest *proportion* of top performers, even though the Software team has more top performers in absolute numbers.
• Normalized Comparison: It provides a fair comparison of the performance culture, which is crucial for identifying areas of excellence or those needing support.
• Detailed View: The clear segmentation provides the detailed, comparative view that a BITS Pilani graduate like Prasad Varma would appreciate for strategic decision-making.

For a comprehensive view, I would supplement this with a Grouped Bar Chart showing absolute counts, as the number of employees is directly relevant for budgeting Ugadi bonuses.

Solution

To help Ravi Kumar understand the relationship between Years of Experience and Performance Rating, I would suggest using Grouped Box Plots. This visualization clearly shows the distribution of experience for each performance category.

Interpreting the Findings for Ravi Kumar:

This box plot shows a clear positive trend: as performance ratings improve, the median years of experience also increases. This is a valuable insight for the L&D head.

• Positive Correlation: The chart shows that employees in the 'Exceeds Expectations' category generally have more experience (median of 8 years) than those in 'Meets' (median of 5 years) and 'Needs Improvement' (median of 2 years). This suggests that experience is a significant factor in high performance at Krishna Tech Solutions.
• Implications for Training:
  • For New Hires: The data confirms that less-experienced staff are more likely to be in the lower performance brackets. Ravi Kumar could design accelerated learning paths, mentorship programs pairing them with senior staff, and foundational skill-building workshops.
  • For Experienced Staff: The wide range of experience in the 'Meets Expectations' category (from 2 to 18 years) is interesting. It could indicate that some long-tenured employees might be stagnating. This would justify upskilling or reskilling programs to help them adapt to new technologies or roles, leveraging Ravi's experience from Bengaluru.
  • For High Performers: The 'Exceeds Expectations' group has a mix of experience levels. L&D can identify what makes these individuals successful and create programs to replicate those competencies across the company.