Compare

Smart, Simple and Fast Data Comparisons

Compare is a secure, fast and easy-to-use desktop application to rapidly compare .csv and other comma delimited files to find differences between datasets.

A simple user interface sits on top of a powerful data processing engine capable of comparing millions of records in minutes.

Enterprises can have dozens or hundreds of datasets that need to be analyzed and validated whenever systems, processes, or populations change. Dataset analysis can be a tedious and repetitive job, even when using advanced Excel functions.

Compare automates the job of comparing datasets, and transforms this work into four easy steps:

1. Select two comma delimited files to compare (such as .CSV files). Each file must have headers which are identical to each other.

2. Select the key field(s) that define unique records.

3. Select output options and click start.

4. Compare differences between files using Excel.

Compare files in four easy steps

For more information on Compare and help to get started

Compare eliminates hours of tedious work for anyone who needs to find differences in datasets.

Compare is designed as a simple, easy to use and powerful tool to compare data.

Compare is used by business analysts, data scientists, integration specialists and many other professions to quickly and accurately find the differences between two datasets.

Compare uses familiar and standard comma delimited file input and Excel sheet output.

Compare is secure. All data processing occurs on your local machine. Nothing is ever transmitted or processed in the cloud.

Compare is fast.  Finding the differences between datasets can be slow and tedious, even when using advanced spreadsheet analytic functions.  Compare automatically processes millions of records per minute and outputs the results to Excel, where more analysis can occur.

Compare is powerful.  Large files consisting of hundreds of columns and hundreds of thousands of rows can be processed, limited only by available RAM and disk space.

System requirements: Windows 7 Professional or Windows 10 with 4Gb RAM or greater

IT Professionals

IT professionals use Compare to help with regression testing during system upgrades. When applications are modified, reconfigured, upgraded, or replaced, Compare can save hours of time during testing to confirm system output is the same before and after any change.

Simply take a “known-good” output file and compare it to a file generated by the changed system.  Compare will flag any differences between the files in minutes.

Business Analysts

Business Analysts use Compare to quickly analyze datasets to find anomalies. Cleaning datasets that have gotten out of sync is easier and faster using Compare. Differences can quickly be tagged for further review and correction or accepted as is.

The output is in Excel format and can include both the original datasets plus a rich comparison sheet to conveniently conduct more analysis if required. 

Data Scientists

Data scientists use Compare to quickly determine differences between datasets.  Data scientists typically have many analytical tools at their disposal, but Compare is the simplest and fastest way to look for quickly find differences between data files.

Quality Assurance Professionals

Compare can help QA professionals quickly analyze datasets to pinpoint quality issues or anomalies.  Whether you’re looking for temporal changes, piece-to-piece changes, within piece changes or population to population changes, Compare will help you quickly discover potential quality problems.

The original data plus the compared result is always output as an excel file for further analysis and investigation.

Data Migration Specialists

Data Migration Specialists move data between internal and external systems. Compare lets Data Migration Specialists compare data loads from different times or systems to ensure differences are understood and bad data doesn’t inadvertently pollute systems.

Differences can easily be flagged in the output file for further investigation or acceptance.

Developers

Enterprise Systems Developers use Compare to determine if their code is delivering the output they expect. Compare is a simple tool to use while doing unit tests to validate that output of systems in development matches legacy code and business requirements.

Engineers, Researchers, and many more professions

Engineers, Researchers and many more professionals use Compare as a simple and fast tool to help them analyze data quickly.  Compare saves time and eliminates tedium, regardless of the type of data.

Any datasets that can be saved as CSV files can be analyzed using Compare.

Compare has greatly reduced the amount of time I need to analyse “before” and “after” files for our semi-annual upgrade testing.  It allows me to quickly focus on where the differences in data are and easily code them as “explainable” or “unexplainable”. Lisa

Senior Business Analyst - Retail

© 2019 Dispatch Integration Ltd.