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 AuthorFollow on Twitter Follow on Linkedin Visit Website More Content by Nathan Stephens