time required: 3 minutes
How quickly is the city of Miami growing? Questions like these solicit an exploration of a topic rather than a single answer. Querying the neumark/city-of-miami repository gives us the raw data, which we can chart in Google Sheets using the freely available sheets extension.
To learn more about the extension, watch the short introduction video.
sheet in the demo doc runs a query on Splitgraph and displays the results as a
chart. It really is as simple as passing the query to the
There are two more sheets in the document:
Make a copy).
If you get stuck, watch the screen recording:
The cells returned by the
sgr() function don't always have the type needed for
creating charts. The timestamps are converted to dates in
contains the issued permit counts as numbers instead of strings (as originally
Spreadsheets have eaten the world! They're one of the most convenient ways to share data analysis, but they're not great for storing lots of data. Splitgraph gives you the best of both worlds: store your data in a database, query it using standard SQL, and work with the results in Sheets! Using dropdown menus and checkboxes we were even able to build a simple dashboard without ever leaving our spreadsheet.