These tasks can be used to detect gaps and duplicates in sequenced data such as invoice numbers.Īutomatically create charts and field statistics to profile your data and pinpoint patterns, trends, outliers and correlations that may have gone undetected in a tableĭisplay 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
HOW TO USE @WORKDAY IN CASEWARE IDEA SERIES
Use predictive analysis tasks including Correlation, Trend Analysis and Time series to forecast and extrapolate data. 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. 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ĭownload 5 Ways to Fight Fraud Using Data Analytics Top Records – Reveals risky transactions and high dollar amountsĭirect 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 Advanced settings can be used to customize outputs and set parameters Smart Samples – Saves time when calculating sample size, evaluating results and drawing statistically valid conclusionsĭiscover – 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Īdvanced 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 – Performs complex operations such as date, arithmetic, financial and statistical calculations, and text searchesįield Statistics – Calculates more than 100 commonly-requested statistics, making it easy to reconcile totals, inspect value ranges and identify errorsĬharacter 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īenford’s Law Tests – Spots irregularities by analyzing digits in numerical data to spot potential fraud.
Ribbon – Provides 100+ audit-specific commands to perform tasks such as duplicate detection, joins, gap detection and Benford’s Law tests. 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: 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. Tech Tip: 5 Avenues for Importing Data into IDEA. It offers a multitude of features to ease navigation and put commonly-used audit commands within reach. You don’t need to be a data scientist or programmer to navigate its powerful functionality. With its Window’s-based user interface, IDEA is instantly familiar. Individually select records to extract for more in-depth reviewĬomply 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. Save time when importing multiple files of the same type by using the rerun feature XLS extension, beyond just Microsoft OfficeĪutomatic 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
HOW TO USE @WORKDAY IN CASEWARE IDEA SOFTWARE
Use the Open Database Connectivity (ODBC) to import IDEA data from third-party applications such as Tableau, Power BI, MS Excel and many moreĬonvert 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Ĭompatible with any locally-installed spreadsheet software associated with the. 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 Import virtually limitless amounts of data from practically any source.