We made a daily autoupdated visualization that puts Danish energy prices into perspective. We compare the price levels with neighbouring countries, energy zones and historical data. The visualization is an example of an easy integration via Infogram and a google sheet, that is simple plug and play, but explains complex data un a daily basis without daily manual interferance.
The project was a prototye of live-graphs. The aim was to document that it is easy to set up a data story that keeps its relevance every day. The project proved succesfult and still have a permanent spot on our frontpage. Furthermore, there are more siblings of Elvis being prepared with other types of autoupdated live-visualisations. Both readers and editors approve the value of this project.
We scraped daily updated data from a stable online data source through a code in Google Sheets. Infogram has an integration where the graph can pull data every 15 minutes from Google Sheets. Finally, the Infogram graphs are embedded in an article on our media site.
Context about the project:
What stands out in this project is how a simple method and integration can be used to create products with high value. Every day our readers (engineers and technical professionals) can see the daily statistics of how the electricity prices are developing compared to eralier years or days or even neighboring countries. It also demonstrats how a dataviz can become an independent story in itself, that readers return to for daily updates.
What can other journalists learn from this project?
It is easy to create autoupdated visualisations that have long lasting relevance.