Our Bootstrapping BI series kicks off with a spotlight on R.
R is quickly becoming a must-have tool in a data worker's tool-belt. You know its potency for statistical analysis and charting, but did you now that it can serve you well in a light-weight dashboarding and reporting function too? In this hands-on session, my colleague Jon Mauney and I will show you how R can be integrated into an existing agile development environment to enable a workflow by which any R beginner or expert can produce, deploy, and schedule R driven reports and dashboards. No license fees and no proprietary software: just a tiny bit of DevOps elbow grease to create automation against readily available and familiar open source tools.
The walkthrough will deal with the stack currently humming at Betterment (R Studio, S3, Linux, MySQL, GitHub, Jenkins, Confluence, a shell script, Cron), but its quite easy to swap in alternative components to fit your own environment. Its the workflow that matters.
This event will be co-hosted with NYC Open Data. Space, food, and drinks will be sponsored by Betterment.
Hands-on Workshop Items
We've prepped a fun, Team-based workshop component to help everyone get a feel for the process first-hand. We are going to collaboratively author and publish a self-updating dashboard using our process. Participation is optional but encouraged. We expect each team to have a good mix of skill sets, so no prior R or engineering experience required. Each team will also have a Betterment Captain to help steer you through the exercise.
To minimize set-up time, please bring your laptops with the following installed:
• http://www.wingfs.com/ - to mount s3 buckets as local drives
• http://git-scm.com/book/en/Getting-Started-Installing-Git - so you can commit your report sections to a common code repo. Optionally, install the Git GUI: http://sourcetreeapp.com/
• https://www.rstudio.com/ide/download/ - R Studio, but of course!
• http://www.sequelpro.com/ - MySQL client, or whatever you are comfortable with.
Stuck? Don't worry, Teams will most likely author on a single laptop to keep things manageable. Problems? Leave a comment below. See you all Monday.