1. Home
  2. /Projects
  3. /Sales Dashboard
Teilen
Business Intelligencedashboard

Sales Dashboard

Comprehensive Sales Analytics Dashboard for analyzing business data from the ODIN ERP system. Real-time insights into revenue, customer behavior, and sales performance for the DACH region.

React 18TypeScriptFastAPIMySQLDocker
5 Min
instead of 2 days reporting
10K+
records in real-time
1
dashboard replaces 40 spreadsheets

Challenge & Solution

Challenge

Sales data was scattered across Excel spreadsheets and a legacy Access database. Reports took hours to compile and were often outdated before they were finished.

Solution

A central BI dashboard that consolidates all sales data in real time. Revenue, customer behavior, and trends are now visible at a glance — without manual preparation.

Technical Details

Expand / collapse

Features

Frontend (26+ Pages)

  • Interactive geo maps with Leaflet
  • Real-time filters and drill-down
  • PDF/Excel export
  • ABC analysis, RFM segmentation
  • Churn risk prediction
  • Command palette navigation

Backend (FastAPI)

  • Async/await for performance
  • Redis caching
  • SQLAlchemy + MySQL
  • Geocoding service
  • Prometheus monitoring
  • Multi-tenant capable

Analytics Modules

  • Executive dashboard KPIs
  • Quarterly/monthly comparisons
  • Customer health index
  • Top articles analysis
  • Quote conversion
  • Forecast & potentials

Tech Stack

Frontend

React 18TypeScriptViteMUI v6RechartsLeafletZustand

Backend

PythonFastAPISQLAlchemyRedisPandasPrometheus

Infra

DockerMySQLNginxNAS
All projects