...
Datameer's Visual Explorer is an interactive data analysis feature designed to quickly and easily understand your data. With the purchase of Visual Explorer, you can instantly explore up to billions of records with sub-second response times when optimally configured. The data is first displayed visually over different types of charts where you can drill in and add/adjust attributes or aggregations. When the initial data exploration has been completed, the findings are added to a worksheet within your workbook where further analysis can be made. Visual Explorer integrates with Hadoop via YARN working seamlessly on multi-tenant clusters.
| Note |
|---|
Visual Explorer is enabled with the set up of the Runtime Analytics engine. |
| Table of Contents |
|---|
Accessing Visual Explorer
...
The generated previews are based on a sample of the dataset with a minimum of 5% of the total records. The actual charts can look different than the previews as acutal actual charts are generated from the full dataset.
...
The X and Y axis labels identify the columns they represent and if a measurment measurement is being used.
Example: If the Y axis is Number of Records, it is displaying the total number of records for each X axis column.
...
The column that the color legend represnets represents should have a low cardinality. If the column selected has over 14 colors, the colors begin to repeat.
...
The X-axis, Y-axis, an Color conditions can be updated directly from a chart. Click the condition name next to the label to select select a new column to replace the previous column on the chart.
...
- Date type columns have options to sort by bins. (E.g., Year, Quarter, Month,...). The default setting is AUTO. This bin settings selects a bin based on the cardinality of the data.
- Date type columns have the option to sort by accending ascending or decending descending dates.
- All column types have the option to limit the maximum number of bars displayed.
...
- The Y-axis can only be changed to numeric type columns from the worksheet or the total number of records in relation to the X-axis.
- Y-axis workseet worksheet columns have the option to assign the aggregation function used to display the column values (E.g., SUM, COUNT, AVERAGE, MIN, and MAX).
- The option to sort by accending ascending or decending descending values.
Y-axis options for line charts:
- The Y-axis can only be changed to numeric type columns from the worksheet or the total number of records in relation to the X-axis.
- Y-axis workseet worksheet columns have the option to assign the aggregation function used to display the column values (E.g., SUM, COUNT, AVERAGE, MIN, and MAX).
...
- The Color condition can be changed to NONE so this condition isn't displayed on the chart.
- Date type columns have options to sort by bins. (E.g., Year, Quarter, Month,...). The default setting is AUTO. This bin settings selects a bin based on the cardinality of the data.
| Anchor | ||||
|---|---|---|---|---|
|
The data being visalized visualized can be refined by using filters.
The column filter list displays all the columns in the worksheet. Select a column and define which values of that column should be encluded included in the visualization.
Non-case senstiive sensitive strings can be entered into the search bar to located a specific column name.
They data type of the column selected corresponds to a filter type:
- Numberic Numeric - range slider
- Data - range slider with date/time selector
- Boolean - radio buttons
- String -
- Low cardinality - checkbox list
- Medium cardinality - starts/doesn't start with search box
- High cardinality - free text search box
...
From the visual exploration of a bar chart, select the part or parts of the data your are intereted you're interested in further exploring. Next, click on the Drill button.
...
Use the menu on the right side of the screen to zoom in/out by bins or highlight/pan a section on the visualization to zoom or drill into.
...
Create a worksheet at any time during visual exploeration exploration by clicking Create Sheet on the bottom right of the screen.
Summary or Details sheet
As of Datameer 7.4, you can select to create a summary or details worksheet from your visual exploration.
Summary sheet
A sheet with the aggregate summary of your visual exploration. Your summary displays the columns of data you selected during the visual exploration in a worksheet.
Details sheet
A sheet with the detailed dataset from the visual exploration source sheet. Your detailed sheet is the visually explored data with your filters applied to all the underlying detailed data.
Viewing the Inspector of Visual Explorer worksheet
Like all worksheets in a workbook, a sheet inspector is available to give you useful insights into your data.
As of Datameer 7.4
Clicking on the Sheet tab in the inspector of a visual exploration sheet also has a Summary section for both Summary and Details sheet types.
The Summary section displays the following meta data for the sheet:
- The name of the source sheet used.
- A description of the chart configuration used to generate the sheet.
- A description of any exploration filters added from the visual exploration. Workbook filters added from Filtering Data are not displayed in this section.
Return to Visual Explorer from a worksheet
To return to the visual exploreration exploration feature from the worksheet, select View from the menu bar and select Visual Exploration or click the Visual Exploration icon on the toolbar.
...