Bootstrapping BI: Light-weight Dashboarding and Reporting workflows with R

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.

Join or login to comment.

  • Nitin k.

    https://github.com/ygoldman/rwiz­ = Link is not working...

    April 1

  • Yuriy Michael G.

    RWizFlowy GitHub repo: https://github.com/ygoldman/rwiz...­

    Note that EC2, S3 are now read-only and you will have to provide your own datasource.

    April 1

  • Don H.

    Just saw this. Love to attend.

    March 31

  • Shubin L.

    Can I still come and join today ?

    March 31

  • dave m.

    While it pains me most grievously, I have just relinquished my seat for tonight, as it appears I'd be there 45' late, at best... sigh...

    March 31

  • Chaitanya

    Last minute changes to my schedule. Too bad I will be missing this meetup.

    March 31

  • Nitin k.

    It would be great if this presentation is recorded. There are people who have last minute cancellation but really want to learn and benefit a lot from this....
    Also, would be great if slides can be put up... Pl. let us know….

    March 31

    • Yuriy Michael G.

      Slides and accompanying workshop walkthrough will become available. We are still deciding if video recording will be possible.

      March 31

  • Yuriy Michael G.

    Windows users: try http://www.expandrive.com/expan...­ trial for mapping s3 buckets as drives on windows.

    March 29

  • Nitin k.

    Yuriy,

    Would appreciate your help....
    http://www.wingfs.com/­ = I checked the FAQ and it says wingfs works with MAC. I am running Windows 7 Professional. Am wondering if that will be an issue...

    March 29

  • Andrew O.

    Looks like I'm going to have to skip out on tonight. Will there be any slides shared afterwards?

    March 27

    • Rob W.

      Hey Andrew. The Meetup is on Monday.

      March 27

Our Sponsors

People in this
Meetup are also in:

Sometimes the best Meetup Group is the one you start

Get started Learn more
Bill

I started the group because there wasn't any other type of group like this. I've met some great folks in the group who have become close friends and have also met some amazing business owners.

Bill, started New York City Gay Craft Beer Lovers

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy