Tibco TCP-SP - TIBCO Spotfire Certified Professional Exam

A toggle filter is not a filter type in Spotfire, but a way to switch between two filter settings for a column. A toggle filter can be created from the right-click menu of a filter, and it will appear as a button in the filters panel. The filter types in Spotfire are determined by the data type of the column, and they can be changed by right-clicking the filter and selecting Filter type. The available filter types are: Item Filter, Range Filter, Radio Button Filter, Check Box Filter, List Box Filter, Slider Filter, Text Filter, Date Filter, Time Filter, and Expression Filter. References: Changing filter type, Filtering Data, Filtering Schemes

 A box plot is a graphical tool to visualize key statistical measures, such as median, mean and quartiles1. The median is the middle value of the data, which divides the data into two equal halves. The variance is a measure of how spread out the data is, calculated as the average squared deviation from the mean. The standard deviation is the square root of the variance, which has the same unit as the data. A box plot can show these three measures by using the following elements2:

The band in the middle of the box indicates the median.

The bottom and top of the box indicate the first and third quartiles, which are the medians of the lower and upper halves of the data. The difference between the third and first quartiles is called the interquartile range (IQR), which is a measure of variability similar to the standard deviation.

The bottom and top of the whiskers represent the minimum and maximum values within 1.5 times the IQR from the first and third quartiles. Any values outside this range are considered outliers and are shown as individual points. The length of the whiskers is related to the variance of the data, as larger variance implies more spread out data and longer whiskers.

The mean is denoted by a small circle, which may or may not be inside the box depending on how skewed the data is. The mean is another measure of central tendency, which is the average value of the data. The distance between the mean and the median reflects the symmetry of the data distribution.

References:

What is a Box Plot?

Box Plot

 The Document.Pages object represents a collection of the pages in the current document. It is an instance of the PageCollection class, which provides methods and properties to access, add, remove, or reorder the pages. Each page is an instance of the Page class, which contains the title, visuals, filtering scheme, and other properties of the page. The Document.Pages object can be used in IronPython scripts to iterate over the pages, navigate to a specific page, or modify the pages programmatically. References: PageCollection Class, Page Class, Navigate Pages using IronPython in Spotfire®

Information links are predefined database queries, specifying the columns to be loaded into the internal data engine of TIBCO Spotfire, and any filters needed to reduce the size of the data table prior to visualization1. Information links are saved in the Spotfire Library, which is a central repository for storing and managing data sources, analyses, and other resources2. Users can access information links from the library and use them to open data in Spotfire clients, such as the Web Player or the Analyst Client3. References: Information Links - TIBCO Software, Library - TIBCO Software, Changes in Spotfire version 10: How to add an Information link to an existing analysis

 There are two ways to use R scripts in custom expressions in Spotfire: registering R scripts as data functions and using the TERR_string() and related functions. Registering R scripts as data functions allows you to create your own functions using R syntax and call them from the custom expression and calculated column dialog boxes. You can also edit the saved expression functions from the Spotfire user interface. Using the TERR_string() and related functions allows you to execute R expressions that have been written as text strings within the custom expression. You can also use other functions such as TERR_integer(), TERR_date(), etc. to specify the data type of the output. The other options are not ways to use R scripts in custom expressions, but rather ways to use property controls or action controls, which are devices that can change the content of a property or trigger a script, respectively. References: Registering the TERR Script as an Expression Function, Add your own functions using R, Custom Expressions Introduction

A treemap visualization is a way of displaying large amounts of hierarchically structured data. The space in the visualization is split up into rectangles that are sized and ordered by a quantitative variable. The treemap in Spotfire uses a squarified algorithm, which means that the rectangles in the treemap range in size from the top left corner of the visualization to the bottom right corner, with the largest rectangle positioned in the top left corner and the smallest rectangle in the bottom right corner. For hierarchies, that is, when the rectangles are nested, the same ordering of the rectangles is repeated for each rectangle in the treemap. References: What is a Treemap?, Creating a treemap

The mod-manifest.json file is a JSON file that defines the metadata and configuration of a visualization mod. It contains information such as the name, ID, version, description, and author of the mod, as well as the files used by the mod, such as HTML, CSS, JavaScript, and images1. The mod-manifest.json file also specifies the axis definitions and placement for the mod, which determine how the data columns are mapped to the visualization and how the axis selectors are displayed in the user interface2. Therefore, the options A (All files included in the mod) and D (Axis definitions and placement) are correct. The other options are not listed in the mod-manifest.json file. CORS configuration data is not relevant for visualization mods, as they are not web services that need to handle cross-origin requests3. Visualizations affected by the mod is not a property of the mod itself, but rather a result of how the mod is used in an analysis. References: 1: Mod manifest - TIBCOSoftware1, 2: Axis definitions and placement - TIBCO Software2, 3: Cross-Origin Resource Sharing (CORS) - MDN Web Docs3

 A data function is a reusable calculation that can be applied to data in a Spotfire analysis. A data function can have input and output parameters that define how the data function interacts with the data and the analysis. The input parameters specify what data or values are required for the data function to run, and the output parameters specify what data or values are returned by the data function. The types of input or output parameters for a data function are1:

Column: A column parameter represents a single column of data from a data table. A column parameter can be used as input to provide a vector of values to the data function, or as output to create a new column in the data table or overwrite an existing column. A column parameter can have a data type such as real, integer, string, or boolean.

Document property: A document property parameter represents a value that is stored in the analysis document and can be used to control various aspects of the analysis, such as filters, markings, colors, etc. A document property parameter can be used asinput to provide a scalar value to the data function, or as output to create a new document property or overwrite an existing document property. A document property parameter can have a data type such as real, integer, string, boolean, date, or time.

Value: A value parameter represents a scalar value that is entered by the user or calculated by the data function. A value parameter can be used as input to provide a constant or variable value to the data function, or as output to return a single value from the data function. A value parameter can have a data type such as real, integer, string, boolean, date, or time.

The other options, column property, table, and visualization, are not valid types of input or output parameters for a data function. References:

Details on Data Functions – Parameters

Configuring Data Function Parameters

How to select/deselect inputs/outputs/parameters in Statistica Data Function for Spotfire

How to pass input from Spotfire to Statistica Data Function?