Grocery Sales &
HR Performance Analytics

Project Overview

A multi-dimensional business analytics project combining retail sales data, employee performance metrics, and HR analysis into a unified reporting system — giving management a 360° view of business performance.

Built a Flask dashboard app alongside Jupyter notebooks to interactively explore the data and present findings to stakeholders.

Datasets Analysed

• 2000+ retail transactions — product sales, category performance, revenue trends
• Employee master data — roles, departments, tenure, compensation
• 6-month performance data — targets, achievement rates, productivity scores

Sales Analysis Findings

• Top 10 revenue-generating products and their seasonal patterns
• Category-level performance — which product lines drive profitability
• Peak sales hours and days for inventory planning
• Monthly revenue trends with growth rate calculations
• Customer basket size analysis and upsell opportunities

HR & Employee Performance

• Department-level productivity scoring and ranking
• Target vs achievement analysis — identifying high performers and gaps
• Tenure vs performance correlation — retention impact on productivity
• Salary distribution and department cost analysis
• Absenteeism patterns linked to performance drops

Business Impact

The combined analysis delivered 12+ actionable business recommendations — from inventory reallocation and staffing optimisation to incentive structure redesign. Management now has a data-backed basis for every major operational decision.