You’ve probably seen the movie ‘Groundhog Day’ when Bill Murray awakens only to re-live the same day over-and-over again. This is how we’ve been feeling over the years when clients send us data. We use the same techniques, same algorithms and same approach to clean poor-quality data.
(Oh, if you’ve ever wondered what Groundhog Day is, then check out the quaint story on Wikipedia, https://en.wikipedia.org/wiki/Groundhog_Day )
In the end, we got a little tired of repeating the same process by creating the same routines in SQL or writing the same code, so we decided to write a tool that did everything we wanted with a single click.
We wanted to instantly know the state of our data, we wanted to know where the bad data was, we wanted to find all the problems and we wanted the answers quickly.
That’s when we came up with the idea of Acuate Profiler. A tool that delivers the above requirements.
It became so successful within the company that we use it for every project, not only to analyse incoming data but also as a quality control tool to analyse out-going data.
We’ve now decided to offer the product to everyone else. If you want to see the product without signing-up, send me an email ([email protected]) and I can direct you to a pre-recorded demo. Otherwise you can find information here http://acuate.com/dataprofiler
The product has seven profiling tools to assist in finding data problems.
- Profiling Rules
- Character Analysis
- Interactive Analysis
- Word Analysis
- Value Analysis
- Same Analysis
- Sparse Analysis
The first three are mentioned here, but the online demo is the best place to appreciate the benefits it can deliver
Profiling Rules
Apply over 50 built-in rules to identify common format data problems and domain data problems
Character Analysis
Find the distribution of all characters from standard ASCII, diacritics, non-Latin, Cyrillic, symbols, invisible characters, etc.
Interactive Analysis
Point and click to search a variety of charts, then drill-down to targeted data to see the data
Watch a Pre-Recorded Demo
