TalkRs - R for ETL & Board packs in R

R for ETL - Jan Gorecki

Get the most from R for ETL processing.

easy database connection managing (DBI, RJDBC, RODBC) top performance data manipulation (data.table, dplyr) similar functionality helper packages overview Board packs: Combining shiny, LaTeX and databases for full effect - Steph Locke

The monthly report pack for the Board -- with lots of information from different sources and all requiring commentary from lots of people -- these things can take weeks to produce, send for commentary, and then compile into one pack.
This full hour takes you through a framework for a single core source document, a shiny interface, hooks into the database for commentary, and the LaTeX (or markdown) document structure needed for developing a single interface through which lots of people can contribute to a single document.