IDEA Data Analysis

Unlock the power within your data

IDEA: Your trusted data analysis software

Whether you’re an auditor, accountant or finance professional, data analysis is a challenge. Compiling information from numerous sources and in a wide array of formats is time consuming, and increases the risk of errors being introduced. Luckily there’s IDEA®, a comprehensive, powerful and easy-to-use data analysis tool that quickly analyzes 100% of your data, guarantees data integrity and speeds your analysis, paving the way to faster, more effective audits.

IDEA offers more than 100 audit-relevant tasks to meet all of your analytic needs, from import to analysis to reporting. With just a few easy clicks you can view multiple data sets as one, letting you see the big picture and focusing your search by identifying relationships, patterns, outliers and anomalies within your data. 

What IDEA can do for you

Import without the effort

IDEA gets your data analysis process up and running quickly with its universal file conversion capabilities. Effortlessly import all of your records in virtually any format and from any source: spreadsheet and database software, accounting programs, ERP systems, T&E applications and files such as PDFs, plain text (.txt), print-report (.prn), ODBC and SAP. With read-only access, IDEA also protects the integrity of your data and ensures the accuracy of audit assessments and disclosures. You can also easily export information to a broad range of formats, and can share and email files directly from your Library. Simple.

Analysis in a snap

IDEA helps you overcome the data analysis hurdle, giving you access to its 100+ common audit functions at the click of a button, including Benford’s Law, advanced Fuzzy Duplicate that identifies similar records in as many as three character fields, Gap Detection, Field Manipulation, Summarization, Stratification, Sampling and more. IDEA also lets you record every analytic step you take and then repeat it for future use via a graphical drag-and-drop interface.

Your data, at a glance

Take your data analysis to the next level with IDEA’s Visualization feature, powered by our proprietary Analytic Intelligence. Visualization’s two tasks, Discover and Visualize, create charts and field statistics for you, visually profiling your data so you can quickly pinpoint patterns, trends, outliers and correlations that may have been overlooked in a table. Display your data graphically in a customizable Visual Dashboard that you can build through Visualize or that Discover can automatically generate for you with just a few easy clicks.  

Passport to IDEA resources

Passport is your gateway to invaluable IDEA resources, including links to IDEA add-ons, webinars, the IDEAScript Vault, forums, Help, the Support Portal and more. All of the help and resources you need are in one convenient location, so you can maximize IDEA’s tools and features to accelerate your audit.


Pre-built Routines. Smarter Analysis.

IDEA SmartAnalyzer is a collection of queries and tasks that can be used on every audit engagement to improve audit quality and consistency. IDEA SmartAnalyzer offers an extensive set of routines for the analysis of general ledger, accounts receivable, inventory, fixed assets and accounts payable transactions.

Easy to Use, Easy to Implement

1. Import Data




2. Select the Desired Routines









3. Review and Report Results








Get started now with these routines.

Analyse SAP Data

SAP® is an extremely efficient, potent and multi-faceted enterprise resource planning (ERP) solution. However, business process and application controls can deteriorate over time due to change in regulations, business practices or employee attrition, and as such, this ever changing landscape can present unforeseen risks. The ongoing analysis of core data systems can prevent threats and address risks at an early stage.

The extraction of SAP data is simplified allowing for easy review and analysis. SmartExporter resolves many common issues associated with transferring SAP data outside of the software’s environment such as security, data capacity and timing of data downloads. Once you configure the data request by defining the tables, fields and filters, you can save it as a favorite and reuse in the future.

Convenient Analysis

The data request is not generated in SAP®, but on your local hard-drive or enterprise server. Data requests are scheduled for immediate download or for a specific time during off-peak business hours and saved for repeat use. Output formats include IMD (IDEA), CSV, Access, TXT, AIS, and files formatted according to the default data structure.

Safe and Secure

SmartExporter is compatible with existing SAP® access privileges. Therefore, the SAP tables for which you do not have access rights within the ERP, will not be accessible through this solution. The original SAP® data cannot be edited as the SmartExporter solution produces read-only content. All actions can be traced at any time, as they are recorded by a unique ID. This ensures maximum transparency.

Basic Steps