IDEA Training
IDEA CaseWare Analytics
Our Instructors are Certified IDEA Data Analysts. Take advantage of them now to make the most out of your analytics.
Interactive Data Extraction and Analysis [IDEA]
IDEA Training for new hires and refresher training for veteran employees demonstrates a commitment to professional development. Many employees report that training leads to greater job satisfaction, productivity, and a strong intent to remain with an organization. It takes the best tools and skills to do any job well, but employees are often asked to use expensive company software with little, if any, training. Our Training provides employees with the skills and confidence they need to make an impact organization-wide.
IDEA Data Analysis Level 1
Duration: 2 days
Prerequisites
- Working knowledge of Microsoft® Windows® Desktop environment and Microsoft® Office® applications.
The purpose of this two-day introductory course is to acquaint new users with the bulk of IDEA’s
basic functionality and breadth of tools. Training is immediately hands-on, so participants have the opportunity to quickly interact with the software by completing exercises and case studies using sample data. After completing this training, participants will be able to:
- Understand the purpose and features of IDEA.
- Consider business objectives to which IDEA can be applied.
- Determine the data required and import the data.
- Use IDEA in Data Analytics to increase efficiency and effectiveness.
- Introducing IDEA
- Managing Databases
- Obtaining and Importing Data
- Reconciling and Examining Data
- Isolating Specific Records
- Profiling the Data
- Identifying Irregularities
- Sampling
- Auditing a General Ledger File
- Manipulating and Adding Fields
- Building Equations
- Using Multiple Databases
- Working with Output
- Recap Exercise
- Documentation Standards
- Other Products
- Accessing Resources
IDEA Data Analysis Level 2
Duration: 2 days
Prerequisites
- Working knowledge of Microsoft® Windows® desktop environment and Microsoft® Office® applications.
- Familiarity with IDEA Data Analysis Level 1 course topics.
- Completion of IDEA Data Analysis Level 1 is recommended.
This two-day course is ideal for those who have completed the IDEA Data Analysis Level 1 training or have a sound understanding of IDEA functionality. Participants learn more advanced topics, such as creating complex equations or criteria, automating tasks and Benford’s Law. After completing this training, participants will be able to:
- Expand their use of data analytics in Audit, Finance, and other industries.
- Apply advanced data analytics techniques and best practices.
- Automate data analytics.
- Improve governance and controls, and reduce risk in their organization.
- Advanced Data Profiling using Benford’s Law
- Advanced Imports
- Advanced Extractions
- Connecting Multiple Databases
- Advanced @Functions
- Custom Functions
- Introduction to Automation in IDEA
- Case Study – Independent Study
- Case Study – Management Report
IDEASCRIPT for analysts
Duration: 3 days
Prerequisites
- Working knowledge of IDEA.
- Familiarity with IDEA Data Analysis Levels 1 & 2 course topics.
- Completion of Idea Data Analysis Levels 1 & 2 is recommended.
This three-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 Microsoft® Office® applications.
After completing this training, participants will be able to:
- Automate repetitive tasks such as importing files.
- Create special tests and functions.
- Create smart data analytics systems with customizable dialog boxes, tags, and reports.
- Introducing IDEAScript
- Recording a Macro
- Understanding IDEAScript Syntax
- Working with Macros
- Customizing a Macro
- Using the Language Browser
- Functions and Sub-Routines
- Array Handling
- Creating Dialog Boxes
- Creating Your Own IDEAScript Script