Applying Forensic Accounting Techniques Using SQL and R


Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.


On May 3, 2017, I gave a version of this talk at 24 Hours of PASS. You can get the recording and slides notes on the event website.

On November 5, 2017, I recorded a full-length version of this talk, which you can find on my YouTube channel.