top of page

Performance Trend Analysis by using MySQL

Purpose: To analyze the performance of 300 underperforming employees during Q1 and Q2, using panel data.
Workings: Gathering monthly profit data for each field employee, identifying underperformers for the current month using a specific criterion, calculating the quarterly average profit for each underperformer using monthly panel data, categorizing employees as poor or excellent performers for each quarter, comparing quarterly performance for each employee, and selecting only those who improved in the preceding quarter but performed worse in the subsequent quarter. 
Accomplishment: Successfully identified poor performers and suggested areas for improvement.

bottom of page