Better Business Through Data Analysis & Monitoring My Account
 Fraud Data Analytics Seminar

Fighting the costly problem of fraud requires a mix of theoretical knowledge and practical skill. Really, can’t have one without the other. Our instructors will help you understand fraud data analytics methodologies and provide you with hands-on instruction to apply IDEA in the right areas.

This course offers a powerful combination of “why” and “how” that will enable you to quickly identify fraud within disbursements and payroll. We begin with proven methodologies for building a fraud data analytics plan, demonstrate how to use IDEA to build tests around the plan, and interpret the results.

Our instructors will share real-world client examples, including real data sets to simulate how they used IDEA to successfully uncover common fraud schemes.

Course Level Intermediate
Length Two and half days (20 CPE)
Delivery Method Group Live Event
Prerequisities Participants should have completed CI101: IDEA Data Analysis Level 1 or an equivalent data analysis course and have knowledge of IDEA's functionality

 

After completing this training, participants will be able to:

  • Import and test, filter and cleanse data to prepare it for analysis
  • Develop search routines within the master file and perform transaction testing
  • Apply data analytics for disbursements and payrolls to search for fraud schemes

Participants will leave this course with a deeper understanding of the methodology behind payroll and disbursement fraud schemes, plus gain proficiency in using IDEA to detect and prevent them.

 CI201: IDEA Data Analysis CIDA Exam Preparation

This one-day course was developed to refresh long-time IDEA users and people that took the required training but want to be better prepared to take the Certified IDEA Data Analyst (CIDA) exam. This course was written using the concept of a case study to cover most of the core functionality of IDEA and focus on the content and the style of the CIDA exam.

Course Level Intermediate
Length One day (8 CPE)
Delivery Method Group Live Event
Prerequisities Participants must complete CI101 IDEA Data Analysis Level 1 and CI102 IDEA Data Analysis Level 2 before attending this course.

 

After completing this training, participants will be able to:

  • Use IDEA tasks in the context of their daily work
  • Take the CIDA exam
  • Apply data analytics in real-life situations

avt.TabsPro

 CI101: IDEA Data Analysis Level 1

IDEA Basics to Get You Started

We make it easy to get started using CaseWare IDEA. This introductory course will help you navigate through IDEA's features and functions to gain a deeper understanding of how data analytics can be applied in your everyday work. In just two days, you will learn how and where to apply IDEA, plus build your skills through hands-on instruction using case studies and sample data.

Course Level:
Basic
Length:
Two days (16 CPE)
Delivery Method:
Group Live Event
Prerequisites:
Working knowledge of Microsoft Windows® desktop environment and Microsoft Office® applications

 

After completing this training, participants will be able to:

  • Understand the purpose and use the basic features and functions IDEA offers, including navigating the IDEA Ribbon to quickly access audit-specific commands
  • Determine what data is required, and how to obtain and import different data types into IDEA
  • Effectively manage and use multiple databases
  • Reconcile and examine data to search for outliers and potential fraud
  • Isolate specific records for further investigation
  • Profile data using stratification and summarization
  • Identify irregularities including duplicate key and gap detection
  • Apply commonly-used sampling techniques: systematic, random and stratified random
  • Audit a general ledger file using a case study example
  • Manipulate and add fields
  • Use IDEA @Functions and build equations to add virtual fields, filter, sort and match data
  • Work with multiple databases: appending and joining databases
  • Basics for building equations to automate repeatable processes
  • Document, report and share your findings
 CI102: IDEA Data Analysis Level 2

Take Your IDEA Skills to the Next Level

After you’ve completed the Level 1 course, or gained experience working with IDEA on your own, it is time to tackle more complex data analysis tasks. Our two-day Level 2 course is designed to build your skills and achieve higher levels of efficiency. This course provides hands-on instruction using a series of case studies to help you learn more advanced techniques including creating equations or criteria, automating tasks and connecting databases.

Course Level:
Intermediate
Length:
Two days (16 CPE)
Delivery Method:
Group Live Event
Prerequisites:
Working knowledge of Microsoft Windows® desktop environment and Microsoft Office® applications. Familiarity with CI101 course topics. Completion of CI101 is recommended.

 

After completing this training, participants will be able to:

  • Handle advanced data extract and imports with greater confidence, speed and accuracy, including PDF imports
  • Connect multiple databases to bring data together from different sources for analysis
  • Apply advanced @functions and custom functions to perform complex calculations and testing
  • Perform advanced data profiling using Benford’s Law
  • Automate repeatable processes and repeatable tasks by working with Visual Script and IDEAScripts
  • Access resources available from CaseWare for continued learning and assistance
 IDEA Fundamentals Workshop

Data analytics is essential for conducting efficient and effective audits. Our one-day workshop provides a comprehensive, high-level overview of IDEA including:

  • Importing files and preparing data for analysis
  • Navigating IDEA's features and functionality to perform tasks such as summarizing data, adding fields to a database, joining two databases, using pivot tables and stratification, etc.
  • Turning result files into electronic working papers, and best practices for sharing findings

This event prepares beginner-level IDEA users, and those who need a refresher course, for our two-day hands-on training courses (IDEA Data Analysis Level 1 and Level 2), which provide more hands-on instruction.

Course Level:
Basic
Length:
One day (8 CPE)
Delivery Method:
Group Live Event
Prerequisites:
Workshop attendees are encouraged to attend our one-hour Getting Started with IDEA webcast to become familiar with IDEA’s basic features and functions.

 

Who Should Attend:

  • Individuals tasked with selecting or standardizing a data analysis solution
  • New or beginner-level data analytics users who need direction and guidance to get started
  • Existing users who need a refresher for using IDEA
 Analyzing Travel & Entertainment Using IDEA

Travel and Entertainment is an area plagued with fraud, abuse, and clerical errors. Learn how to use IDEA to quickly identify anomalies, exceptions, and fraud. Specific audit tests to be covered will include testing for transactions in excess of spending limits, identifying duplicate transactions, weekend transaction review, searching for prohibited vendors or activities, and effective sampling.

Course Level:
Basic
Length:
One hour (1 CPE)
Delivery Method:
Group Internet-Based
Prerequisites:
A demonstration copy or a purchased license copy of IDEA is recommended but not required. Having the software will allow you to apply the knowledge learned very soon after attending this session. It is recommended that you have some exposure to the software prior to attending this event.

 

After completing this training, participants will be able to:

  • Creating a Project and Adding Source Files
  • Import Excel Files into IDEA
  • Indexing
  • Field Statistics
  • Add Fields to a Database
  • Write Formulas Using @functions
  • Joining Databases
  • Summarizing Databases
  • Duplicate Key Detection/Exclusion
  • Search Feature
  • Random Sampling
  • Stratified Random Sampling
 Inventory Analysis Using IDEA

Learn how to use IDEA to identify exceptions in Finished Goods & Raw materials inventory – both in quantity and in costing issues. Identify exceptions in a ticket detail file, and identify costing issues based on the relationships between material, labor, and overhead components, and identify movement of inventory that was not invoiced!

Course Level:
Intermediate
Length:
1 Hour 15 Minutes (1.5 CPE)
Delivery Method:
Group Internet-Based
Prerequisites:
Some experience with IDEA and/or complete the Getting Started with IDEA webcast.

 

After completing this training, participants will be able to:

  • Key Value Extraction
  • Executing a Script
  • Indexing
  • Data Extraction
  • Field Manipulation
  • Join Databases
  • Compare Databases
  • Duplicate Key Detection
  • Summarization
  • Aging Analysis
  • Top Records Extraction
 General Ledger Analysis Using IDEA

Learn how to use IDEA to identify anomalies and exceptions in the General Ledger. Specific audit tests will be covered to identify one-sided entries, out of balance journal entries, unusual activity by user, entries on abnormal days, activity posted in an incorrect account, missing or duplicate journals, trend analysis, and perform a key word search to detect suspicious activity.

Course Level:
Intermediate
Length:
One hour (1 CPE)
Delivery Method:
Group Internet-Based
Prerequisites:
Some experience with IDEA and/or complete the Getting Started with IDEA webcast.

 

After completing this training, participants will be able to:

  • Summarization
  • Field Manipulation
  • @Functions - compif, left, justnumbers, precno, dow, @day
  • Join Databases
  • Gap Detection
  • Dupliacte Key Detection
  • Search
  • Benford's Law
 CI104: IDEAScript for Analysts Level 1

This two-day course introduces experienced users to more advanced topics devoted to workflow automation with IDEAScript macros. IDEAScript, the IDEA programming language behind IDEAScript macros, is similar to and compatible with Visual Basic for Applications, the macro language used in Excel®, PowerPoint®, Word®, Access®, and other Microsoft Office® applications.

Course Level:
Advanced
Length:
Two days (16 CPE)
Delivery Method:
Group Live Event
Prerequisites:
Working knowledge of IDEA. Familiarity with CI101 and CI102 course topics. Completion of CI101 and CI102 is recommended.

After completing this training, participants will be able to:

  • Create scripts using IDEA’s History, Project Overview and Recording functions
  • Automate scripts using the Windows Task Scheduler
  • Create dynamic scripts that respond to user inputs and choices and work on multiple datasets
 Text/HTML

This one day course introduces experienced users to more advanced topics devoted to workflow automation with IDEAScript macros. IDEAScript, the IDEA programming language behind IDEAScript macros, is similar to and compatible with Visual Basic for Applications, the macro language used in Excel®, PowerPoint®, Word®, Access®, and other Microsoft Office® applications.

Course Level:
Advanced
Length:
One days (8 CPE)
Delivery Method:
Group Live Event
Prerequisites:
Working knowledge of IDEA. Familiarity with CI101 and CI102 course topics. Completion of CI104 is recommended.

After completing this training, participants will be able to:

  • Create custom dialog boxes and validate user input for correctness
  • Create scripts robust to usage by many people within the organization
  • Utilize arrays in IDEAScript
 
Frequently Asked Questions for Training
Meet the IDEA Instructors
On-Site Training
Self Study Options
Training Course Descriptions
 

Hands down, IDEA is easier to use than other analytics tools. To fully maximize your use of IDEA and for faster implementation, we recommend new and experienced users take advantage of our many training opportunities. Our courses are offered throughout the U.S. and online for all levels of users (Beginner, Intermediate and Advanced). Many will even earn NASBA CPE credit and help you work toward CaseWare Analytics IDEA Certification.

The best thing about our training - our first-class instructors. We've been working with IDEA for over 20 years - we know the product inside and out. Our instructors are Certified Public Accountants (CPAs), Certified Fraud Examiners (CFEs) and Certified IDEA Data Analysts (CIDA) with experience working in the trenches of accounting, audit and finance. Plus, they make learning fun…now that’s worth signing up for!