This project showcases a powerful live business analytics dashboard built using Streamlit, Python, and Google Sheets API. Designed for small and mid-sized businesses, it delivers real-time performance insights through interactive visualizations and automated logic-driven alerts.
📊 Key Highlights
Real-time sync with Google Sheets for live data monitoring
Visual dashboards built with Streamlit and Matplotlib/Plotly
Alerts and cost-saving recommendations based on anomaly detection
Custom logic that reflects domain-specific performance rules
No manual updates — data refresh and reports are fully automated
🎥 Demo Video
🛠️ Tech Stack
Python + Streamlit – Frontend dashboard framework
Google Sheets API – Real-time data backend
Custom algorithms – Business rule-based logic & alerting
🎯 Outcome
The dashboard helps business owners track key KPIs, identify inefficiencies, and make faster, data-backed decisions without relying on spreadsheets or external analysts.