Video Tutorials, Examples, & Demonstrations

Getting Started with Kirix Strata™

Summary: This video offers a short guide to help you get around Strata's controls and tools.  It covers a wide range of areas including projects, tabs, panels, menus and views.
Topics: projects, web browsing, views, editing data, adding records

Opening and Saving Data Sets

Summary: Learn how to work with local data files (e.g., CSV, DBF), connect to external databases (e.g., Oracle, SQL Server), and use Web data (e.g., HTML tables, RSS).
Topics: local data, external databases, converting, exporting

Working with Calculated Fields

Summary: Learn how to use calculated fields for effective analysis.  In part I, learn the basics; in part II, learn to apply functions for more advanced data cleansing.
Topics: calculated fields, functions

Sorting Data

Summary: Learn how to sort fields in a certain order (such as alphabetically or numerically), different sorting options, as well as how to save custom sort orders (indexes).
Topics: sorting, saving indexes

Filtering Data

Summary: Filtering enables you to reduce a data set to a smaller number of records based on some criteria.  Learn how to filter your data with Strata's quick filter and cell-criteria filter as well as with custom formulas.
Topics: quick filter, filter builder, functions

Creating Reports

Summary: Learn how to quickly create reports, similar to how you would with a spreadsheet.  Also learn how to format, add groups and sort orders, switch views, print and save as a PDF file.
Topics: report settings, sorts and groups, report views, formatting, printing

Explore a New Data Table

Summary: When you have some new data, it pays to do a few tests up front to make sure the set is complete and accurate.  This video explores identifying issues using summaries and date range checks.  More »
Topics: summarize, quick find, delete, calculated fields

Using Multiple Databases from a Single Interface

Summary: Different corporate systems run on different databases (e.g., Oracle, MySQL).  Strata enables you to access and work with your data from multiple systems at once from a single interface.  More »
Topics: create connections, filter, marks, reports, copy, sql statements

Cleaning Up Dirty Data

Summary: Data with errors and inconsistent formatting is more common than one would hope.  This video shows how Strata makes it easy to clean up "dirty data" -- in this case phone number formatting.  More »
Topics: calculated fields, functions, grouping

Working With Large Amounts of Data

Summary: Unlike most desktop data tools, Strata does not suffer from row limitations or 2 gigabyte file restrictions.  This video shows multiple processes using a 7 million record file.  More »
Topics: filter, group breaks, calculated fields, marks

Creating Reports Quickly

Summary: Strata makes it really easy to create quick, ad hoc reports.  This video shows how  it's spreadsheet like feel makes it simple to create sophisticated reports in minutes.  More »
Topics: quick report, print preview, template view, groups and sorts

Opening and Using Text-delimited Files (e.g., CSV)

Summary: Text files, such as CSV, TSV, fixed-length, and EBCDIC files, are commonly used to share data.  Strata provides and extremely intuitive tool to open and work with text files.  More »
Topics: open files, table design view, filter, sort, marks, convert data

Converting and Transforming EBCDIC files to ASCII

Summary: EBCDIC is a mainframe format that often needs to be converted before being used in other tools.  Strata makes it really easy to convert EBCDIC tables to ASCII.  More »
Topics: open files, table design view, columns, filter, marks, save

Benford's Law Extension

Summary: Benford's law describes a mathematical phenomenon involving the first digits of numbers and is often used to help identify fraud. This video walks through some examples; please see related post here.
Topics: HTML import, CSV files, sorting, marks

Apache Log Import Extension

Summary: This extension offers an easy way to import Apache web logs and handle all the parsing and data formatting for you.  This video shows how we identified a problem in our logs; please see related post here.
Topics: grouping, sort, web browser, filter, saving data, convert data

Lokad Forecasting Extension

Summary: Lokad is a company that specializes in time-series forecasting algorithms.  The Strata extension works with their Web API to create time-series forecasts with your data; please see related post here.
Topics: opening data, grouping

Kirix Strata 4.0 Tour

Summary: This is the Strata overview demonstration.  It walks though an example of using a file from a database, combining it with data from the Web and then creating a report.
Topics: filter, find, sort, group, calculations, relationships, reports

Kirix Strata 4.0 (beta 7) Feature Review

Summary: This video was a demonstration of the new features included in Kirix Strata 4.0, beta 7.  It includes a look at data bookmarks, quick find and quick filter and the report writer;  please see related post here.
Topics: data bookmarks, quick find, quick filter, report writer

Working with Call Center Data and Graphing It

Summary: This video is from a blog post that looked at combining local call center data with data from the Web and then posting the data file to a website that created a graph; please see related post here.
Topics: calculations, HTML import, relationships, grouping, conversion

Pulling Out Search Strings from Apache Log Files

Summary: We wished to identify what the most popular search terms where from our phpbb forums.  To do this we imported our log files and analyzed the data; please see related post here.
Topics: calculated fields, strpart(), substr(), iif(), contains(), grouping

Kirix Strata 4.0 (beta 1) Overview Video

Summary: This is a demonstration of the original Kirix Strata 4.0 beta version.  It primarily demonstrates how to work with data from the Web, including HTML tables, RSS feeds and CSV files.
Topics: web data, design view, calculations, find, sort, relationships, marks