Workbook Tab User Interface

INFO

The Workbook tab is Datameer X's User Interface for showing, managing and preparing data within a workbook.

Overview

NumberNameFunctionality
1Datameer X tab
  • opens the Datameer X web homepage
2Workbook Icon bar
  • displays all available icons for workbooks
3File Browser tab
  • navigates back to the File Browser
4Menu bar
  • lists all menu tabs for the Workbook tab
5'Add' button
  • quick start to add workbooks, connections, etc.
6Workbook tab
  • displays the content of an opened workbook
7Workbook Inspector
  • lists all information and managing options for a workbook
8Date and time information
  • displays the current date and time information
9Tab navigation
  • option to switch between all open tabs in the tab bar
10Sheet 'Add' button
  • adds a new sheet within a workbook
11Sheet tab
  • lists all sheets in a workbook, e.g. formula sheet, data mining sheet, etc. depending on the
12Initial sheet tab
  • initial workbook sheet
13Sheet navigation
  • option to switch between all open sheets of a workbook
14Table
  • contains workbook content

Workbook Menu Bar

NumberNameFunctionality
1Datameer

  • account settings
  • Datameer X version information
  • logout
2File

  • creating a new workbook
  • open an existing workbook
  • add data to a workbook
  • exchange data
  • saving and duplicating a workbook
  • running a workbook
  • show details and browse all data
  • configure a workbook
  • close a workbook
3Edit

  • undo and redo an action
  • filter, sort, join and union data
  • partition data and deduplicate
  • pivot sheet
  • split and encode columns
4Sheets

  • add and duplicate a sheet
  • add a SQL sheet
  • view the latest sheets
5Smart Analytics

  • executing Smart Analytics functions, e.g. decision tree, recommendations, etc.
6View

  • view the job graph
  • flip the sheet
  • show th dependencies graph
  • go to a line or jump to column or sheet
  • toggle columns
  • Visual Explorer
  • display the Workbook Inspector and/ or the 'Admin' tab
7Help

  • link to user documentation
  • link to community
  • link to feedback

Workbook Icon Bar

NumberNameFunctionality
1Add Data
  • add data
2Save
  • save the data
3Run
  • run the workbook
4Browse All Data
  • browse all data
5Undo
  • undo the last action
6Redo
  • redo the last user action
7Filter
  • filter data
8Sort
  • sort data
9Join
  • join data
10Union
  • union data
11Partition
  • partition data
12Deduplicate
  • deduplicate data
13Pivot
  • create a pivot table
14Split Column
  • split the column
15Encode Column
  • encode the column
16Job Graph
  • show the job graph
17Flip Sheet
  • flip the sheet
18Dependency Graph
  • show the dependency graph
19Go to Line
  • go to a specific line
20Jump to Column or Sheet
  • jump to a specific column or a sheet
21Toggle Columns
  • toggle the columns
22Visual Exploration
  • show the Visual Explorer
23Inspector
  • show the Workbook Inspector

Workbook Inspector

INFO

The Workbook Inspector provides information about sheets, columns and formula, depending to the workbook type and content.

NumberNameFunctionality
1'Sheet' tab
  • contains sheet related information
2Sheet type
  • displays the sheet type, e.g. formula sheet
3Columns options
  • displays all sheet columns and corresponding data type
4Sheet description
  • displays a sheet description or option to enter s sheet description
5'Column' type
  • contains column related information
6Column name
  • displays the column name
7Column description
  • displays a column description or option to enter a column description
8Data profile
  • displays data profile with visual information, e.g. rows with values, number of unique data
9'Formula' tab
  • contains all functions that you can apply to a sheet
10Formula search
  • search bar to find appropriate formula for data preparation
11Formula
  • displays all selectable formulas
12Formula description
  • provides information about a formula, e.g. formula syntax, formula description
13Formula settings field
  • displays options to modify and customize the formula
14'Add to Formular' button
  • adds the selected formula to the sheet
15'Browse Columns'
  • browses the columns