Retail Management Analytics – KD Mart (Excel + Python)

Developed a comprehensive Excel-based analytics system for KD Mart, a 2000 sq. ft. retail supermarket in Maharashtra, to transform raw sales and purchase data into actionable business insights.

The project involved:

Data Extraction: Pulled daily sales and purchase data from the store’s POS system.

Data Cleaning & Structuring: Cleaned large, inconsistent datasets using Python and Excel Power Query.

Automated Reports: Built dynamic Excel dashboards with MOM (Month-over-Month) and YOY (Year-over-Year) comparisons for category, brand, and item-level performance.

Profitability Insights: Identified margin leakages, excess stock, and slow-moving items — helping management take timely decisions.

Cashflow Management: Designed a simple visual tracker for inflows/outflows and working capital trends.

The system now helps the store review performance weekly, control expenses, and make data-backed purchase and pricing decisions — without needing any manual analysis.