Feature Summary

Feature
Summary

SuperQuery has features that help you read your data from different data sources, create queries, analyze and mine your data, and organize your analysis.

Feature

Office

Discovery

Visual Query

Wizards
Filters

Index

Automatic
Graphs
Statistics

Wizards -- Open, Analysis, and Update Wizards.
Visual Query Creation -- no programming or SQL required.
Quick Filters
Easy Indexing of your data tables.
Automatically create graphs that shows common values, exceptions, high, and low values
Automatically create Total, Min, Max, Average, etc.. for values in the current column.
Support for table linking. Automatically synchronize related views.

Data Source

Open Microsoft Excel and Access
Open xBASE, Paradox, and Text files directly
Open most databases using ODBC drivers.

Data Analysis

Virtual
Columns

Summary
Tables

Drill Down

Range Virtual Column. Automatically Divide a numerical column into a number of ranges (High, Medium, Low).
Filter Virtual Column. Visually create comprehensive criteria.
Keyword Virtual Column. Easy short cut to extract keywords from description-type columns
Classification Virtual Column. Easy short cut to map values in one or more column(s).
Formula Virtual Column. Visually create calculations.
Create Summaries using more than 20 functions.
Summary tables are normal tables that can be re-analyzed and re-summarized.
Drill Down. Just double click on any summary cell to create a detail view.

Data Mining

Drill Down
Facts

Click one button to start the Fact Discovery Engine.
Find Facts ( rules or patterns ) and Exceptions or Errors.
Report facts in an easy to read " If...then" rules or "All / Most" statements.
Report facts as a Table so that you can re-analyze the Factbase itself.
Drill Down. Double click on any fact or exception to see a view of all supporting data rows.
Advanced options to control the search process.

Organization

Organize your views into tabs.
Create new tabs
Create new tab levels and tabs within tabs