How to build visualizations from data dumps

When you use ImportData, ImportJSON, BigQuery or any other method to get CSV, JSON or Database data into Google Sheets, you often end up with what can be described as a "data dump". To illustrate this, take the following example of someone’s running data from a Fitbit:Database_dump.png

Building visualizations from data dumps isn’t straightforward, so we recommend creating a new sheet to analyze the data and get the metrics that you need.

For example, from the above sheet you might want to see how many times you’ve run in each City, or how many times you’ve gone for morning, afternoon, evening,  or night runs, etc. This is possible by using formulas such as UNIQUE, COUNTIF and other Statistical and Maths functions.

Here’s a new "Analysis for Geckoboard" sheet with a series of calculations from the original sheet. For reference, you can this and the above sheet mentioned in this article here.data_analysis.png

When you’ve added the calculations you need in the new sheet, you can connect your Spreadsheet to Geckoboard and build visualizations like these:Runs_example.png

Tip

You can also manipulate your "data dump" data using Pivot Tables. If you do so please take this advice into consideration. 

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Heather

    USA