CaseWare IDEA® Data Analysis software is a powerful and comprehensive tool that allows professionals to assess risk, gather evidence, uncover trends and provide the intelligence needed to make informed decisions from multiple data sources.
Centralized approach to capturing and analyzing data
Increased understanding of the organization’s operations and risks
Improved fraud detection by comparing data from different systems
Increased communication with stakeholders, management and regulatory entities
Streamlined business processes, strengthen controls and identify cost-saving opportunities
Import virtually limitless amounts of data from practically any source.
Correct formatting and alignment.
Save hours of data preparation work.
Obtain data from more than 99 accounting packages including QuickBooks, SAGE, ACCPAC and more, and standardizes them into a single output that is consumable by IDEA
Use the Open Database Connectivity (ODBC) to import IDEA data from third-party applications such as Tableau, Power BI, MS Excel and many more
Convert any file type, including ERP systems, spreadsheets, database software, legacy mainframes, financial applications, flat or print files (PDFs) and more, into an IDEA database file
Compatible with any locally-installed spreadsheet software associated with the .XLS extension, beyond just Microsoft Office
Automatic detection of files with international characters encoded in UTF-8 format to import data correctly without the need to change the encoding of the source files
Save time when importing multiple files of the same type by using the rerun feature
Individually select records to extract for more in-depth review
Comply with the General Data Protection Regulation (GDPR) with a complementary tool that reviews the data within IDEA and analyzes it to determine the risk factor based on GDPR laws.
With its Window’s-based user interface, IDEA is instantly familiar. You don’t need to be a data scientist or programmer to navigate its powerful functionality. It offers a multitude of features to ease navigation and put commonly-used audit commands within reach.
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
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.
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.
Expand your data analytics skills with our series of progressive learning where we begin with the essentials to achieve rapid ROI and set you up for long-term success. Ask about our Road to CIDA bundle to plan and save along the way – contact [email protected] for details.
Users receive unlimited access to the friendly IDEA experts for live support for all IDEA feature or function questions. Our Help Desk team will walk you step-by-step through any challenge, from difficulty importing files to creating IDEAScripts.
In the past they were only able to test approximately 20% with sampling across the board, due to lack of resources, now they can do 100% testing based on exception reports that we created using IDEA.