Video Tutorials, Examples, & Demonstrations
Table of Contents
Click on one of the links below to skip to the section you are interested in:
- Tutorial Videos
- Examples and Demonstrations
- Strata Extensions
- Overview Videos and Screencasts from Blog Posts
These videos provide instructions how to use specific features:
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.
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).
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.
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).
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.
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.
Examples and Demonstrations
These videos show different ways to use Kirix Strata for various applications:
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 »
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 »
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 »
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 »
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 »
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 »
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 »
These videos explain how to apply different Kirix Strata extensions to certain issues:
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.
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.
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.
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.
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.
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.
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.
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.
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.