Performance Trend Analysis by using MySQL

Project Overview:
This project focused on identifying underperforming field force employees by analyzing their sales efficiency using Gross Profit (GP) leverage. GP leverage is defined as the ratio of gross profit generated to promotional expenses incurred by individual sales personnel. The objective was not only to detect low performers but also to diagnose underlying performance bottlenecks through targeted interviews.

Data & Methodology:
The analysis was conducted using a panel dataset titled “consolidated_gp”, which contained monthly data (July–December 2022) for each field force employee, including unique ID, region, sales, gross profit (GP), promotional expenses, and calculated GP leverage.

Using MySQL, the dataset was explored, cleaned, and structured. Date formats were standardized using built-in functions, and SQL queries were employed to filter and extract relevant subsets of data.

To identify underperformers, field force employees were ranked based on GP leverage for December 2022. The bottom 300 employees with the lowest GP leverage were selected as the primary focus group. The maximum GP leverage within this group was used as a benchmark threshold for further filtering.

A longitudinal analysis was then conducted on these 300 employees across the six-month period (July–December 2022). Quarterly segmentation was applied to compute the average GP leverage for Q3 (July–September) and Q4 (October–December) 2022 for each individual.

To enhance interpretability, a performance classification framework was developed and implemented directly in MySQL using conditional logic. Employees were categorized as follows based on their average GP leverage: Poor: 0–1; Needs Improvement: 1–3; Meets Requirement: 3–4; Exceeds Requirement: 4–6; Excellent: ≥6
This classification enabled comparative analysis of performance trends between Q3 and Q4. Particular attention was given to employees whose performance declined significantly (e.g., from “Meets Requirement” in Q3 to “Poor” in Q4), indicating potential operational or capability gaps.

Key Insights & Outcome:
The analysis revealed a subset of employees with noticeable performance deterioration over time. These individuals were shortlisted for further investigation through structured phone interviews.

The qualitative insights gathered from these interviews highlighted several root causes of underperformance, including: 1. Inadequate product knowledge and training; 2. Weak engagement and communication with target customers; 3. Misalignment between assigned sales targets and market conditions.

These findings were consolidated and presented to management, along with actionable recommendations. The project contributed to informed decision-making by enabling targeted interventions such as training programs, performance recalibration, and improved field force management strategies.