Kirix Strata Blog

It's been almost one year since we released the beta version of Kirix Strata to the public. During that beta cycle, we provided several videos and screencasts via our blog to emphasize different things the software could do.

Thankfully, even though the videos show the beta version in action, almost all of the content is extremely relevant for the final version of Strata as well. The only variance really has to do with the user interface; we ended up moving around icons and toolbars and menu items quite a bit until we got something that seemed to work best. Oh, and you may see the original Strata logo that we threw together for the beta.

So, maybe you can consider this blog post your Tivo or on-demand video page for “Season 1″ of Kirix Strata. Here are the five links, with details and highlights of each one below:

• Access and Manipulate Data from the Web
• Identify Embedded Search Terms within Apache Web Logs
• Manipulate Call Center Data and Create a Mapping Visualization
• Features Overview: Data Bookmarks, Quick Find & Quick Filter and Report Writer
• Combine Table from MySQL Database and HTML Table from the Web, then Create a Report

(more…)

If you have text entry forms on your website, you probably have data with duplicate email addresses. These duplicates can either be from data entered twice into the same form or are duplicates from merging data from multiple applications/forms.

So, two questions arise:

1. How do you identify these duplicates?
2. How do you either remove them or group them together to track the related information?

Using Kirix Strata's grouping functionality, it's actually pretty easy. You can quickly identify duplicates from your website data and then either remove the duplicates or consolidate the different records into groups of related records. Let's look at the problem more closely.

Suppose you have a web page that asks your visitors for the following feedback information:

Visitors will enter their information, including their email address, which allows you to respond to them. However, if the visitor stops by again in the future, you'll have multiple records from the same person and therefore duplicated email addresses:

(more…)