CP030: Detecting fraud in data using Excel – 5 techniques for you
About this episode
In the 30th session of Chandoo.org podcast, let's learn how to uncover fraud in data.
What is in this session?
In the wake of hedge fund scams, accounting frauds and globalization, We, analysts are constantly second guessing every source of data. So how do you answer a simple question like, "am I being lied to?" while looking at a set of numbers your supplier has sent you.
That is our topic for this podcast session.
In this podcast, you will learn
- Quick announcements about 50 ways & 200k BRM
- Introduction to fraud detection
- 5 techniques for detecting fraud
- Benford's law
- Auto correlation
- Discontinuity at zero
- Analysis of distribution
- Learning systems & decision trees
- Implementing these techniques in Excel
- A word of caution
The post CP030: Detecting fraud in data using Excel – 5 techniques for you appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
Get every episode summarized
Each time Chandoo.org Podcast - Become Awesome in Data Analytics publishes, we email you a written briefing from the transcript — the topics, who appeared, and any specific claims, with the ad reads skipped.
Email me new episodesFree for 3 shows. No card needed.
Hosts & guests
No transcript yet
This episode has not been transcribed. Request it and it moves to the front of the queue.
More episodes
More from Chandoo.org Podcast - Become Awesome in Data Analytics
CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)
Chandoo.org Podcast - Become Awesome in Data Analytics
SQL vs. Power Query – The Ultimate Comparison
Chandoo.org Podcast - Become Awesome in Data Analytics
CP03: The Ugly Truth About Power BI (actually, 4 of them)
Chandoo.org Podcast - Become Awesome in Data Analytics
CP02: Six Tips to get a Six Figure ($100,000+) Data Job
Chandoo.org Podcast - Become Awesome in Data Analytics