Powerful data analysis features of Arbutus Analyzer
People use different metaphors to describe Analyzer. Some call it a “Swiss army knife” because it can be used for so many things. Some describe it as a “toolbox” full of data analysis tools. 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 capabilities in meeting the demanding needs of our users.
Data Integrity + Profiling
used to identify data validity errors in your data
calculate profile statistics such as highest, lowest and range on numeric or date fields
count the number of records falling into specified intervals (strata) of numeric or elapsed time field
- Classify / Summarize
generate summary data use one or multiple key fields
- Read only
unlike spreadsheets, your raw data sources cannot be changed when using Analyzer, ensuring the integrity of your analysis
perform an aging analysis on any appropriate date field
used in the same way as a pivot table in Excel, Crosstab creates hyperlinked summary results for easy drive down capabilities
identify any gaps in a sequence of numbers
test for a wide range of duplicates from exact to fuzzy
from a desktop-only environment, create shared folders that all members of your team can use to shared data sources, scripts and results
Analyzer is designed to give you the best interface between your data and the analysis you want to perform
easily apply a Benford’s Law analysis to your data file
generate monetary unit and record samples. Analyzer can also be used to calculate your statistically valid sample size
- Self-documenting log
all analysis and results generated by Analyzer are recorded in a read only log file
Multiple data sources
an intuitive interface, including a Venn diagram, for bringing together different data sources using a wide range of joins
easily create logical relationships between multiple data sources or recreate the relationships from among different database tables
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
execute the advanced join capabilities of SQL from within Analyzer
- Merge / Append
used to combine or append data sources of the same structure
easily Combine the strengths of Analyzer with the unique, powerful capabilities of SQL
- Scripting / Procedures
create customized, repeatable analytics, both simple and complex using the purpose built analysis language of Arbutus
over 100 functions to support data analysis from categories such as Fuzzy matching, Conversion, Date/time, String, Bit/Char, Financial, Logical and Math
- Multiple Data Sources
define and access a wide range of data sources including most databases, Excel, PDF’s and XML
- Direct Access
have live, direct access to databases
Wish to try out Arbutus Analyzer yourself ?
Well, what are you waiting for?
Request your Arbutus Analyzer trial license right now.
When your request has been approved, you will receive a temporary license for Arbutus Analyzer. This evaluation license enables you to use the software to its full capability. Limited only in time, the software has no limits in terms of functionality, number of projects or file/data size. So what are you waiting for?