Data
Visualise a data export
Turn a Spotify, Strava or Google export into a year-in-review you can scroll.
Fill it in
The folder your download unzipped into.
The question worth answering.
Filters and hover detail rather than a static page.
Your prompt
Build a year-in-review report from . What I want to know: [your what you want to know] Read the export's own structure first. These dumps are deeply nested, the interesting data is rarely in the obvious file, and half of it is timestamps in UTC that need moving to local time before any "by hour" chart means anything. Lead with what surprised you. A report that only shows the totals the app already shows is a slower version of the app. The value is in the cut nobody made: what dropped off, what appeared, what turned out to be a phase. Make it interactive: filters and hover detail, so a reader can chase their own question. One self-contained HTML file.
Continue and pick your folderOpens with everything above already filled in.
Why this works
A report that shows the totals the app already shows is a slower version of the app. The value is in the cut nobody made: what dropped off, what appeared, what turned out to be a phase. It also moves the timestamps to local time first, without which every by-hour chart is wrong.
Questions
- Which exports?
- Anything you can download as a folder: Spotify, Strava, Google Takeout, Apple Health.