Difference between revisions of "Glossary of Explore Analytics Terms"

From Explore Analytics: The Wiki
Jump to navigation Jump to search
Line 2: Line 2:
  
 
A ''chart'' is a [[Glossary of Data Analysis and Visualization Terms#Data Visualization|visualization]] of the data defined by the view.
 
A ''chart'' is a [[Glossary of Data Analysis and Visualization Terms#Data Visualization|visualization]] of the data defined by the view.
 
 
=====Data Source=====
 
 
A ''data source'' is
 
  
 
=====Filter=====
 
=====Filter=====
Line 15: Line 10:
  
 
A ''list'' is a tabular presentation of the data. In a list, each column corresponds to a [[#Table|table]] field and each row corresponds to a table row (record).
 
A ''list'' is a tabular presentation of the data. In a list, each column corresponds to a [[#Table|table]] field and each row corresponds to a table row (record).
 
=====Pivot=====
 
 
A ''pivot'' is
 
  
 
=====Reference=====
 
=====Reference=====
Line 26: Line 17:
 
=====Table=====
 
=====Table=====
  
A ''table'' refers to a data table in a [[#Data Source|data source]]. This normally corresponds to a database table or an equivalent application concept.
+
A ''table'' refers to a data table in a [[Glossary of Data Analysis and Visualization Terms#Data Source|data source]]. This normally corresponds to a database table or an equivalent application concept.
  
 
=====View=====
 
=====View=====
  
A ''view'' in Explore Analytics is a presentation of data in the form of a [[#List|list]], a [[#Pivot|pivot]], or a [[#Chart|chart]]. A view is based on a [[#Table|table]] and can include data from additional tables by following [[#Reference|references]]. The view can include a [[#Filter|filter]] to apply conditions for selecting the rows that are to be included in the view.
+
A ''view'' in Explore Analytics is a presentation of data in the form of a [[#List|list]], a [[Glossary of Data Analysis and Visualization Terms#Pivot|pivot]], or a [[#Chart|chart]]. A view is based on a [[#Table|table]] and can include data from additional tables by following [[#Reference|references]]. The view can include a [[#Filter|filter]] to apply conditions for selecting the rows that are to be included in the view.
  
 
A view can be switches between list, pivot, and chart at any time and although it keeps its settings for all three presentations, it can only be of one of these types at any given point in time.
 
A view can be switches between list, pivot, and chart at any time and although it keeps its settings for all three presentations, it can only be of one of these types at any given point in time.
  
 
Unless explicitly shared or published, a views is only visible to the user who created it.
 
Unless explicitly shared or published, a views is only visible to the user who created it.

Revision as of 03:05, 24 June 2012

Chart

A chart is a visualization of the data defined by the view.

Filter

A filter defines conditions for selecting data to include in the view. You can think of a filter as declaring "select all the rows from the table that meet the following conditions". For example, the filter "hire_date during this year" says that the view will only includes rows in which the hire_date field has a date in the current calendar year.

List

A list is a tabular presentation of the data. In a list, each column corresponds to a table field and each row corresponds to a table row (record).

Reference

A reference is

Table

A table refers to a data table in a data source. This normally corresponds to a database table or an equivalent application concept.

View

A view in Explore Analytics is a presentation of data in the form of a list, a pivot, or a chart. A view is based on a table and can include data from additional tables by following references. The view can include a filter to apply conditions for selecting the rows that are to be included in the view.

A view can be switches between list, pivot, and chart at any time and although it keeps its settings for all three presentations, it can only be of one of these types at any given point in time.

Unless explicitly shared or published, a views is only visible to the user who created it.