Powerful data management features to provide confidence around data integrity, simplicity in data migration, merging and manipulation.
Create data relationships
Extract to an Arbutus table
Export to other dataset
Join tables using keys
Merge like tables
Compare like tables
Append similar table
Sample size calculation
Add data fields
Add computed fields
Apply conditional records
Analyzer has a range of functions to transform, calculate, estimate and compute numbers, text and categories.
Important tools used by auditors, accountants, business analysts and forensic data analysts.
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.
Add comments to files, tables to help you record your actions. These are very helpful when someone is required to review your analysis.
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.
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.
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.
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:
With Analyzer you can create shared folders for secure management of data for individuals, teams and across the enterprise
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.
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.
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.