A live business analytics dashboard that turns messy Google Sheets data into real-time visual insights — no Excel, no manual reports.
Most small businesses track their revenue in messy Excel files.
- No live view of performance
- No charts or visual trends
- Business owners waste hours compiling reports manually
- Decisions are delayed because data is always outdated
A business owner can now see their full sales performance in 10 seconds.
- Open the link → instantly see revenue, orders, trends
- Dashboard updates automatically every time the Google Sheet is edited
- No Excel skills needed. No manual reports. Just pure insight.
| Tool | Purpose |
|---|---|
| Python | Core logic & data processing |
| Streamlit | Web dashboard UI |
| Pandas | Data manipulation & analysis |
| Plotly Express | Interactive charts & graphs |
| Google Sheets API | Live data source connection |
- ✅ Live KPI cards (Total Revenue, Total Orders, Avg Order Value)
- ✅ Revenue Over Time line chart
- ✅ Auto-refresh on Google Sheet update
- ✅ Dark themed, clean UI
# 1. Clone the repo
git clone https://github.com/YOUR_USERNAME/business-dashboard.git
cd business-dashboard
# 2. Install dependencies
pip install -r requirements.txt
# 3. Add your Google Sheets credentials (see setup guide below)
# 4. Run the app
streamlit run app.py- Go to Google Cloud Console
- Create a project → Enable Google Sheets API
- Download
credentials.json→ place in project root - Share your Google Sheet with the service account email
streamlit
pandas
plotly
gspread
oauth2client
Ashish — Freelance Creative Technologist Portfolio · LinkedIn · GitHub