Description
Learn how to identify unique patterns within the data to uncover fraudulent activities.
The purpose of this information is to increase the productivity of your Excel skills to possibly detect potential inappropriate activity in your line of work. The information will focus on utilizing formulas, conditional formatting, and pivot summaries to obtain insights and look at more complex detection methods through Benford’s Law. You will explore the possibilities of queries and visualizations, through addons, such as Power Query and Power BI. Through the review of these Excel commands, functions, and addons, you will learn how to identify unique patterns within the data to uncover potential findings. This topic will provide practical applications that you can apply to your business.
Date: 2019-02-18 Start Time: End Time:
Learning Objectives
Data Fundamentals
• The Importance of Understanding Your Data Prior to Performing Analysis
• The Importance of the Structure of Your Data
• Flat File
• Structured vs. Unstructured
• Data Cleansing (Text to Columns)
Excel® Functions and Queries to Utilize When Detecting Fraud
• Duplicate Entries (Formula)
• Round Dollar Check (Formula)
• Check Sequencing (Formula)
• Address Fuzzy Matching (Formula)
• Disbursement Threshold Identification (Formula)
• Utilizing Excel® PivotTables to Assist in Summarizing Your Data to Come to Conclusions (Pivot Tables)
• Other Fraud Detections Tools
• Benford’s Law (Multiple Formulas)
Art of Possible
• Power Query (Combining Excel® Files)
• Power Pivot (Formula “Measure” Demonstration and Slicer)
• Power BI Demo
• Alteryx Workflow Demo
Alexandra Psaris-PricewaterhouseCoopers LLP, Mihnea Rotariu – Forensic Risk Alliance, Koutayba Yamak – PwC
