Creating Data Tables with Style Intelligence

InetSoft's dashboarding software, Style Intelligence, allows business users to aggregate data from various queries and multiple data sources into a single, collective data table, allowing information data to be easily and efficiently analyzed.

Creating a Non-Embedded Data Table

Data tables contain information from a single query or data model. They allow information to be presented cleanly, on a grid and make large datasets easier to digest.

Once data is properly inputted in a table, InetSoft's intuitive reporting tools can produce highly interactive visualizations for the user to analyze.

To create a data table in Style Intelligence:

1. Create a new Worksheet by clicking on the 'New Worksheet' button.
   
   
2. Expand the 'Data Source' node, and the 'Orders' node.
   
   

4. Drag one of the following assets from the Asset Repository tree into the Worksheet:
• Query
• Query column
• Data model entity
• Data model attribute
5. Right-click on the table title row and select 'Preview' from the context menu.

Dragging a query column or a data model entity into the Worksheet creates a table with just one column. To create a table containing all of the columns in a selected query or all the elements in a selected entity, drag a full query or data model entity to the Worksheet.

View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.

Creating an Embedded Data Table

Embedded data tables allow users to manually enter values into a Worksheet, rather than retrieve information from a single data model.

With an embedded table, users can utilize multiple data sources to create more diverse and interactive multidimensional reports.

There are two main ways to create an embedded table:

• Using the 'Embedded Table' option in the 'New Object' menu
• Converting a non-embedded table into an embedded data table
  

Using the ‘New Object’ menu:

1. Click the 'New Object' button, and select 'Embedded Table'. The cursor changes to a cross.
   
   
2. Click and drag the cursor across the cells that you want to compose the table. The cells are highlighted as you drag across them.
   
   When you release the cursor, the highlighted cells are converted into an embedded table. The top row of cells becomes the title row of the table, the second-to-top row becomes the column header row of the table, and any remaining rows of highlighted cells become the data rows of the table.
   
   
3. To edit a column header, double-click on the header and enter the desired text.
   
   
4. To edit a data cell, click in the cell and enter text directly. You can enter both numeric and non-numeric values.

View live interactive examples in InetSoft's dashboard and visualization gallery.

Converting a non-embedded table into an embedded data table:

1. Create a new Worksheet by clicking on the 'New Worksheet' button.
   
   
2. Click on the 'New Object' button, and select the 'Embedded Table' option. The cursor changes to a cross.
   
   
3. Drag across the Worksheet to highlight five rows and three columns.
   
   When you release the mouse, the selected range of the empty grid cells becomes part of the new table called 'Query1'; the first row of the selected range becomes the header row, and the second row becomes the column header row.
   
   
4. All the cells of this newly created table are editable. Double-click on the 'col0' header cell. The cell switches to editing mode, and you can now type in the cell to change the text.
   
   
5. Change the column names for 'col0', 'col1' and 'col2' to 'A', 'B' and 'C', respectively.
   
   
6. Enter any numeric values in the nine data cells. Note that both numeric and non-numeric values can be entered in the table.
   

View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software.