Data dashboard case study
Positive Grid Spark Sales Dashboard
A data dashboard tracking Positive Grid Spark amplifier preorder volume and estimated revenue.
This one is old by this site’s standards, a 2021 Python Dash app for watching public preorder numbers for the Positive Grid Spark amplifier. It was a small thing: a data pipeline feeding an interactive Plotly dashboard, built mostly because I wanted to watch a launch happen in something more useful than a spreadsheet I would forget to refresh.
The app read a Google Sheet through a service-account credential, pulled the
sales_totals worksheet, coerced the counter fields to numbers, and grouped
by date. From there it plotted daily totals and estimated revenue as an area
chart. Nothing clever, which was the point. The original app ran on Heroku
and that deployment has since been retired; what you see below is the same
dataset, rebuilt as a static chart for this page.
It is a small example of a pattern I still reach for at a much bigger scale now. Collect a signal, keep its history, and build the narrowest interface you can get away with for actually looking at it.