On August 16, 2017, I gave a version of this talk at NDC Sydney. You can get the recording on the NDC Youtube channel.
The slides are licensed under Creative Commons Attribution-ShareAlike.
Click here to access demo code for this presentation. This includes all of the SQL and R code, as well as data sources used in demos. This also includes a notebook for tidyr
The source code is licensed under the terms offered by the GPL.