This pharmaceautical company needed to understand their sales performance and customer behavior to identify high value-segments and improve revenue.
I analyzed their data, built dashboards using powerbi and identified top regions and customer segments revealing a high profit margin of 81%.
Based on these findings, I recommended reinvesting findings into targeted marketing and high performing products, which could potentially increase revenue, expand market share and drive overall growth by 15-25%
I Analyzed employee performance, salary, and turnover data to uncover a clear misalignment.Top performers were not consistently rewarded, while turnover remained high in critical areas, risking morale and productivity.
I Delivered SQL-driven insights and recommended a performance-based pay structure alongside targeted retention strategies.
Impact:
Following the implementation of these recommendations, this company reduced high-performer turnover by 25–30%, improved retention in key teams by about 20%, increased overall performance by 10–15%, and optimized salary allocation, cutting inefficient spend by 8–12%.