Cleaning Up "Dirty Data"

Identify inconsistent information; make changes interactively


If you've got a data table where information was entered by hand, you can almost guarantee that there will be inconsistent formatting, incorrect padding, inaccurate data, and other errors.  Kirix Strataâ„¢ enables you to quickly identify formatting issues and just as quickly make edits interactively without needing to rely on SQL statements.  With Strata you can:

  • Access data from local data files or database systems like Oracle or SQL Server
  • Group data together to understand your data parameters
  • Create dynamically calculated fields that interactively update as you type
  • Save tables locally or copy them to an external database
  • Create reports using your newly created calculated fields

Watch a 90-second demonstration



For more on cleaning up dirty data, please watch this tutorial video on calculated fields here.

Try Strata for Free!

It's easy and risk-free; download a free, unrestricted 30 day trial of Strata now! The installation only takes a few minutes, so you can start working with your data immediately.



If you'd like to take a little more time to explore further, we'd suggest you'd take a look at the Strata overview video or check out some other example applications. And, if you have any questions, please just let us know, we're always happy to help.