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


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.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.