4.1.1. About the “Data-Preview” window

<< Click to Display Table of Contents >>

Navigation:  4. How to use Anatella? > 4.1. A first example >

4.1.1. About the “Data-Preview” window

 

You can copy-paste the results that are inside the “Data-Preview-Table” into Excel. For example:

Capture4

 

Open Excel and paste the results: (Press CTRL-V): You obtain:

 

ANATEL~1_img19

 

 

preview-data

 

 

The Header of the “Data-Preview” table contains:
 

The number of rows inside the table at this output pin. number1

The number of columns inside the table at this output pin. number2

The status of the output table and the status of the view. number3
 
 

This status can be:
 

oComplete”: The table at this output pin has been completely computed (it will thus been used to accelerate further computations along this data flow: See section 4.2.6. for more information about this subject) and the current “Data-Preview” window is able to directly show you the complete result table.
 

o“Complete (partial view)”: The table at this output pin has been completely computed but only a partical view of this table is visible because the table is too big to show in its entirety.

o“Fragment”: Only a fragment (i.e. the first few rows) of the table at this output pin has been computed (typically because the user clicked the STOP button ANATEL~1_img21  on the toolbar to abort the computations before completion). This fragment is now visible inside the “Data-Preview”. An incomplete table cannot be used to accelerate the computations later-on.

 

 

You can “hover” with your mouse above a cell (or above a column-title) to see the complete cell (or to see the complete title). For example:

 

ANATEL~1_img22

ANATEL~1_img23

 

 

You can quickly obtain a “Data-Preview” of the data at any point inside your Anatella-Data-Transformation-Graph (there is one exception: see section 5.26.2.). To know how to create and use “Data-Previews”, see the section 4.2.6. The “Data-Preview” window is thus a great tool to:
 

check for data quality issues.
 

check if you correctly parametrized your Actions.
 

check if “everything goes as expected” in general.

 

 

The “Data-Preview” allows you to visually inspect row-by-row all your tables but, sometimes, this is not enough: You want to have a visual summary of the content of a column (just to be sure this column does not contain a small quantity of absurd values). You can easily get this summary by right-clicking the header of a column: For example, when I right-click the header of the column “Age”, I obtain:

 

ANATEL~1_img24

 

 

When I select inside the above context menu the option “Create Chart as Value var”, I obtain a new window:

chart-as-value

 
From this point, I can either:

1.Completely abort the chart computation: Click the ANATEL~1_img26 button. number1

2.Click the “STOP” button to compute the charts on the rows that     have already been processed. The quantity of rows already processed is displayed here:number2
 

3.Simply wait for the complete table to be processed.

 

 
To start a new “chart computation”, you don’t need to wait for the complete table to be computed (i.e. you don’t need to wait for the data-preview status to reach “Complete”): You can directly start the computations while the status is still on “Fragment”. This allows you to quickly produce some charts on the first few rows of your table: No need to wait! ANATEL~1_img27

 

The charts are produced as MS-Word and/or MS-Excel documents.
 
 

Here is an example on the classical “census-income” database. Let’s assume that:
 

we defined as “Binary Target” the column “Taxable Income Amount”.
 

we asked to see the column “age” as a Value variable.

 
 
Then, we obtain:

 

audit-report

ANATEL~1_img28

 

ANATEL~1_img29  

 

 

 

 

ANATEL~1_img30

 

clip0006

 

Please refer to the “TIMiQuickUserGuide.pdf” for more information about the charts displayed inside this summary report.