Sales Insight Tool: Sales & Inventory Analytics Dashboard
Project Overview:
Development of a comprehensive Google Sheets-based management system for a retail business (BarberShop & Store). The tool automates sales tracking, inventory costs, and customer segmentation.

Key Features:

Dynamic Sales Tracking: Automated calculation of revenue, COGS, and net profit.

Inventory Management: Detailed product database including categories, pricing, and cost analysis.

Customer Analytics: CRM module with VIP/Standard status tracking and location-based insights.

Performance Metrics: Real-time dashboard showing Top Products, Most Profitable Clients, and Average Daily Profit.

Data Visualization: Interactive charts for sales distribution and performance trends.

Technical Stack:

Google Sheets

Advanced Formulas (VLOOKUP, SUMIFS)

Pivot Tables & Data Visualization