Applying Forensic Accounting Techniques using SQL and Python

About this event

The October Ohio North Database Training user group meeting will be held on October 6th, 2026 at 5:00PM. This will be a HYBRID event and we will be joined online by Kevin Feasel. You're welcome to come meet in-person at our meeting location, the offices of Improving at 6000 Freedom Square Dr, (https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D) Unit 110, (https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D) Independence, OH 44131 (https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D) Teams Link (https://teams.microsoft.com/meet/232853677048343?p=Dfpo8iMWXKjtZ5OZpU) if anyone needs it after RSVP-ing for in person. If you would like to subscribe to our email list outside of Meetup, we have changed platforms recently and you will need to register here in Kit (https://ohio-north-data-training.kit.com/b8f036f615)instead to receive emails. Agenda: 5:00 PM EST: Online and in-person meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other group members before the session starts. There will be food brought in for in-person attendees. 6:00 PM EST: Elections, announcements, followed by our feature presentation. See below for presentation details. 7:30 PM EST: Optionally after the main presentations, the in-person crowd may go out for snacks and drinks at a local establishment. We hope to see you there! Session Abstract Applying Forensic Accounting Techniques using SQL and Python 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. \*Please note, that we will be using Microsoft Teams for the online portion of this meeting. You may want to join a few minutes early to ensure you do not have any issues. If you are attending in person, there are large TVs at the office, and you do not need to bring a laptop or use Teams.