A new application 
for data mining and analytics

Ariel Sepulveda, PhD.

Pronto Analytics, Inc.
ariel.sepulveda@prontoanalytics.com
www.prontoanalytics.com

This presentation is about MXL Plus: a data analysis software designed to be simple-to-use, powerful and flexible.

Among the most significant characteristics of the software are:

1.	Highly intuitive user interface.  
 2.	No software limits on dataset size.
 3.	Powerful number cruncher with an embeded user friendly spreadsheet.
 4.	Analyzes datasets of numbers, strings, graphics, symbols, etc.  (e.g. simple text mining capabilities)
 5.	Highly efficient on categorical data analysis.
 6.	Import data and merge many datasets by combining any of the following: databases, xls, csv, txt, etc.
 7.	Exports output to csv, xls, gif, Metafile, etc.
 8.       Productivity feature 1: modify and query data with spreadsheets and analyze with GUI objects.
 9.       Productivity feature 2: create and save analysis templates for future use on different datasets.
10.      Productivity feature 3: create and schedule many tasks for automated data transformation, analysis, and reports.

MXL Plus is designed to complement Mathematica with the best data manipulation and analysis capabilities found in spreadsheets and database languages.

A data importing interface

For uploading data or merge datasets from many data sources : databases, Excel, text files, etc.

A spreadsheet-like tool

For data visualization and manipulation (calculate new fields, summarize data, query data, sort, etc.).

Several analytics applications

Where you can calculate and plot data summaries as defined by levels of the selected categorical variables.

A report scheduler

Where you can setup tasks to produce real-time or other scheduled reports.

Data importing

Read data from several data sources

Data importing

View Data

Data importing

Basic data assessment

Data importing

Advanced data assessment

Data importing

Merging datasets from different sources: define and load datasets

Merging datasets: define primary keys and join datasets.

Basic Spreadsheet

The Basic Spreadsheet allows for data transformation by adding new fields, summaries, and queries.

Queries: note that new fields are ready for GUI based queries

Advanced Spreadsheet

This spreadsheet can use two source datasets

Add new summaries to those in the Basic Spreadsheet

Note that summaries can be dynamically controlled objects, graphics, text, etc.

After defining new equations, data and summaries can be grouped by categoriacl variables

Display summaries only and query summaries using a GUI query editor

Hierarchical Viewpoints

By-cliks Analytics: Pareto of best two products (excluding InkJet), then best two towns.

By-cliks Analytics: Sales distribution for the former analysis is automatically generated.

Note: Your setup can be stored as a template for future use on different datasets!

By-cliks Analytics: Sales percentage distribution is also available.

Hierarchical Viewpoints

Crosstabs of Viewpoints by one or more categories

Hierarchical Viewpoints

Productivity features:

Modify data with the spreadsheets and analyze results on the fly!
When all setup icons are set and analysis is as desired, save spreadsheet templates and Viewpoints templates for future use!

Exploratory Viewpoints

Explore one or more fields by selected levels of one or more categorical variables

Tooltips on boxplots for a deeper view.

Exploratory Viewpoints

Many exploratory viewpoints are available for understanding data.

Exploratory Viewpoints

One-click Statistical Process Control used for Exploratory Data Analysis

Compare distinct SPC techniques

Relational Viewpoints

Select source data, target fields, and group-by fields

Select data type: ordered (a-b is different than b-a), distinct elements only, etc.

Relational Viewpoints

Customize analysis (MBA stands for market basket analysis)

Customize analysis: scope to emphasize on some nodes

SpreadsheetViewMXL

SpreadsheetViewMXL is a Dynamic Module and a main component of MXL Plus

Use spreadsheetViewMXL to view your data, modify it, find patterns, etc.

data//SpreadsheetViewMXL

SpreadsheetViewMXL has several editing and formatting options

Revolutionary  Dynamic Reports

Productivity features: Schedule any data transformation, analysis or reporting task!

Recall that reports don't need to be static, but you can create dynamically controllable reports using TabViews, PopupMenu, Manipulate, ect... like the demonstrations at www.wolfram.com!

MXL Plus...

Will soon be available at www.wolfram.com and www.prontoanalytics.com

Contact us for more details.  Send us an email at postmaster@prontoanalytics.com