Back to All Recent Work
Data Analysis & Business ReportsFeatured
Retail Sales & Inventory Tracker
Automated multi-store sales analytical dashboard featuring XLOOKUP, dynamic PivotTables, and KPI slicers.
Created by: Rohan Patil (College Student • Commerce)
Project Duration: 10 Days
Associated Course
Advanced Excel & Business Analytics
This capstone project is part of our curriculum in Mhaska. Students learn the concepts and build the application under faculty supervision.
Project Overview
What Was Built?
A business simulation project designed for local retail stores in Maharashtra to track monthly profits, low-stock alerts, and category turnover without costly software.
The Challenge
Problem Solved
Manual bookkeeping was error-prone, slow, and provided zero visibility into seasonal sales patterns.
The Execution
Solution Provided
Constructed an automated Excel workbook with clean data tables, automated invoice lookups, and visual summary charts.
Key Technical Features
Interactive timeline and category slicers for instant filtering
Automated stock warning conditional formatting (Red < 5 units)
Advanced formulas: XLOOKUP, SUMIFS, INDEX-MATCH
Printable executive monthly summary report
Technologies & Tools Used
MS ExcelPivotTablesData CleaningKPI Dashboards
Skills Demonstrated
- Reduced report generation time from 3 hours to 2 minutes
- Created 100% reusable template for retail shops
- Earned Advanced Excel Course Distinction