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.