October 8, 2013
"Quickly Detecting Fraud and Errors
with Data Analytics"
||Tuesday, October 8, 2013
8:00 am - 8:30 am
8:30 am - 4:30 pm
Salt Creek Grille
1 Rockingham Row
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
- 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
- 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
|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|
|Level of Knowledge:
|Prerequisite & Advance Preperation:
|Method of Presentation:
|Recommended Category of Eligibility:
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 firstname.lastname@example.org. If you need to cancel, we ask that you do so at least 72 hours prior to the event