|
Data
Analysis Type
|
Description
|
ACLä
|
IDEAä
|
Active
Dataä
for Excel
|
|
|
|
|
|
|
|
Append / Merge
|
Combines two files with identical
fields into a single file. An
example would be to merge two years worth of accounts payable history
into one file.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Audit Log
|
Maintains a documentation log of
all procedures performed on a data file.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Calculated Field/ Functions
|
Created a calculated field (which
can use a function such as ABS for the absolute value of the field)
using data within the file. For
example, the net payroll pay to an employee could be recalculated
using the gross pay field and deducting any withholding/taxes.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Cross Tabulate
|
Cross Tabulate lets you analyze
character fields by setting them in rows and columns. By
cross-tabulating character fields, you can produce various summaries,
explore areas of interest, and accumulate numeric fields.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Digital Analysis
|
Completes digital analysis tests
(i.e., Benford’s Law).
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Duplicates
|
Identifies duplicate items within
a specified field in a file. For
example, this report could be used to identify duplicate billings if
invoices within the sales file.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Export
|
Creates a file in another
software format (e.g., Excel, Word) for testing. An example would be to export customer address information
to Word for “Mail Merge”ing to customer confirmation letters.
|
Ö
|
Ö
|
Ö*
|
|
|
|
|
|
|
|
Extract/Filter
|
Extracts specified items from one
file and copies them to another file, normally using an “if” or
“where” statement. Examples
include extracting all balances over a predefined limit.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Gaps
|
Identifies gaps within a
specified field in a file. For
example, identify any gaps in check sequence.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Index / Sort
|
Sorts a file in ascending or
descending order. An
example would be sorting a file on social security number to see if
any blank or “999999999” numbers exist.
|
Ö
|
Ö
|
Ö*
|
|
|
|
|
|
|
|
Join / Relate
|
Combines specified fields from
two different files into a single file using key fields.
This function is used to create relational databases on key
fields. It can also be
done in an unmatched fashion to identify differences between data
files.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Sample
|
Creates random or monetary unit
samples from a specified population.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Statistics
|
Calculates various statistics on
a selected numeric field.
|
Ö
|
Ö
|
Ö
|
|
|
|
|
|
|
|
Summarize
|
Accumulates numerical values
based on a specified key field. An
example would be summarizing travel and entertainment expense amounts
by employee to identify unusually high payment amounts.
|
Ö
|
Ö
|
Ö
|
