Automated Sales & Revenue Analytics Dashboard using Google Sheets / Excel

Built an automated, real-time Sales & Revenue Tracker designed to help businesses monitor daily performance and key operational metrics seamlessly:

Data Cleaning & Structuring: Processed and standardized raw order records, establishing clear data schemas and dynamic revenue calculations.

Automated Reporting: Implemented dynamic SUMIF, COUNTA, and SUM formulas to aggregate performance metrics automatically across sales regions and product categories.

Executive KPI Dashboard: Designed an interactive executive overview displaying Total Revenue, Units Sold, and Total Orders that update instantly as new transaction data is added.