Open CSV files, HTML tables and RSS feeds directly from the web into structured tables. You can also easily grab local data files from your desktop or connect to database systems like MySQL and Oracle.
Rich Data Environment
Work with your data in a rich environment, designed exactly for this purpose. Sort, filter, and reformat data with a single click. Quickly cut through the clutter of new data sets and gather useful insights.
Data Bookmarks
Bookmark data from the web, local files, and database systems, such as MySQL. Keep your data handy—organize bookmarks in folders on your toolbar and just click one to open a data file.
Built-In Database
Store and manipulate as much data as you like with Strata's built-in relational database. It's built for speed and can handle just about any amount of data—up to 60 billion records per table.
Dynamic Calculations
Create dynamic calculations instantly across a full data set—and see the results as you type. You can reformat your data, extract embedded values, and test and edit regular expressions interactively.
Report Writer
Develop reports directly from web data, local files, or database systems. Quickly flip between pages and template views for an intuitive design experience. Creating a report is as simple as using a spreadsheet.
Data Relationships
Interactively combine data from different files. Just hook them together and then drag and drop columns from one into the other. Compare data between related files and find matching records or differences.
Query Builder
Quickly build standard SQL queries with Strata's intuitive query builder. Query data directly from a database system, such as MySQL and Oracle, and join the results with data from the web.
Group Analyzer
Organize and analyze your data by groups of records. Summarize groups to generate useful statistics, or keep the detail records together to identify duplicates or find a set of groups that meets certain criteria.
Custom Extensions
Strata comes with a data-enabled version of JavaScript with built-in support for SQL and other functions for data manipulation. You can create new custom extensions or plug in existing ones built by the community.