- Developed an Excel system that synchronizes inventory tracking with financial performance, providing real-time calculations for Net Profit, Stock Value, and operational expenses (e.g., Salary, Logistics).
- Developed an automated dashboard featuring dynamic timelines and brand-wise performance analysis, transforming raw transactional data into actionable insights for better cash flow management and stock optimization.
Power Pivot Pivot table Timeline Real time Dashboard