Navigate Up



 October 8, 2013

10/8/2013 8:00 AM
10/8/2013 4:30 PM
Salt Creek Grille, Princeton | New Jersey

"Quickly Detecting Fraud and Errors 
with Data Analytics"

​​Date:​ Tuesday, October 8, 2013
​8:00 am - 8:30 am
8:30 am - 4:30 pm


​Salt Creek Grille
1 Rockingham Row
Princeton, NJ

​​Our Speaker​s
Rich Lanza

Event Sum​mary

This workshop provides an understanding of the power of data analysis through the use of case studies in the areas of accounts payable, contract auditing, payroll, general ledger, and health benefit reviews.  The course will explain a holistic analytic approach step-by-step using simple tools (like Excel) while also integrating more advanced products (i.e., ACL, IDEA, Tableau). 

It is expected that after this seminar, each participant will understand:

  • How data analysis can work like magic to uncover fraud, errors, and cost recovery opportunities.
  • The various types of technology used to detect fraud with a focus on Microsoft Excel, ACL, IDEA, ActiveData for Excel, and WizRule to facilitate explaining data analysis concepts.
  • How data analysis is used to query and mine data for gold in the areas of accounts payable, payroll, healthcare and the general ledger.  Specific case studies will be reviewed and discussed.
  • How fraud scoring can use a customized weighting system to flag suspicious transactions.
  • To use a digital analysis (Benford’s Law) Excel scoring workbook which combines 10 digital analysis techniques into one scored analysis.
  • Why graphing and geo-mapping can quickly highlight key items for sampling and follow up.
  • When to use statistical analysis techniques such as monthly stratification and vendor normal average analysis to highlight timeframes of change.
  • How the general ledger can provide a digital road map for analytics for fraud (and errors) within the organization.  Specific analytics demonstrated will show you how to understand over 80% of the data population within a few minutes or hours…with the remaining 20% available for more specific review. 
  • How to quickly gather report ideas and techniques for analysis, as well as, obtain a list of some of the top fraud tests by process area.  
  • Learn how planning analytics can be integrated into top audit areas.
  • See how analytics can maximize the annual audit plan ​

​Event Objectives
Attendees will walk away with a set of new methods such as report scoring, audit result graphing, geo-mapping, and calculating digital analytics that work together in a combined approach to increase detection rates of errors and fraud.  Further, planning activities for an annual audit plan or a particular audit will also be examined closely to ensure data analytics are integrated throughout such processes.    

​​On Line Registration Closes: ​Monday, October 7 at 10:00 am
CPE:​ ​8
Level of Knowledge​: Basic​
​Prerequisite & Advance Preperation: None​
Method of Presentation:​ Group Live​
Recommended Category of Eligibility:​ Audit​

Cancellation Policy:

The Chapter guarantees to each venue a minimum number of registered participants. If you register for an event, the Chapter expects you to pay the registration fee, as the Chapter incurs a cost for every registered no-show; Refunds will be granted to those giving at least 72 hours advanced notice. You are responsible for the full registration fee without cancellation notice given or with no cancellation.  Substitutions are welcome. For questions or cancellations, please contact our event manager at If you need to cancel, we ask that you do so at least 72 hours prior to the event