This is an old revision of this page, as edited by Misuo(talk | contribs) at 13:47, 6 July 2012(Initial version.). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.Revision as of 13:47, 6 July 2012 by Misuo(talk | contribs)(Initial version.)
Requires Excel for showing graphs and result of Benford law analysis.
Comparison by analysis features
The following table compares features of specialized computer-aided audit tools. The table has seven fields, as follows:
Product Name: Product's name; sometime includes edition if a certain edition is targeted
Age analysis: Specifies whether the product supports making age analysis (stratification by date).
Benfords law: Specifies whether the product supports finding abnormal distribution of specific digits accordingly to Benfords law.
Calculated field: Specifies whether the product support adding extra calculated fields into the table/file. Usually implies using an expression builder feature to build up expressions for defining the field calculation.
Duplicates: Specifies whether the product supports finding duplicate items within a specific field in a table/file. For example this could be used to find duplicate billings of invoices within the sales ledger.
Duplicates (Fuzzy): Specifies whether the product supports finding duplicate items for a specific field using fuzzy comparison - i.e. values compared are similar but not exactly the same (e.g. using Levenshtein matching).
Drill-down (Table): Specifies whether the product supports drill-down features by table.
Drill-down (Pivot): Specifies whether the product supports drill-down features through pivot table.
Sample (Random): Specifies whether the product supports selecting a random sample of rows from the table/file (population).
Sample (Monetary unit): Specifies whether the product supports selecting a monetary unit sample of rows from the table/field (population). This is also known as dollar-unit sampling (when values are in US currency).
Sequence check (Gap): Specifies whether the product supports can find (identify) gabs (in sequences) for a specific field. For example, finding a broken sequence in an invoice number sequence.
Sort field: Specifies whether the product supports sorting (indexing) by a specific field (column).
Sort multiple fields: Specifies whether the product supports sorting by multiple fields (columns).
Statistics: Specifies whether the product supports calculation and presentation of various statistics on a specific field, e.g. for a numeric fields values such as total number of positive numbers, total number negative numbers, average value (balance), etc.
Stratification: Specifies whether the product supports stratification on number (amount) values in specified intervals.
Total row: Specifies whether the products supports displaying a total row for the table/file, e.g. accumulated numerical value.
Audit log: Specifies whether the product logs activity performed by the user (the auditor) for later reference, e.g. inclusion into audit report.
Data graph: Specifies whether the product provides graphs of results.
Export (Excel): Specifies whether the product support exporting selected rows to an Excel file.
Export to clipboard in CSV format: Specifies whether the product support copying rows of data to the clipboard in comma-separated value format. This provides support for pasting into e.g. spreadsheet applications.
Append/Merge: Specifies whether the product can combine two tables/files with identical fields into a single table/file. For example it could be doing a merge of two years of accounts payable tables/files into a single table/file.
Import wizard: Specifies whether the product provides an import wizard to assist in importing (interpretation, conversion, formatting) data for analysis.
Import from DBF: Specifies whether the product supports import data from dBase DBF files.
Import from Excel: Specifies whether the product supports import data from Microsoft Excel workbook file.
