Retail businesses managing hundreds of products and suppliers often struggle with manual sales tracking, errors, and delayed insights. This project delivers an automated sales tracking system combining SQL data cleanup, Google Sheets automation, and Power BI dashboards to provide clear, real-time insights and enable faster, data-driven decisions.
Challenges
- Manual sales tracking prone to errors and delays
- Lack of visibility into top-performing products
- Difficulty identifying slow-moving inventory
- Delayed monthly reporting impacting timely decisions
Solution
- Automated Google Sheets Pipeline: Daily sales entries feed into a master dashboard via Apps Script automation
- SQL Data Processing: Cleaned and structured sales and inventory data with profit margin and reorder calculations
- Power BI Dashboard: Interactive visualizations for revenue tracking, product performance, stock alerts, and sales trends
Key Features
- Daily updated top-selling products chart to guide restocking
- Low stock alerts for timely inventory replenishment
- Profitability analysis by product, category, and month
- Monthly sales trends for forecasting and planning
- Mobile-friendly data entry for shopfloor staff
Technologies Used
- Google Sheets + Apps Script (Automation)
- PostgreSQL (Data Cleanup & Analysis)
- Power BI (Interactive Dashboard)
Impact
- Reduced reporting time by 90%
- Stockouts decreased by 60% within 2 months
- Faster, data-driven purchasing decisions
- Weekly revenue increased by 15% due to improved forecasting
Why This Matters
This project demonstrates my ability to integrate multiple tools to solve complex retail challenges, delivering systems that save time, reduce errors, and empower smarter business decisions.
Skills Demonstrated: Data Cleaning • SQL Queries • Google Sheets Automation • Business Intelligence • Dashboard Design • Client-Focused Solutions