Caseware IDEA - Data Analysis Software

Analyze for Instant Insights
 

IDEA’s unique Analytic Intelligent features automatically analyze and profile data to pinpoint patterns, trends, outliers and correlations that may have gone unnoticed in a table.

Whether you’re unsure about where to start searching for anomalies or wanting to take your analysis to the next level, IDEA offers features that meet all your data analytics needs:

• Ribbon – Provides 100+ audit-specific commands to perform tasks such as duplicate detection, joins, gap detection and Benford’s Law tests.

• Smart Samples – Saves time when calculating sample size, evaluating results and drawing statistically valid conclusions

• Discover – Identifies trends, patterns, duplicates and outliers and creates a dashboard to further refine your results and serves as a starting point for audit scoping and planning

• Advanced Fuzzy Duplicate – Identifies multiple similar records within one, two or three selected character fields, then output databases including or excluding fuzzy matches with varying degrees of similarity.

• @functions – Performs complex operations such as date, arithmetic, financial and statistical calculations, and text searches

• Field Statistics – Calculates more than 100 commonly-requested statistics, making it easy to reconcile totals, inspect value ranges and identify errors

• Character Field Statistics – Breaks character fields into categories and identify records with blank character fields, which may indicate anomalies within the data such as transactions where there is no authorizer

• Benford’s Law Tests – Spots irregularities by analyzing digits in numerical data to spot potential fraud. Advanced settings can be used to customize outputs and set parameters

• Top Records – Reveals risky transactions and high dollar amounts

• Direct Extraction – Allows you to extract multiple databases from a larger database using key values, or identify transaction that occurred after the year-end cutoff date

• Python – Enables outlier analysis using built-in artificial intelligence to independently identify anomalies in both small and large data sets and works with both numeric and character fields

Download 5 Ways to Fight Fraud Using Data Analytics

Report & Bring Your Results to Life
 

IDEA meets your needs for sharing and communicating your results in ways that others can easily understand and provide you with ways to stay organized along the way.

• Use predictive analysis tasks including Correlation, Trend Analysis and Time series to forecast and extrapolate data. These tasks can be used to detect gaps and duplicates in sequenced data such as invoice numbers.

• Automatically create charts and field statistics to profile your data and pinpoint patterns, trends, outliers and correlations that may have gone undetected in a table

• Display data graphically in up to 10 panels, which can be customized to show exactly the results you want to see and zoom in for a closer look

• Stay organized with the Library where you can:

  • Store files and assets in order including equations, import definitions, source files, macros, project summaries and custom functions

  • Browse project files and view their properties, including status, size and last modified date

  • Drag-and-drop items into the Library and send items directly from the Library by email

• Drag-and-drop your results directly into the CaseWare Working Papers document managers

We can help you transform your results into amazing reports using data visualization tools including Power BI and Tableau.

Get to the Point! Benefits of Embracing Data Visualization

Automate Your Work to Save Hours of Effort
 

Professionals who use IDEA save hours (sometimes months) of effort and improve the consistency of their work by using these built-in features:

• Re-Run – With one click, you can repeat the most recent action, change parameters to correct errors, or rerun the same task with slight changes to explore what-if scenarios.

• Project Overview – Presents a graphical representation of the entire audit or investigation process, which may be shared with management or used to meet documentation requirements.

• Visual Script – Automates tasks without writing code to easily build your own IDEAScripts. There are two types of macros you can create with IDEA:

  • IDEAScripts work much like Microsoft® Excel macros, but with greater speed and flexibility

  • @functions are built-in macros inside IDEA that can help manipulate or normalize data

  • Plus, supported IDEA users have access pre-written IDEAScripts and @functions

We create custom IDEAScripts to automate your processes.

Learn How to Use IDEA to Automate Your Tasks