Kirix Strata Video Tutorials, Examples and Demonstrations

Video Tutorials, Examples, & Demonstrations

Table of Contents

Click on one of the links below to skip to the section you are interested in:

Tutorials

These videos provide instructions how to use specific features:


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

Examples and Demonstrations

These videos show different ways to use Kirix Strata for various applications:


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

Extensions

These videos explain how to apply different Kirix Strata extensions to certain issues:


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

Other Videos

This is an archive of additional videos and screencasts, including demos of the Strata 4.0 beta version as well as videos relating to specific posts to our Kirix Blog (Data and the Web) or our Strata Tips & Tricks Blog.


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