How to Build a Data Dashboard using R (knitr), HTML, and Javascript (Highcharts, Leaflet)

Ideally, I would have had all of the data I needed sitting on a single server, ready for me to crunch on command. In practice, most local governments (including Somerville) use dozens of different vendors, few of whom employ simple APIs.

In the first part of this tutorial, I will describe how I set up and automated pipelines that move data to my machine on a daily basis. If you already have the data you need, or want a less hacky solution than mine, please skip to part 2.

FTP

APIs

Automate It

Written on