How to excel without using Excel

There are many limitations of using Excel for your reports. RStudio makes reports and applications easy (and reproducible) using R.

How to excel without using Excel

July 2, 2019

There are many limitations of using Excel for your reports. You lose control of your data, your work is not reproducible, and you create artificial bottlenecks.

There are also many limitations of building interactive Excel tools. They are often too large to share, can contain ugly VBA code, and are almost impossible to maintain over time.

RStudio makes reports and applications easy using R. This talk demonstrates how to use R Markdown as a replacement for Excel reports and how to use Shiny as a replacement for Excel tools. It also demonstrates how to share and maintain these reports and apps over time in an organization.


About the speaker

Nathan has a background in analytic solutions and consulting. He has experience building data science teams, architecting analytic infrastructure, and delivering innovative data products. He is a long time user of R.