Forensic Accounting: Numeral Analysis

This is part six in a series on applying forensic accounting techniques to SQL and R. What the Numbers Tell Us In this last section of analysis, we're going to look at three tells for finding potentially fraudulent data: round number analysis, last-digit analysis, and first-digit analysis with Benford's Law. Round Number Analysis Round number…

Upcoming Events: Roanoke Valley .NET User Group

Key Details What: Roanoke Valley .NET User GroupWhere: Grandin Co-Lab, 1327 Grandin Road SW, Roanoke, VAWhen: Thursday, May 2nd at 6 PMAdmission is free. Register on Meetup. What I’m Presenting 06:00 PM — 08:00 PM — Machine Learning with .NET This is a brand new talk that I'll unveil for the first time for this…

Buffalo Draft Review, Day 2

Pick 38: Buffalo trades a 5th rounder to the Raiders to move up two picks, then selects RT Cody Ford. Buffalo has added 7 new offensive linemen this offseason, including 6 unrestricted free agents and now Ford. Ford is likely the new starting right tackle. With him in place, the question is now whether Ty…

Buffalo Draft Review, Day 1

Pick 9: Buffalo gets Ed Oliver. I love it. Oliver should have been the third-best player on the draft board after Quinnen Williams and Nick Bosa. He's got the potential to be an elite 3-technique tackle, which is core to the McDermott defense. I'm very happy with this pick and glad that Oliver slid to…

Upcoming Events: Triad BI User Group

Key Details What: Triad SQL Server BI User GroupWhere: 4821 Koger Boulevard, Greensboro, North CarolinaWhen: Tuesday, April 30th, 6 PMAdmission is free. Register on Meetup. What I’m Presenting 06:30 PM — 08:00 PM — Launching a Data Science Project: Cleaning is Half the Battle The Triad user groups are always a pleasure to visit. I…

Upcoming Events: SQL Saturday Raleigh

Key Details What: SQL Saturday RaleighWhere: Wake Tech RTP, 10908 Chapel Hill Road, Morrisville, North Carolina, 27560When: Saturday, April 27th, all dayAdmission is free. Sign up at the SQL Saturday website. What I’m Presenting Nothing at all! This will be the 5th SQL Saturday Raleigh that I've been involved with and my 4th running the…

Forensic Accounting: Cohort Analysis

This is part four in a series on applying forensic accounting techniques to SQL and R. Mr. Keynes' Aggregates Conceal the Most Fundamental Mechanisms of Change In the last post, we focused on high-level aggregates to gain a basic understanding of our data. We saw some suspicious results but couldn't say much more than "This…