BI, Big Data, Data Analytics, and Data Visualization

SQW09 Introducing Forensic Analytics with PowerPivot for Excel


1:45pm - 3:00pm

Level: Introductory

William Pearson

William E. Pearson III

Business Intelligence Architect and Founder

Island Technologies Inc.®

Despite the wealth of analytical technologies available today, 65 percent of fraud at public companies is detected through tips, management review or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.

This session will explore Forensic Analytics: a set of techniques you can use to uncover irregularities in financial data. You'll gain an understanding of goals of Forensic Analytics: to help you find out how and why these irregularities exist, and to find out their source(s) especially when you suspect fraudulent activity. You'll learn guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, you'll see examples of how you can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.

You will learn:

  • The definition and objectives of Forensic Analytics
  • Discuss approaches to detecting data anomalies, particularly when fraudulent activity is involved, within organizational data
  • Outline methodology, and a standard, repeatable process, to support the successful employment of Forensic Analytics
  • Introduce, and discuss examples of, the use of PowerPivot for Excel to drive Forensic Analytics via various tests and reviews