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…
Book Review: Mastering .NET Machine Learning
This is a review of Jamie Dixon's book Mastering .NET Machine Learning. For the sake of transparency, Jamie is a friend and if I hated his book I wouldn't badmouth it in public, so adjust your priors accordingly. I enjoyed this book. Jamie wrote his book before Microsoft started on the ML.NET library, so he…
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: Time Series Analysis
This is part five in a series on applying forensic accounting techniques to SQL and R. Dealing with Time This post will be a pretty short one. In my talk, I don't have any demos, mostly because much of cohort analysis has secretly been time series analysis at the same time. Instead, I'll lob out…
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…
Forensic Accounting: Basic Analysis
This is part three in a series on applying forensic accounting techniques to SQL and R. Getting Exploratory The term "basic analysis" is pretty broad, so we're going to cover a few concepts today. Most of this is in the realm of Exploratory Data Analysis, looking at the data to gain a better understanding of…
36 Chambers - The Legendary Journeys: Execution to the max! 