ARBUTUS ANALYZER

Arbutus Analyzer is a powerful data access and analysis solution that auditors, business analysts, and fraud investigators use to access and analyze data quickly and simply. Its robust performance and easy to use features gives you the shortest route to answers in your data

POWERFUL FEATURES

Data Integrity + Profiling

Preserve and verify the integrity of your source data before profiling your data to understand its key attributes

Data Analysis

Built-in analytics that are designed to give you insightful results quickly

Usability

Analyzer is a technology that is friendly for both individual use and team collaboration

Audit Specific

Analyzer has the unique requirements of auditors covered from self-documenting log file to sample selection and more

Advanced

Go beyond what your current tools offer with Analyzer, using advance data analytical capabilities

Multiple data sources

Analyzer makes multiple, disparate data sources into opportunities, not barriers, for audit examination

Data Access

Analyzer can help you access all of your data regardless of where or how it is stored

Performance

Perform millions of operations per second, analyzing huge data sets quickly and efficiently

FEATURES DETAILS

What it is designed to be is the right tool for departments where audit, fraud and business analysis needs to occur within a diverse and changing data environment by users with varied, but valuable skills and experiences. We have listed some, but certainly not all, of Analyzer’s well thought out capabilities in meeting the demanding needs of our users

Data Integrity

  1. Verify

    Verify is to identify data validity errors in your data

  2. Statistics

    Statistics calculate profile statistics such as highest, lowest and range on numeric or date fields

  3. Stratify

    Stratifycount the number of records falling into specified intervals (strata) of numeric or elapsed time field

  4. Classify/Summarize

    Classify/Summarize generate summary data use one or multiple key fields

  5. Read only

    Unlike spreadsheets, your raw data sources cannot be changed when using Analyzer, ensuring the integrity of your analysis

Data Analysis

  1. Age

    Age perform an aging analysis on any appropriate date field

  2. Crosstab

    Used in the same way as a pivot table in Excel, Crosstab creates hyperlinked summary results for easy drive down capabilities

  3. Gap

    Identify any gaps in a sequence of numbers

  4. Duplicates

    Test for a wide range of duplicates from exact to fuzzy

Data Access & Usability

  1. Multiple Data Sources

    Define and access a wide range of data sources including most databases, Excel, PDF’s and XML

  2. Direct Access

    Have live, direct access to databases

  3. Sharing

    From a desktop-only environment, create shared folders that all members of your team can use to shared data sources, scripts and results

  4. Interface

    Analyzer is designed to give you the best interface between your data and the analysis you want to perform

Multiple Data Sources

  1. Join

    An intuitive interface, including a Venn diagram, for bringing together different data sources using a wide range of joins

  2. Relations

    Easily create logical relationships between multiple data sources or recreate the relationships from among different database tables

  3. Compare

    Commonly used to compare files from two different periods of time to identify what fields have changes and/or what records have been added or deleted

  4. Merge/Append

    Used to combine or append data sources of the same structure

Audit Specific

  1. Benford’s Low Analysis

    Easily apply a Benford’s Law analysis to your data file

  2. Sampling

    Generate monetary unit and record samples. Analyzer can also be used to calculate your statistically valid sample size

  3. Self-Documenting Log

    All analysis and results generated by Analyzer are recorded in a read only log file

Advanced

  1. SQL

    Easily Combine the strengths of Analyzer with the unique, powerful capabilities of SQL

  2. Scripting/Precedures

    Create customized, repeatable analytics, both simple and complex using the purpose built analysis language of Arbutus

  3. Functions

    Over 100 functions to support data analysis from categories such as Fuzzy matching, Conversion, Date/time, String, Bit/Char, Financial, Logical and Math

Data Connectors

    Request Trail