CaseWare IDEA
The Most User-Friendly and High Performance Audit Analytics Solution
Expand Your Audit Analytics Landscape
Data Analytics is changing the game for audit, accounting and finance professionals globally. So, when you’re analyzing data for any audit, whether you want to detect fraud, or identify anomalies, trends or patterns, you need a solution that helps you deliver high-quality audits every single time.
IDEA® Data Analysis Software is a comprehensive, powerful and easy-to-use data analysis solution designed by audit experts. With a modern, intuitive interface and advanced analytical functionalities, IDEA accelerates data analytics, provides a more user-friendly experience and enables deeper insights in a timely, cost-effective manner for more informed business decisions.
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.
– See more at: http://www.casewareanalytics.com/products/idea-data-analysis#sthash.4OqaVkeu.dpuf
Pre-built Routines. Smarter Analysis.
Introducing IDEA SmartAnalyzer, a powerful solution offered by Pierre Consulting to enhance audit quality and consistency. This collection of queries and tasks can be utilized in every audit engagement to streamline processes and improve efficiency.
With IDEA SmartAnalyzer, you will save valuable time and resources by eliminating the need to define standard tests and create reports from scratch. The tool also allows for easy acceleration of analysis and standardization of workflows across your business.
In addition, IDEA SmartAnalyzer grants access to a wide range of time-saving tests for various transactions including General Ledger, Accounts Payable, Accounts Receivable, Inventory, Fixed Assets and more. With this solution, you can be confident that your audit process is thorough and consistent. Upgrade your audit process with IDEA SmartAnalyzer from Pierre Consulting.
Data Analysis Made Easy
At Pierre Consulting, we are proud to offer IDEA Lab as part of our products.
IDEA Lab is an innovation hub that provides our clients with access to a growing library of advanced analytics plugins developed by industry experts using the latest technologies.
Outlier Detection
Identify unusual items within a database easily by analyzing the different categories and amount combinations. The outliers plugin uses several different Machine Learning algorithms such as Local Outlier Factor, Support Vector Machine, and Isolation Forest. There are also many options to fine-tune the algorithms and improve the precision of the results.
Data Profiling
Take exploratory data analysis to the next level. Built-in Python modules are applied to your database to quickly generate in-depth interactive reports containing statistics and graphical representations.
Unstructured Data Analysis
Over 80% of the world’s information is found in sources that are not recorded as rows and columns of data but in unstructured form, such as written reports, memos, social media, books and articles. Simplify extraction and analysis of such data using some of our plugins, so you can make more-informed business recommendations.
Take exploratory data analysis to the next level. Built-in Python modules are applied to your database to quickly generate in-depth interactive reports containing statistics and graphical representations.
Audit Tests
Enhance your IDEA experience with these powerful tests hosted on IDEA Lab. These plugins offer additional testing capabilities to the IDEA user. Some of these audit tests even simplify testing that otherwise may involve multiple steps for analysis.
Utilities
We also offer a variety of utilities that are designed to simplify your daily work such as the currency converter plugin which converts any currency based on the required date and helps you easily identify related errors.
All of these features and more are available when you choose Pierre Consulting and IDEA 12.
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



IDEA Cloud Share – Anywhere, anytime.
More than ever, data is driving business around the world. And the world is becoming a smaller place as more people come together from different locations to make businesses more successful. Such is the case in the audit landscape as well. As a result, it’s imperative for internal and external auditors to manage and share accurate information in the most effective way for the engagements at hand.
For these reasons, we at Pierre Consulting offers IDEA Cloud Share which is a virtual platform that enables you to access, store and share project data, from IDEA and other external sources, with your team members on cloud and manage the audit process more efficiently. The shared functionality eliminates the risk of data duplication and fosters effortless collaboration.
IDEA Cloud Share ensures:
SEAMLESS COLLABORATION
Access, share and work together on data from any source, anywhere globally
ENHANCED TRANSPARENCY
Shared, centralized view of project data, visible to all stakeholders
CONTINUOUS PROTECTION
User authentication and constant backup, keeping project data secured
Connect to Caseware Cloud
Cloud Share provides IDEA users the power to connect to the exciting Caseware Cloud environment. Unlock advanced collaborative capabilities to engage with your staff as well as your clients, more efficiently and without any geographic constraints. You can now instantly communicate with them, assign tasks and even simplify file management. Using Caseware Cloud, you can also assign a highly secure, dedicated area where your clients can easily upload their data without any concerns.
Take collaboration to new levels of productivity and efficiency, contact us today to sign up for Caseware Cloud.