Getting Started with IDEA: Importing & Analyzing Data
View Upcoming Getting Started with IDEA Webcasts
An introductory course to IDEA data analytics software, specifically focusing on the importance of an auditor’s usage of the tool, techniques that can be applied within the software and what tasks are available to utilize. This webcast covers how to leverage data analytic tools to scale productivity and enhance the quality of the evidence gathered through testing.
| Course Level: | Basic |
| Length: | 1 Hour 15 Minutes |
| Learning Objectives: |
| • Extract data from databases • Duplicate transaction testing • Crossmatch databases & identify exceptions |
Introduction to IDEA
View Upcoming Introduction to IDEA Classes
Data analytics is essential for conducting efficient and effective audits. 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. Our half-day workshop provides a high-level overview of IDEA including:
- Importing Excel and CSV files and preparing data for analysis.
- Navigating IDEA's features and functionality to perform tasks such as indexing, summarizing, joining, and filtering.
- Turning result files into electronic working papers, and best practices for sharing findings.
| Course Level: | Basic |
| Continuing Education: | 4 CPE |
| 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. |
Data Cleansing Level 1
View Upcoming Data Cleansing Level 1 Classes
An important, yet often understated step in the data analysis process is data preparation. Without taking the right steps, data will be of limited use in testing, analyses, and informing critical business decisions. Data validation is a method for checking the accuracy and quality of your data, as well as its completeness and consistency to help ensure that test results are accurate.
| Course Level: | Intermediate |
| Continuing Education: | 4 CPE |
| Prerequisites: | Introduction to IDEA |
| Learning Objectives: |
| • Importing Print reports using multi-line fields and append layers • Data Validation using functions and field statistics • Identifying Duplicates using extractions and fuzzy logic |
Data Cleansing Level 2
View Upcoming Data Cleansing Level 2 Classes
Data cleansing is a critical step in the analysis process, one that can be time consuming without the proper know-how. Our expert instructor will walk you through the steps to cleanse, format and profile data to extract maximum value and deliver meaningful insights.
| Course Level: | Intermediate |
| Continuing Education: | 4 CPE |
| Prerequisites: | Introduction to IDEA |
| Learning Objectives: |
| • Joining databases using Visual Connector • Correcting Data shifts using multiple functions • Using functions to clean data • Testing Data Accuracy |
Mastering Problem Imports
View Upcoming Mastering Problem Import Classes
Gain hands-on experience on importing difficult print reports or PDF files into IDEA using the Report Reader.
| Course Level: | Intermediate |
| Continuing Education: | 4 CPE |
| Prerequisites: | Working knowledge of Microsoft Windows® desktop environment and Microsoft Office® applications. IDEA Data Analysis Level 1 and one year of consistent use of IDEA including importing, adding fields, extracting data, and summarizing data. |
| Learning Objectives: |
| • How headers and footers work together • 10 steps to a successful template and how to tell what went wrong • How to deal with reports output to Excel • How to work with multi-line layers and multi-line fields • How floating traps and layers work |
Building Complex Equations
View Upcoming Building Complex Equations Classes
This 2-hour course will teach the practice of using IDEA @functions and embedded equations to solve complex testing procedures.
| Course Level: | Intermediate |
| Continuing Education: | 4 CPE |
| Prerequisites: | Working knowledge of Microsoft Windows® desktop environment and Microsoft Office® applications. IDEA Data Analysis Level 1 and one year of consistent use of IDEA including importing, adding fields, extracting data, and summarizing data. |
| Learning Objectives: |
| • Build nested @functions • Work with dates • Extract multiple values from a column of information • Cleanse data to enhance your testing • Pull records containing specific words or phrases contained anywhere in a field • Use with multiple conditions without having to nest @if statements |
Travel Expense Fraud Workshop
View Upcoming Travel Expense Fraud Classes
Travel & Entertainment expenses are a prime focus of proactive fraud audits and can result in large recoveries and identification of potential losses. From fraud and abuse to clerical errors and loss prevention, we’ll take you from novice to expert using IDEA to analyze T&E Expenses. Learn the entire process from start to finish including how to spot the warning signs of fraud and how to create essential tests.
| Course Level: | Intermediate |
| Continuing Education: | 4 CPE |
| Prerequisites: | IDEA Fundamentals or CI101: IDEA Data Analysis Level 1 |
| Learning Objectives: | |
| • Determine T&E scope • Create information requests • Understand real fraud examples • Perform reasonableness checks |
• Identify duplicate & altered receipts • Identify misuse of the card • Identify explicit businesses • Create effective audit reports |
CI101: IDEA Data Analysis Level 1
Learn how to navigate 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, attendees will learn how and where to apply IDEA and will build skills through hands-on instruction using case studies and sample data.
| Course Level: | Basic |
| Continuing Education: | 16 CPE |
| Prerequisites: | Working knowledge of Microsoft Windows® desktop environment and Microsoft Office® applications |
| Learning Objectives: | |
| • Understand the purpose and use the basic features and functions IDEA offers • Determine what data is required, and how to obtain/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: append & join databases • Basics for building equations to automate repeatable processes • Document, report and share your findings
|
CI102: IDEA Data Analysis Level 2
During this course, attendees will take their IDEA skills to the next level. After completing the IDEA Data Analysis Level 1 course, or gained experience working with IDEA, it is time to tackle more complex data analysis tasks. This two-day IDEA Data Analysis 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 attendees learn more advanced techniques including creating equations or criteria, automating tasks and connecting databases.
| Course Level: | Intermediate |
| Continuing Education: | 16 CPE |
| Prerequisites: | Working knowledge of Microsoft Windows® desktop environment and Microsoft Office® applications. Familiarity with CI101 course topics. Completion of CI101 is recommended |
| Learning Objectives: | |
| • 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 processes/tasks by working with Visual Script and IDEAScripts • Access resources available from CaseWare for continued learning |
|
Ready, Set, Script!
View Upcoming Ready, Set, Script! Classes
This class is an introduction to IDEAScript. Attendees will learn how to create, run and modify basic scripts using IDEA’s Macro Record, Project Overview, and History for robust reusability.
| Course Level: | Intermediate |
| Continuing Education: | 8 CPE |
| Prerequisites: | IDEA Data Analysis Level 1 and attendees should have 1 year of consistent experience with IDEA |
| Learning Objectives: | |
| • Basics of Object Oriented Programming. • Create scripts using IDEAs Macro Record, Project Overview, and History. • Create basic dialog boxes to request and accept information from the user. • Understand Variables and Constants and how to use them effectively. • Create, Modify, and Reuse Functions. • Use Conditions including IF statements and CASE statements. • Basic debugging and using the Language Browser. |
|
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 |
| Continuing Education: | 16 CPE |
| Prerequisites: | Working knowledge of IDEA. Familiarity with CI101 and CI102 course topics. Completion of CI101 and CI102 is recommended |
| Learning Objectives: | |
| • 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 |
|
CI105: IDEAScript for Analysts Level 2
This one-day course introduces experienced IDEA 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 |
| Continuing Education: | 8 CPE |
| Prerequisites: | Working knowledge of IDEA. Familiarity with CI101 and CI102 course topics. Completion of CI104 is recommended |
| Learning Objectives: | |
| • 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 |
|
CI201: IDEA Data Analysis CIDA Exam Preparation
View Upcoming CIDA Prep Classes
This one-day course is a refresher for 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 |
| Continuing Education: | 8 CPE |
| Prerequisites: | Participants must complete CI101 IDEA Data Analysis Level 1 and CI102 IDEA Data Analysis Level 2 before attending this course |
| Learning Objectives: | |
| • Learn to use IDEA tasks in the context of their daily work • Apply data analytics in real-life situations • Prepare to take the CIDA exam |
|
Fraud Data Analytics Seminar
Fighting the costly problem of fraud requires a mix of theoretical knowledge and practical skill. Really, you can’t have one without the other. Our instructors will help attendees understand fraud data analytics methodologies and provide hands-on instruction to apply IDEA in the right areas. This course offers a powerful combination of “why” and “how” that will enable attendees 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 share real-world client examples, including real data sets, to simulate how they used IDEA to successfully uncover common fraud schemes.
| Course Level: | Intermediate |
| Continuing Education: | 20 CPE |
| Prerequisites: | Participants should have completed CI101: IDEA Data Analysis Level 1 or an equivalent data analysis course and have knowledge of IDEA's functionality |
| Learning Objectives: | |
| • Import,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 |
|