This Business Intelligence (BI) platform provides an interactive environment for exploring 'Superstore' retail datasets. By utilizing an HTMX-driven 'HTML-over-the-wire' architecture, the application delivers seamless KPI updates and diverse spatial analytics, enabling deep-dive data exploration without full-page reloads.
Key Features
- Dynamic Metric Orchestration:
Enables fluid date-range filtering and toggling between primary metrics (Sales vs. Profit vs. Orders) through asynchronous DOM injections.
- Multi-variate Data Exploration:
Renders a diverse suite of visualizations including Choropleth maps, Sunburst hierarchies, and Donut charts—to provide a multi-dimensional view of regional performance.
- Synchronized Visual Analytics:
Features integrated Stacked Bar and Line charts that update in tandem, allowing users to identify trends and categorical distributions across different time scales.
Technical Breakdown
- Server-Side Analytical Aggregation:
Offloads heavy computational lifting to the database layer using Django's .annotate(), Sum(), and Count() functions for optimized query performance.
- Decoupled Endpoint Architecture}:
Implements multiple JsonResponse and HTML-fragment endpoints to serve granular dashboard components independently.
- Dynamic Visual Serialization:
Programmatically converts Plotly figures into raw HTML strings via Plotly Express, enabling seamless, script-safe injection into the dashboard grid.
HTMX
Plotly Express
Django ORM