Arbutus Analyzer

Connect to and import from many different data sources

Import from:

  • ACL
  • Delimited
  • dBASE
  • Excel
  • IDEA
  • JSON
  • ODBC
  • PDF
  • Print image (report) file
  • SAP Private File Format
  • Text files
  • XML

Connect to:

  • AS400/DB400
  • Mainframe (COBOL Copybooks, DB2, Easytrieve, Flat, IMS, and VSAM)
  • SAP
  • Web-based data
  • SQL Server
  • Active Directory
  • MySQL
  • MongoDB
  • Google BigQuery
  • Apache HBase
  • Apache Cassandra
  • Amazon Redshift
  • DynamoDB
  • PossequencetgreSQL
  • Apache Hive
  • Microsoft Exchange
  • Salesforce
  • Apache Spark
  • ServiceNow
  • CouchBase
  • Email
  • Splunk
  • Microsoft Dynamic
  • Quickbooks
  • Xero
  • NetSuite
  • Jira
  • Concur
  • Rest

Data management

Powerful data management features to provide confidence around data integrity, simplicity in data migration, merging and manipulation.

Data management features include:

Create data relationships

Report

Extract to an Arbutus table

Export to other dataset

Sort tables

Index tables

Join tables using keys

Merge like tables

Compare like tables

Append similar table

Sample

Evaluate

Sample size calculation

Add data fields

Add computed fields

Apply conditional records

Analysis

Analytical techniques relied upon by auditors, business analysts and forensic scientists.

  • Verify: Confirm the integrity of your data with the verify command.
  • Count: Obtain record counts.
  • Total: Cast, Foot, Sum. Qiuckly obtain a total on a field.
  • Statistics: Summary statistics on selected fields, including count, total, average, highest and lowest values.
  • Profile: Totals on fields, minimums and maximums.
  • Summarise: Generate record counts and numeric field value totals distinct values character, numeric or date fields in a sorted file.
  • Stratify: Count and total records within certain strata.
  • Classify: Count and total records on unsorted files with mulitple classes or categories of data.
  • Age: Assess the age of transactions as at today or a certain date.
  • Cross tabulate: Analyze by producing rows and column summaries of data.
  • Predict: Using Benford's Law to predict and compare frequency of leading digits.
  • Sequence: Determine if the file in is the right order.
  • Gaps: Determine if the file has any gaps in its order.
  • Duplicates: Identify duplicate transactions based on single or multiple records.

Functions

Analyzer has a range of functions to transform, calculate, estimate and compute numbers, text and categories.

Bit / character
Conversion
Date and time
Financial
Fuzzy search
Logical
Mathematical
Miscellaneous
String

Tools

Important tools used by auditors, accountants, business analysts and forensic data analysts.

Logging

The Arbutus Analyzer log file records all actions performed in Analyzer. It is a read only log, with entries unable to be edited. This is very important for auditors and forensic researchers. It gives users assurance that the actions performed are reported.

Comments

Add comments to files, tables to help you record your actions. These are very helpful when someone is required to review your analysis.

Random number generator

The Arbutus random number generator allows you to create random numbers. The ability to use a seed ensures that each time you re-run the analysis using the same seed then the same random number will be generated.

Procedures

Create procedures of multiple commands to run on demand or on schedule. Save time and money by re-using procedures and sharing procedures between your team or out to other auditors you know and trust.

Global search

The Arbutus Analyzer Global Search is a powerful tool to find any text across the table, regardless of the field in which the text occurs.

SmartApps

The Arbutus Analyzer comes with more than 60 already built, ready to use SmartApps designed to help auditors perform computer aided audit techniques on their data. Just import or connect your data and you can start using these SmartApps. The apps step you through the data structure and then perform the analysis. The SmartApps are available for:

  • Accounts payable
  • Accounts receivable
  • Fixed assets
  • Fraud compliance
  • General ledger
  • Inventory

Teaming in Analyzer

With Analyzer you can create shared folders for secure management of data for individuals, teams and across the enterprise

Normalisation

With the Arbutus Normalise function users can quickly clean data to improve search results, achieve better comparisons, and identify duplicates not otherwise identified.

If you have ever tried to analyse data were street addresses are recorded inconsistently or found that Dave is the same person as David, then Normalize can help you.

Multi-line record layouts

System generated reports can span multiple rows as data is squeezed to fit onto an A4 page. This results in data having a header record and a detailed record. In Arbutus Analyzer you can control the import process so that the header and detailed records are correclty interpreted and imported.

Big datasets - no problem

Arbutus loves big datasets. It was designed to handle large files. There is no upper limit on the number of records that can be imported, except those imposed by your computer.

Arbutus 6.3: Arbutus continues to expand the functionality our user community relies on, while optimizing performance and simplifying the user experience.