A 'data story' with Looker using public Looks & Google Sheets

embed
visualizations

(Brecht Vermeire) #1

Data storytelling

Presenting your data often involves a compelling narrative. Building beautiful and clear visualisations is a big part of this, but often you’d like to add some context, or some glue between these visualisations to tell your story in a coherent way.

This is a simple example of how you can use public Looks to easily create a data story, using nothing more than a Google spreadsheet. Easy to setup and maintain!

You can see an example of this here.

Step by step

  1. Make a copy of this spreadsheet. Make sure you stick to the format: the highlighted row is the title and description of the datastory that will go on top.
  2. Under this row, add as many public Looks as you want to present! The Public Look ID is provided when you make a Look public and looks like this: 6gTRXxJFx3wKBGdvSwymqqpS5kNrJRjr
  3. Publish the spreadsheet (File > Publish to the web)
  4. Get the spreadsheet ID from the url (e.g. https://docs.google.com/spreadsheets/d/{{ this part }}/edit#gid=0)
  5. Either host the files yourself or serve them straight from the repository, e.g:
  6. Add the spreadsheet ID to the url, e.g:
    • https://raw.githack.com/brechtv/looker_datastory/master/index.html?id={{ add spreadsheet ID }}

Demo

You can see an example of this here.
You can find the source in this Github Repository.