Try IDEA

Classroom Training In Your Area

IDEA Data Analysis – Intro to IDEA – March 2 – Online

Level 1

Live, Online
Mar 2, 2022 10:00 am
 

Introduction to IDEA is a half-day, hands-on workshop that will provide an in-depth overview of the data analysis functionality within the platform including: indexing, summarizing, joining, and filtering. Attendees will first import and perform data verification as well as basic analysis of a general ledger file. Then, an accounts receivable file will be aged and assessed against an AR credit limit file. IDEA’s navigation, visualization capabilities and arsenal of online resources will also be covered to ensure your individual success following this course. We encourage you to complete the “Getting Started with IDEA” webinar prior to attending this course, as you will need to be familiar with IDEA’s basic features and functions.

 

After completing this training, participants will be able to:

 

    • Create and set up projects
    • Navigate the IDEA File Explorer and Library
    • Import Excel files with multiple sheets
    • Use field statistics to verify and reconcile data
    • Summarize and Join Databases
    • Filter data and create extractions
    • Create new fields and basic equations
    • Age and Gap Detection
    • Simple duplicate detection and exclusion
    • Utilize Discover for data visualization
    • File documentation and history using Project overview
    • Resources available to IDEA customers

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise, the cancellation penalties below will apply. Cancellations with a request for a refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior to the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

Register

English

Mar 2, 2022 - Mar 2, 2022
10:00 am - 2:00 pm
Central US

Building Complex Equations- March 3 - Online

Level 1

Live, Online
Mar 3, 2022 10:00 am
This 4 CPE course will teach the practice of using IDEA @functions and embedded equations to solve complex testing procedures.

 

 
After completing this training, participants will be able to:

 

  • Apply @functions to properly convert date information from character type
  • Differentiate between Boolean data type values when building equations
  • Apply @functions to extract quarterly information from a date field
  • Apply @functions function to filter information from a database
  • Identify and apply @functions that can be used to cleanse and normalize data
  • Select and apply @functions that can parse and filter specific date components in a date field
  • Identify and apply IDEA @functions that are used to perform field searches
  • Recognize the proper syntax for applying @functions for searching within a field
  • Recognize the @functions used in parsing data within character fields
  • Identify and apply @functions that can be used to find information through pattern matching
  • Identify and apply the proper syntax for building equations to match a pattern within a field

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise, the cancellation penalties below will apply. Cancellations with a request for a refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior to the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

 

Register

English

Mar 3, 2022 - Mar 3, 2022
10:00 am - 2:00 pm
Central US

IDEA Data Analysis Level 1 - March 8-9 – Online

Level 1

Live, Online
Mar 8, 2022 8:30 am
IDEA® Data Analysis Level 1 is a hands-on, two-day,comprehensive introductory course that will acquaint new users with the IDEA platform’s functionality and wide range of tools to simplify your daily workflow and deliver greater insights. Participants will have the opportunity to interact with the software through a range exercises using sample data and will receive personalized support from the instructor – promoting improved competency of the content. Topics include, but are not limited to adding and manipulating fields, building equations, importing data, using multiple databases, reconciling data, identifying irregularities, isolating specific records, and sampling. Relevant real-world case studies will also be shared.

 

After completing this training, participants will be able to:

 

  • Understand the basic features and functionality of the IDEA platform
  • Determine what data is required, and how to obtain and import various types
  • Effectively manage and use multiple databases(append and join 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
  • Build equations to add virtual fields, filter, sort,and match data, automate repeatable processes

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise, the cancellation penalties below will apply. Cancellations with a request for a refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior to the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

 

Register

English

Mar 8, 2022 - Mar 9, 2022
8:30 am - 4:30 pm
Central US

IDEAScript for Data Analysts Level 2 – March 14-15 – Online

Level 2

Live, Online
Mar 14, 2022 8:30 am
IDEAScript for Data Analysts Level 2 is a virtual, hands-on, advanced applications course that guides you through the creation of applications using a custom interface. This course integrates the fundamental knowledge from the Introduction to IDEAScript to create applications that allow you to interface with the user. You will be introduced to the use of Arrays to obtain data from users or from an IDEA Database as well as error handling and validation to make your application a stronger solution. Hands-on training will ensure you obtain the skills required to create powerful IDEAScript applications. You will also utilize the IDEAScript Editor to create a wide range applications to help streamline your daily workflow. This training is instructor-led within a virtual desktop environment to guide you through various examples of different integrations and provides you the ability to ask questions and test your knowledge.

 

 

After completing this training, participants will understand:
  • Introduction to Arrays
  • Introduction to Custom Dialogs
  • Error Validation
  • Application Development
  • Good Programming Practices

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply. Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

 

Register

English

Mar 14, 2022 - Mar 14, 2022
8:30 am - 4:30 pm
Central US

IDEA Data Analysis – Intro to IDEA – March 16 – Online

Level 1

Live, Online
Mar 16, 2022 10:00 am
 

Introduction to IDEA is a half-day, hands-on workshop that will provide an in-depth overview of the data analysis functionality within the platform including: indexing, summarizing, joining, and filtering. Attendees will first import and perform data verification as well as basic analysis of a general ledger file. Then, an accounts receivable file will be aged and assessed against an AR credit limit file. IDEA’s navigation, visualization capabilities and arsenal of online resources will also be covered to ensure your individual success following this course. We encourage you to complete the “Getting Started with IDEA” webinar prior to attending this course, as you will need to be familiar with IDEA’s basic features and functions.

 

After completing this training, participants will be able to:

 

    • Create and set up projects
    • Navigate the IDEA File Explorer and Library
    • Import Excel files with multiple sheets
    • Use field statistics to verify and reconcile data
    • Summarize and Join Databases
    • Filter data and create extractions
    • Create new fields and basic equations
    • Age and Gap Detection
    • Simple duplicate detection and exclusion
    • Utilize Discover for data visualization
    • File documentation and history using Project overview
    • Resources available to IDEA customers

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise, the cancellation penalties below will apply. Cancellations with a request for a refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior to the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

Register

English

Mar 16, 2022 - Mar 16, 2022
10:00 am - 2:00 pm
Central US

IDEA Data Analysis Level 2 - March 22-23 - Online

Level 2

Live, Online
Mar 22, 2022 8:30 am

Taking Your IDEA Skills to the Next Level

 

IDEA® Data Analysis Level 2 is a hands-on, two-day course, ideal for those who have completed the IDEA Data Analysis Level 1 training or already have a solid understanding of IDEA platform functionality. This training will cover more advanced principles, such as creating complex equations or criteria, automating tasks, and connecting databases. Topics include, but are not limited to, advanced imports, data profiling with Benford’s Law, advanced extractions, connecting multiple databases, advanced @functions, custom functions, and introduction to automation using IDEA.

 

After completing this training, participants will be able to:

 

 

  • Handle difficult imports with greater confidence, speed and accuracy
  • Create advanced extractions and summarizations
  • Connect multiple databases to bring data together from different sources for analysis
  • Apply advanced @Functions to perform complex calculations and testing
  • Perform advanced data profiling using Benford’s Law
  • Automate processes/tasks by working with Visual Script and IDEAScripts
  • Access resources available from CaseWare for continued learning

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise, the cancellation penalties below will apply. Cancellations with a request for a refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior to the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

 

Register

English

Mar 22, 2022 - Mar 23, 2022
8:30 am - 4:30 pm
Central US

Analyzing Travel and Expense Fraud in IDEA - March 24 - Online

Level 1

Live, Online
Mar 24, 2022 10:00 am

Analyzing Travel & Expense Fraud in IDEA® is a half-day, hands-on workshop that will cover the entire process of T&E from start to finish, including how to work with key stakeholders,
creating recovery processes, modeling fraud behaviors, and executing testing procedures. Travel & Entertainment expenses are a critical focus of proactive fraud audits and it can result
in large recoveries and identification of potential losses. From fraud and abuse to clerical errors and loss prevention, this course will take you from novice to expert using IDEA to analyze T&E Expenses.
 

After completing this training, participants will be able to:

 

  • Determine scope and create information requests
  • Create essential relationships with accounting, legal, and corporate security
  • Understand real fraud examples and model data for them
  • Perform reasonableness checks on merchant data
  • Identify duplicates and questionable items
  • Identify explicit businesses
  • Perform risk-based exception testing
  • Create effective audit reports

 
Cancellation Policy:
You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise, the cancellation penalties below will apply.

Cancellations with a request for a refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior to the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

Register

English

Mar 24, 2022 - Mar 24, 2022
10:00 am - 2:00 pm
Central US

Detecting Fraud in Payroll and Human Resources - March 25 - Online

Level 1

Live, Online
Mar 25, 2022

Payroll and Human Resources are heavy with policies, procedures, and tight controls in most companies due to their responsibility over substantial cash outflow. How, then, does a global airline suffer a $35 million payroll fraud? How does an administrative assistant receive $1.4 million in overtime not worked over 17 years? How do 700 clients of a payroll processing company lose their payroll funds for an entire pay cycle? How does a global investment bank end up in a foreign corrupt practices investigation from their hiring tendencies?

This hands-on session offers the tools necessary to detect such problems early. Building off of our Detecting Fraud Using Data Analysis course; we dive deeper into a specific process and add to our repertoire of data analysis techniques. Through hands-on exercises and case studies, you will reinforce your learning, and see fraud as we encounter it in the field.

 

  • Understand Our Role in Fraud Detection:
    • Mindsets that keep people from detecting fraud
    • A five-step approach to fraud detection
  • Recognize What Can Go Wrong in Payroll & Human Resources:
    • How to detect ghosts on the payroll, incentive-drive frauds, theft in time reporting, false recruiting, embezzlement of payroll funds, corrupt hiring practices, and the newer phishing scams targeting Human Resources
    • How to work with HR to create an environment hostile towards fraud
  • Apply Data Analysis Techniques to Case Studies:
    • Building logical extractions to target symptoms of problems; identifying curious patterns; practical analyses for detecting violations of statistical laws
    • Payroll and HR fraud cases worth knowing, how to analyze them, and how to build an effective ‘pre-mortem’ testing plan to avoid the same problems

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise the cancellation penalties below will apply. Cancellations with a request for refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

 

Register

English

Mar 25, 2022 - Mar 25, 2022
-
Central US

IDEA Data Analysis – Intro to IDEA – March 30 – Online

Level 1

Live , Online
Mar 30, 2022 10:00 am
 

Introduction to IDEA is a half-day, hands-on workshop that will provide an in-depth overview of the data analysis functionality within the platform including: indexing, summarizing, joining, and filtering. Attendees will first import and perform data verification as well as basic analysis of a general ledger file. Then, an accounts receivable file will be aged and assessed against an AR credit limit file. IDEA’s navigation, visualization capabilities and arsenal of online resources will also be covered to ensure your individual success following this course. We encourage you to complete the “Getting Started with IDEA” webinar prior to attending this course, as you will need to be familiar with IDEA’s basic features and functions.

 

After completing this training, participants will be able to:

 

    • Create and set up projects
    • Navigate the IDEA File Explorer and Library
    • Import Excel files with multiple sheets
    • Use field statistics to verify and reconcile data
    • Summarize and Join Databases
    • Filter data and create extractions
    • Create new fields and basic equations
    • Age and Gap Detection
    • Simple duplicate detection and exclusion
    • Utilize Discover for data visualization
    • File documentation and history using Project overview
    • Resources available to IDEA customers

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise, the cancellation penalties below will apply. Cancellations with a request for a refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior to the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

Register

English

Mar 30, 2022 - Mar 30, 2022
10:00 am - 2:00 pm
Central US

Analyzing Inventory in IDEA - March 31 - Online

Level 1

Live, Online
Mar 31, 2022 10:00 am

Analyzing Inventory in IDEA® is a half-day, instructor-led training that walks students through a case study where they are hired to perform an Inventory Review at Bright IDEAs, Inc. The auditor evaluates business and audit risks associated with Inventory and then reviews potential tests that can be used to address those risks. This case study includes audit testing to agree total inventory values, check adequacy and accuracy of inventory, assess the re-ordering system, and analyze profit margins and pricing. We will also utilize a portion of the IDEA Data Analysis Workbook for your reference.

 

 

 

After completing this training, participants will be able to:

 

  • Import ASCII delimited files using field statistics and control totals to verify accuracy of import
  • Use equations to extract obsolete inventory items and negative quantities
  • Calculate usage ratios and months of inventory
  • Stratify inventory into bands
  • Calculate total provisions counts and value by location
  • Test accuracy of the reordering system
  • Analyze selling prices and inventory movements
  • Analyze profit margins

 

 

Cancellation Policy: You may reschedule for another date for the same event or substitute a co-worker without penalty as long as the substitute has similar or more advanced CaseWare IDEA skills. Rescheduling must be for an event within 12 months of the original event date. Otherwise, the cancellation penalties below will apply. Cancellations with a request for a refund must be made in writing before the event start date. Any written cancellation request received 30 days prior to the start of the event will be subject to a US $50 processing fee. Cancellation requests received less than 14 days prior to the start of the event will be subject to a US $250 non-refundable service charge. No refunds will be given for cancellation requests received within 7 days of the event start date. All requests for refunds will be processed within 30 days.

 

Register

English

Mar 31, 2022 - Mar 31, 2022
10:00 am - 2:00 pm
Central US

Fill out the following form to register for the course.

  • Please enter your full address including city and country.
  • This field is for validation purposes and should be left unchanged.