ADA Windows

Description

Simple. Full-featured. Easy-to-use audit data analytics software.

ADA is audit data analytics software made with auditors’ needs in mind. Check out what ADA has to offer you.

General Features

• Manage and organize your work with individual projects.

• Excel-style functions mean that you can dive right into using functions if you already know Excel.

• Audit Trail keeps track of all of the analytics you perform in each ADA project. Never worry again about proving (or forgetting) the steps you took to get your results.

• Import data from:

  • Text files

  • Excel workbooks

  • PDF reports

The wizards will guide you step by step.

• Want to re-run an analytic? Don’t start over. Do-Over. Fix a mistake you made, or just tweak things. When you get a Do-Over, the last analytic you ran comes up again with all of your previous selections still in place.

• Column Management lets you:

  • delete columns you don’t need

  • add columns you don’t have

  • modify columns that aren’t displaying correctly

• Quick Export data. Choose either Excel or delimited text file.

Data Analytics

• Filter to get just the data you need. Leave out what you don’t.

• Append similar datasets together. Work with all your records at once in a single, convenient file. Use it with Import Wizard templates to streamline your data preparation.

• Join datasets with common columns. For example, join your vendor data to your order data using Vendor ID to display vendor name and address for each order. Match data from disparate systems with Fuzzy Join.

• Duplicates allows you to detect duplicate data for more accurate analysis. And with more possibilities than any other audit data analytics application. Options include:

  • All Unique Records

  • Deduplicate Keep First

  • Deduplicate Keep Last

  • Exact Duplicates

  • Duplicate Difference Unique Values

  • Duplicate Difference First Values

  • Duplicate Difference Last Values

  • Duplicate Difference All Values

  • Duplicate Difference Date Range

  • Fuzzy Duplicates

  Never worry about using special scripts for complex duplicate detection. Avoid reversals in your data. Use Fuzzy Duplicates to find duplicates that don’t quite match exactly. Narrow your search by date range. It’s the most powerful duplicate data detection around.

• Sampling gives you the most accurate projections of integrity errors. No more drawing erroneous conclusions from sample data.

• Sort puts your data in whatever order you need. And it saves the data that way. Easily spot outliers. Or combine the power of Sort with functions and other ADA analytics. Perform date/time analysis and much more.

• Summarize applies aggregate functions to datasets. For each unique value in a key column, get:

  • Totals

  • Averages

  • Min

  • Max

And many more aggregate values. Want to see total sales for each product? Summarize does that. Gain valuable insights into your data as a whole.

• Summary Stats is analysis done for you. Automatically.

  • Get control totals

  • Spot anomalies in your dataset

  • Verify its integrity

It’s all easy to see at a glance.

Want to Know Even More?

Take a look at our ADA White Paper for more details about how ADA audit data analytics software can work for you.

System Requirements

• Windows 7 or higher (64-bit)
• 1GB free hard drive space
• Administrator rights to install

Need Help?

Need help installing or using ADA? Please contact us!