Get to all the data.
Connect to text files, spreadsheets, and databases.
Focus on relevant data.
Scan descriptive synopses of datasets you are exploring.
Make data useful.
Transform, scrub, and enrich raw data to fit your needs.
Put data in perspective.
Blend data from multiple sources into one dataset.
Import | Get to all the data.
Good analyses depend upon timely access to diverse data sources. Lyza lets you easily connect directly to the most popular data sources: DB2, MySQL, ODBC, Oracle, PostgreSQL, SQL Server, Sybase, JDBC, text files, log files, Excel, Access and Salesforce. Lyza makes it easy to browse all the tables in a big warehouse, with a quick WYSIWYG Preview feature that shows more than column names; it shows you the actual records in the data source. Your import can filter out records, include/exclude columns, or use sampling. And, Lyza will maintain a library of all your data sources, so one click can refresh any import with up-to-date source data.
Profile | Focus on relevant data.
With so much data available, it’s important to choose the right data before you spend a lot of time on analysis. Lyza provides quick content profiles on any column or set of columns in a data source. It will also analyze the content of any entire dataset, to create a data profile report that can be exported to Excel. Pareto charts, histograms, and correlation charts can be used on data sources to create custom, interactive visual profiles. When used with its Combine features (link to section below), Lyza’s data profiling features can even show you the compatibility of information across silos.
Shape | Make data useful.
Often, the data you need is available – but not in a form or format that’s convenient for analysis. Lyza gives you complete power to transform, scrub, and enrich raw source data into something fit for analysis. Transpose and reorder columns easily. Convert text to numbers to dates, and vice versa. Parse ragged record layouts neatly into columns. Find and remove or replace values, including substrings. Use familiar spreadsheet-like formulas to create new mathematical, financial, or statistical values. Create conditional IF/THEN/ELSE rules applying various shaping procedures. Lyza lets you refine almost any raw data into a valuable analytical base.
Combine | Put data in perspective.
A breakthrough analysis usually (and not coincidentally) requires first breaking through barriers, building bridges across information silos. Before a chart can show Sales by Gender, somebody has to build a bridge between the billing silo and the marketing silo. Lyza makes it easy to join different data sources; just drag-n-drop a connector between the lookup fields. You can even join sources as different as a data warehouse table and a text file. Lyza immediately displays the results of the combination, including match rates between the combined sources. And, by using the
Shape features in Lyza, you can even join apparently incompatible datasets based upon substrings and rules.
