Financial Analytics Dashboard
Built an interactive Streamlit dashboard to provide real-time financial insights to stakeholders.
Problem
Finance teams had to manually compile revenue, profit, and trend reports from multiple sources. This process was error-prone and time-consuming, delaying decision-making.
Solution
Built a Streamlit dashboard that connects to databases via Python ETL scripts, automatically fetches financial data, and displays interactive KPI cards, trend charts, and drill-down tables for detailed analysis.
Impact
- ✓ Reduced report generation time from 2 hours to 5 minutes
- ✓ Eliminated manual data entry errors (now auto-refreshed)
- ✓ Enabled 24/7 stakeholder access to financial KPIs
- ✓ Supports trend analysis across 12+ financial metrics
Tech Stack
Python (Pandas, NumPy) • SQL • Streamlit • pandas_datareader • Plotly
Financial Analytics Dashboard
4x
Faster reporting
12+
KPI Metrics tracked
24/7
Access for stakeholders