DEV Community

Gesner Deslandes
Gesner Deslandes

Posted on

Real‑time analytics dashboard with demo Link

What I built

A company needed a real‑time analytics dashboard to connect multiple data sources – SQL, Excel, CSV – and visualize KPIs, sales trends, inventory, and custom reports. They also wanted full multi‑language support with instant switching (English, Spanish, French, Haitian Creole).

I built the Business Intelligence Dashboard to solve this exactly.

Key features

  • Connect to SQLite, upload CSV/Excel files, or use sample retail data
  • Real‑time KPIs: total sales, orders, average order value, inventory value
  • Interactive date range filter
  • Sales trend line chart, top products bar chart, inventory pie chart, regional sales bar chart
  • Full multi‑language support with instant switching (English, Español, Français, Kreyòl Ayisyen)
  • Download filtered reports as CSV
  • Secure login (password: 20082010 for demo)

Tech stack

  • Python
  • Streamlit
  • Pandas for data processing
  • Plotly Express for interactive charts
  • SQLite for database connectivity
  • Custom translation dictionary

Live demo

https://9enktzu34sxzyvtsymghxd.streamlit.app/Business Intelligence Dashboard

Use password: 20082010

What we do at GlobalInternet.py

We provide tailored software solutions that connect the global market with local expertise. We build custom AI‑powered applications, business tools, and automation systems – delivered fast with full source code.

Contact us

Phone: (509) 4738 5663
Email: deslandes78@gmail.com
Website: https://globalinternetsitepy-abh7v6tnmskxxnuplrdcgk.streamlit.app/

What's next

I am adding scheduled email reports, Google Sheets integration, and user management for multi‑tenant access.

Feedback welcome

Try the live demo, upload your own data, and see the dashboards in your language. I would love to hear your suggestions or feature requests. Comment below or reach out via my website.

python, #streamlit, #businessintelligence, #analytics, #dashboard

Top comments (0)