Applying Forensic Accounting Techniques using SQL and Python

Abstract: 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 Python to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.

Speaker: Kevin Feasel

Speaker Bio: Kevin Feasel is a Microsoft Data Platform MVP and Proprietor of Catallaxy Services, LLC, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608) and Finding Ghosts in Your Data (https://link.springer.com/book/10.1007/978-1-4842-8870-2). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

LinkedIn: Kevin Feasel | LinkedIn
Twitter: Kevin Feasel (@feaselkl) / X

Agenda:

• 12:15-12:30pm: Sign-in & network
• 12:30-12:35 pm: Announcements & Intro
• 12:35-1:35pm: Presentation
• 1:35-2:00pm: Q&A, wrap-up

Location:
Online. You must register for the link