tidycf: Turning analysis on its head by turning cashflows on their sides – Emily Riederer

February 25, 2018

Abstract

Statistical computing has revolutionized predictive modeling, but financial modeling lags in innovation. At Capital One, valuations analysis required legacy SAS platforms, obscure data lineage, and cumbersome Excel cashflow statements. In this talk, we describe how we developed the tidycf R package to reinvent this process as a seamless, end-to-end workflow.

Reimagining cashflow statements as tidy data facilitates a simple, efficient, and transparent workflow while incorporating more statistically rigorous methods. We leverage the full power of R and RStudio – building on top of the tidyverse; reducing complex crunching, wrangling, and visualization to pipeable functions; guiding analysis and documentation with RMarkdown templates; and incorporating features of the latest development version IDE. Altogether, this delivers a good user experience without the overheard of maintaining a custom GUI.

The resulting package goes beyond “getting stuff done”. tidycf also increases quality, reproducibility, and creativity of analysis; ensures consistency and knowledge transfer; reduces the burdens of documentation and regulation; and speeds innovation and time-to-market – all while guiding less-technical analysts through an immersive crash course to R and the tidyverse.

We will share best practices and lessons learned from our experience designing a tidy package, incorporating RStudio features, and evangelizing R through user-onboarding.


About the speaker

Emily Riederer
Senior Business Analyst, Capital One

Emily’s work has spanned marketing and credit analytics with a focus on modeling. Emily enjoys sharing her passion for statistics and computing with her colleagues – particularly by advocating for workflow improvement and adoption of open-source software.

Previous Video
Modeling in the tidyverse – Max Kuhn
Modeling in the tidyverse – Max Kuhn

Next Video
The lesser known stars of the tidyverse – Emily Robinson
The lesser known stars of the tidyverse – Emily Robinson