Video Tutorial Library

Home   Back  


Tutorial Videos


These videos provide instructions how to use specific features:


Getting Started: 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.
Opening and Saving Data Sets:  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).
Working with Calculated Fields: 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.
Sorting Data: 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).
Filtering Data: 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.
Creating Reports: 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 examples and software applications:


Software Overview:  This is an 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.
Explore a New Data Table:  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.
Using Multiple Databases from a Single Interface:  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.
Cleaning up Dirty Data:  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.
Working with Large Amounts of Data:  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.
Creating Reports Quickly: 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.
Opening and Using Text-delimited Files (e.g., CSV):  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.
Converting and Transforming EBCDIC files to ASCII:  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.



NOTE:  To view these video tutorials and examples, you must have an internet connection available.  For an up-to-date library, please visit our online video archive page here.