Simple YTD Button

This tutorial will walk you through creating a button to swap back and forth between showing the full years worth of data, and showing all years filtered to the most recent date in your dataset. This can be useful when trying to see how the current year compares with prior years when not yet occurring dates aren't included.

more ...

Automating a Tableau Public Dashboard

Manually updating Tableau dashboards isn't exactly hard. First you open up Tableau, next you open the workbook you wish to update, lastly you click on data in the toolbar, hover the dataset you wish to update and click refresh. Not hard, but doing it daily, can begin to be a pain and feel like a chore. Luckily! Tableau Public has google sheets as a datasource and allows you to keep the dashboard synced with the sheet daily updates. This will show you how to add a few lines to your pandas workflow to upload your dataframe to google sheets automatically.

more ...

Creating Trips from gbfs with AWS

Providence's JUMP Bike program provides location data of every bike currently available through the gbfs data feed. Using Python and AWS you can sorta create trip data of the bikes. While the gbfs data is directly from the company, it's not ment to be used for trip data. However currently it is the only data provided for Providence and there is no official trip information publicly available.

more ...