Comparing data from files and queries has never been easier
For those who don't need to be a "tech-savvy"
Don't drown under hours of tutorials, spreadsheets and formulas that will be good for only ONE time,
let the clicks do the work and compare A and B without learning how to code!
For the data rock stars
If any of these situations prevents you to spend your time on things that require your actual talent,
then this is the software for you (disclaimer, reading the list can cause pain):
Reports migration, data differences between stages, data mismatch, "Row count match but numbers don't", "this query works different in this other Engine/DB", "001 <> 1" (or vice versa), find missing data, "that report was different X days ago", "I have to compare this again", etc.
Photo by Glenn Carstens-Peters on Unsplash
Heal the "Data Flu"
You don't have to be high "tech-savvy" to get to know that validating data of any kind or a new report or a new version of it will take time and in the worst cases finishing is a painful process that brings, headaches and slow the rest of your process bandwidth, just like a flu.
These days as data people we face environments where every company have data stored in multiple database engines, coming from different systems with different architectures and creating reports have the unavoidable phase of data validation, this along with other situation such as the scary migration to a new database engine or system bring pain points to anyone making sure we have reliable data to work with.
JuxtAPPose born with the firm purpose of making data comparison as easy as possible keeping in mind that reliable data is not just row counts, totals or tables, but all values coming from spreadsheets and database queries and make the "data flu" go away as fast as possible with not new surprises after deployments.