Tables

Tables in Analytics Plus pave a way to store, organize and manage all your data/datasets in a structured format. It consists of a set of columns and actual data rows (similar to a spreadsheet), in which each column has a name and a type (data type) associated with it. The data type of the column defines the nature of value a column can hold and the operations performed over the same.

Analytics Plus allows you to create any number of tables in your workspace. You can easily relate different tables (using lookup columns) and create any type of reports over your table data.

In this chapter, we will discuss the following sections:

• Creating a table
• Adding rows and columns
• Adding formulas
• Working with tables
• Relational data modeling
• Joining tables
• Query tables
• Data snapshots