Quantitative Data Mining Tools

1
Quantitative Data Mining Tools
Shannon Adams Katrina Thomas Visa Metcalf

• MIS 4093-Team 9B
• October 31, 2002

2
DiamondDiamond is a quantitative
visualization package that was developed by the
Exploratory Visualization Group at IBM research
and is currently licensed to SPSS for
distribution.
3
Formatting and Loading Data in Diamond

• The basic layout is to put variables denoted by
  titles in columns with corresponding values for
  each case in rows.
• The maximum size of any cell is 20 characters.
• The worksheet is very simple in its construction
  and usage because it simply requires you to
  specify the titles of the columns followed by
  rows of values separated by blanks or tabs.

4
Data Manipulation Functions Supported by Diamond

• Casewise
• Color
• Distribution
• Miscellaneous
• Missing Value
• Ordering

• Periodic
• Primitive Arithmetic
• Statistical
• Tessellating
• Transforming
• Unique

5
Figure 9.12
6
Figure 9.13
7
Figure 9.14
8
Figure 9.15
9
Figure 9.16
10
CrossGraphs

• CrossGraphs is perhaps one of the most flexible
  commercial data visualization systems available
  for performing multidimensional quantitative
  analyses.
• The system was originally developed for the
  government for use in clinical cancer research
  studies.

11
Platform Support and Development Environment of
CrossGraphs

• The CrossGraphs system configuration is supported
  on a variety of platforms including UNIX, NT,
  PowerPC MacIntosh, and Windows configurations,
• CrossGraphs is written in CG, which is a
  Belmont defined programming language similar to
  Java.

12
Importing and Processing the Data in CrossGraphs

• CrossGraphs has a variety of data access methods
  that can be used to couple to data sources.
• It is ODBC compliant and also has special
  interfaces for SAS data sets, ASCII files, and
  dBase which makes transferring data to
  CrossGraphs a fairly straight forward process in
  most cases.

13
CrossGraph Design Window
14
Generating Graphical Displays in CrossGraphs

• There are a number of ways to generate a design
  in CrossGraphs they include
• Box Plots Graphs
• Contingency Tables Graphs
• Counts Graphs
• Delta Graphs
• Histogram Graphs

15
Sample set of Box Plots created within CrossGraphs
16
Example of a Contingency Table Graph in
CrossGraphs
17
Several different Counts Graphs produced by
CrossGraphs
18
Set of CrossGraphs Delta Graphs
19
Histograms in CrossGraphs
20
Picket Fences in CrossGraphs
21
Scatter Plots in CrossGraphs
22
Spatial Maps in CrossGraphs
23
Statistics Graphs in CrossGraphs
24
Survival Curves in CrossGraphs
25
Timeline Summaries in CrossGraphs
26
Trend Graphs in CrossGraphs
27
Other Quantitative Visualization Systems

• Graf-FX

28
Features supported by Graf-FX

• You can drill-down on any table or query and
  display it either through group or
  pivot/crosstabs tables.
• Graf-FX is a good after market add-on to the
  Access environment because it makes the data come
  alive and allows the analyst to interact with the
  data set.
• You can view the SQL statements or save the query
  from any one of the drill-down exercises.

29
Other Quantitative Visualization Systems (contd)

• Temple MVV

30
Shannons QuestionWhat are the basic rules
for formatting and loading data in diamond?
31
KaTrinas Qusestion

• What is a TableTrans?

32
Visas Question

• What are several features supported by Graf-Fx
  that are useful during a data mining analysis?