Analytics »  What is a Table

What is a Table?

Virtutem Analytics stores all your tabular data/datasets in entities called Tables. A table contains a set of columns and actual data rows (similar to a spreadsheet). Each column has a name and a type (data type) associated with it. A table in Virtutem Analytics is identified with this icon ...


A Virtutem Analytics database could contain a collection of tables. Two tables could be related to each other using lookup columns, thus enabling you to model a relational reporting database (Refer Relating tables using Lookup columns ). You can create any type of reports over these tables which contain the actual data.


Type of a column defines the nature of values a column can contain and the operations that can be done over the same. Eg., an Age column could be " Positive Number"   type.This column can contain only positive numbers and you could apply arithmetic operations over the same. Click to read more about the data types supported by Virtutem Analytics .


A database would typically contain one or more tables containing logically related datasets. e.g., a Sales database could contain Products, Sales, Purchase etc., tables. Users are recommended to have logically related datasets stored within the same database, with each distinct dataset stored as a separate table. As mentioned earlier we can also define relationship between two tables using Lookup columns.