The Trillion-Row Spreadsheet is a browser-based interface that allows you to visually interact with your data. Explore the Trillion-Row Spreadsheet to learn how to use some of the most common user interface elements.
The 1010data Insights Platform gives you several options for interacting with the system and analyzing your data. However, when you first get started, you are likely going to spend most of your time in the Trillion-Row Spreadsheet (TRS). The TRS is a browser-based interface that works similarly to many spreadsheet applications, such as Microsoft Excel. The interface uses many elements with which you may already be familiar, such as folders, navigation icons, and menus.
Throughout this tutorial, the Sales Item Detail table (pub.demo.retail.item) is used to introduce you to the major elements in the TRS.
To explore the Trillion-Row Spreadsheet:
Each time you open a new workspace, the menu bar and Dashboard are displayed on the canvas. The menu allows you to open a TRS window and start exploring ad hoc analysis in the Insights Platform.
A table is the permanent, unchanging version of the data that is saved on the server. When you open a table in the spreadsheet interface and perform an action or query, it becomes a worksheet. A worksheet is a working copy of the table. In worksheets, you can work with and manipulate your data.
In the image above, the red box outlines the Demo folder and its contents. The Retail folder is open and in it is a table titled Sales Item Detail.
Next to the Analyze tab are additional tabs which are used to interact with your data. The table below provides a description of each tab and its available options.
|Analyze||In a new TRS window, this tab displays options for opening common
Insight Platform items such as tables and queries.
After a table is open, the Analyze tab displays the analysis timeline which provides quick access to perform operations like summaries, tabulations, and cross tabulations.
|View||Use this tab to select from among the various ways to view and interact with the data resulting from your analysis.|
|Visualize||Options for creating charts based on your data analysis are available from this tab.|
|Develop||This tab allows you to save your query and provides options to further develop your analysis. For example, you can clone the TRS window and explore different scenarios without losing your original query.|
|Export||You can save the results of your analysis in a variety of file types, such as CSV and Microsoft Excel, from this tab.|
TRS sorts the table in descending order based on the Cost column and adds the sort operation to step 2 in the analysis timeline.
After you perform an operation in either the table or in the timeline, the operation is listed in the timeline.
At this point, the table becomes a worksheet because an action was performed on the table.
Scroll bars, similar to the ones outlined in red in the image above, appear on the right side of the worksheet if the screen cannot accommodate all of the rows and on the bottom of the worksheet if the screen cannot accommodate all of the columns. The scroll bar in the results pane allows you to navigate through the data in your worksheet.
For the purposes of this tutorial, a very small data set was created to illustrate the concepts in this topic. In this case, you can scroll through the data in just a few seconds. However, your tables may contain billions of rows. As you work with the TRS, keep in mind that scrolling may not be the most effective way to get to a particular section of data. For that, a better method is to perform a row selection, which is covered in Select rows.
The New operation step allows you to add an additional operation to the timeline.
Now that you have another step in which to perform an operation, you can arrange the columns in the worksheet.
The Columns section shows the columns that are currently visible in your worksheet, in the order they are displayed left to right. The Hidden section shows any additional columns contained in your worksheet that are not currently displayed. Using this panel, you can rearrange and hide columns in your worksheet.
Next, hide the Cost column in the worksheet. While you could do this by performing another arrange operation on a new line, you will instead edit the existing Arrange columns operation in step 3 of the timeline.
For more information about the TRS interface, see Trillion-Row Spreadsheet in the 1010data Insights Platform User's Guide.