Data Explorer is a tool that displays detailed and summary information about databases, tables, and fields. To access Data Explorer, choose Explore. Then, drag a segment from Data Tree or Scratchpad, and drop it in Record View.
Depending on the selection you make, different views are available, as shown in Table 2‑4.
Table 2‑4 Data Explorer views for data selection types
Selection type
Available Data Explorer view
Database
Summary
Table
Record, Summary
Unindexed field
Record, Summary
Indexed textual field
Record, Summary, Discrete Values, Chart
Indexed numeric field
Record, Summary, Discrete Values, Chart, Statistics, Frequency
Data Explorer supports exporting data to other applications, such as Microsoft Excel.
To remove data from Data Explorer, choose Clear.
About Record View
Record View displays the records in the table you are exploring or the table that contains the field you are exploring. For example, when you explore the Customers table you see 50 of the 259,874 records. You can browse the pages into which the records are divided by using the arrows on the pagination bar. You can navigate to a specific page by typing the page number and pressing Enter. You can select the fields you want to view using the column selector icon in the upper‑right corner.
About Summary
Summary displays information about the database, table, or field you are exploring.
For a database, Summary displays the name of the database; the tables in the database; and the number of rows, columns, and cells in each table.
For a table, Summary displays the name of the table; the number of rows, columns, and cells it contains; the other database tables to which it is joined; and the information about each field in the table, such as data type, number of discrete values, and whether or not the column is indexed.
For a field, Summary displays the name of the field; the table that contains it; and the other information, such as data type, number of discrete values, and whether or not the column is indexed.
To export the contents of the Summary tab to an RTF file, choose the export icon in the upper‑right corner. RTF format is compatible with Microsoft Word.
About Discrete Values
Discrete Values shows the categories contained in a column, the number of occurrences or records for each category, and the percentage for each category. To export the contents of Discrete Values to a CSV file, choose Export. CSV format is compatible with Microsoft Excel and text editors, such as Ultraedit and Notepad++.
About Chart
Chart displays a graphical representation of the records of categories in a database column. The values are ordered from most frequently occurring to least frequently occurring. The following chart types are supported:
Columns 3D (default)
Areas
Bars
Columns
Doughnut
Doughnut 3D
Lines
Pie
Pie 3D
To change the chart type, use the chart icon in the upper right corner. To export a chart to a JPG file, choose the export icon.
About Statistics
Statistics displays the following information in a tabular format for numeric fields.
Table 2‑5 Information provided for a numeric field
Column name
Value displayed
Count
Total number of non-discrete values in the field.
Kurtosis
A measure of the distribution of values, or peakedness. The value varies between -0.5 and 0.5. The Kurtosis coefficient indicates how sharp a distribution is, relative to a standard normal distribution.
Maximum
Largest value in the field.
Mean
Arithmetic average of all non-discrete values in the field.
Median
Value for which there are an equal number of larger values and smaller values in the field.
Minimum
Lowest value in the field.
Mode
The most frequently occurring value in the field.
Skewness
A measure of symmetry that varies between -0.5 and 0.5. If skewness is negative, the distribution is skewed to the left. If skewness is positive, the distribution is skewed to the right.
Standard deviation
A measure of how much variation or dispersion there is from the mean. A low standard deviation indicates that the data points tend to be very close to the mean. A high standard deviation indicates that the data points are spread over a large range of values.
Sum
The sum of all the values in the field.
Sum of squares
The sum of all the squared values.
To export the contents of the Statistics tab to an RTF file, choose the export icon in the upper‑right corner. RTF format is compatible with Microsoft Word.
About Frequency
Frequency displays a graphical representation of the number of occurrences of values in a database column. The values are in ascending order. The following chart types are supported:
Areas (default)
Bars
Columns
Columns 3D
Lines
To change the chart type, use the chart icon in the upper‑right corner. To export a chart to a JPG file, choose the export icon.
Exploring views of a database
Data Explorer supports viewing different levels of a database, depending on the level of data you choose to view. For example, you can choose a database to view summary information for that database. You can choose a column in a database table to view records, discrete values, a chart of values, or summary information about the column.
How to view a database summary
1 Drag a database from My Data and drop it in Data Explorer.
2 Examine the information appearing on Summary, as shown in Figure 2‑7.
Figure 2‑7 Viewing a database summary in Data Explorer
How to view a database table
1 From a database appearing in My Data, drag a table and drop it in Data Explorer.
2 Examine the information on Record View and Summary, as shown in Figure 2‑8.
Figure 2‑8 Viewing records from a table in Data Explorer
How to view a database column
1 From a database table appearing in My Data, drag a column and drop it in Data Explorer.
2 Examine the information in Record View, Summary, Discrete Values, and Chart, as shown in Figure 2‑9.
Figure 2‑9 Viewing a database column using a chart in Data Explorer
Filtering views of a database
You can filter the view of a table or column appearing in Data Explorer using segments. Adding a segment to the view of a table or column limits the number of records shown to only those records having a value that matches the segment.
How to filter a database view using a segment
1 Drag a column from My Data and drop it in Data Explorer.
2 Select Discrete Values.
3 Drag a row in Discrete Values and drop it in Scratchpad. For example, from the Age Numeric column, drag Age Numeric EQ 25 under. A segment appears in Scratchpad.
4 In Data Explorer, select Record View.
5 Drag one or multiple segments from Scratchpad and drop the segments in Drag a segment. A view of data, filtered by the selected segment, appears in Data Explorer.
Columns 3D (default)
