TIBCO Cheat Sheet 2026

The 30 highest-yield TIBCO facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. In Spotfire Server administration, what is a 'Group' used for? → A named set of users to whom permissions and licenses can be assigned collectively
2. In Spotfire, what is a 'calculated column'? → A column derived from an expression evaluated row by row on the data table
3. Which Spotfire function would you use to replace NULL values with a specified default value in a custom expression? → IsNull() combined with If()
4. You can only use one data set at a time while using TIBCO Spotfire. → False
5. What is the purpose of 'Scheduled updates' for analyses in Spotfire Server? → Automatically refresh data and cache analysis results on a defined schedule
6. In Spotfire, what is the effect of setting a column's data type to 'SingleReal' versus 'Real'? → SingleReal uses 32-bit floating point precision; Real uses 64-bit double precision
7. What is the purpose of 'Information Links' in TIBCO Spotfire? → Reusable, governed data source definitions stored in the Library
8. Which Spotfire calculated column expression would return the natural logarithm of a column named [Revenue]? → LN([Revenue])
9. What does the 'OVER' function do in Spotfire custom expressions? → Computes an aggregation over a specified subset or grouping of data
10. The Data Functions Properties dialog is accessible from which menu? → Data
11. How do you add a script to a Spotfire button control so it runs on click? → In the button's Action property, link a Script action referencing the IronPython script
12. What year did TIBCO purchase Spotfire? → 2007
13. TIBCO was established in: → 1997
14. Analytical Tools for People Using your PC for data mining and Visualization These characteristics of → Spotfire Desktop
15. What does Spotfire's 'Confidence interval' band around a trend line represent? → The uncertainty range within which the true regression line likely falls
16. Which operation in TIBCO Spotfire combines columns from two data tables using a shared key column? → Add Columns
17. What role in Spotfire grants users the ability to publish analyses to the Library? → Author
18. In Spotfire Web Player, which feature allows an administrator to pre-render analyses so users experience faster load times? → Pre-caching (analysis pre-loading)
19. What does the OVER function in Spotfire expressions allow you to compute? → Aggregations scoped to a specific set of columns (window/grouping context)
20. Which Spotfire Server component is responsible for authenticating users against LDAP or Active Directory? → Authentication module configured in the server configuration tool
21. In TIBCO Spotfire, what does a 'Trellis' visualization do? → Splits a visualization into panels based on a category
22. In Spotfire IronPython, which method applies a row filter to limit visible data in a visualization? → Document.Data.Filterings.DefaultFilteringScheme.Item[table][column]
23. What is the purpose of a 'Spotfire Package' (SPK file)? → A deployable bundle containing extensions, connectors, or customizations for Spotfire
24. In TIBCO Spotfire, which scripting language is natively embedded for writing custom scripts? → IronPython
25. Which Spotfire feature allows embedding an analysis into an external website via an iframe or JavaScript API? → Spotfire Embed API / Mashup framework
26. What is the role of 'Data functions' in TIBCO Spotfire? → R or Python scripts that accept Spotfire data tables as input and return results
27. In Spotfire, what does 'Correlation coefficient' as a trend line statistic measure? → The strength and direction of the linear relationship between X and Y
28. In TIBCO Spotfire, which data loading strategy provides the most current data at all times without manual user intervention? → In-database mode where queries run against the live source on every interaction
29. Where can you find a depiction of Details-on-Demand? → Under Menu: View > Details-on-demand
30. In Spotfire IronPython, what is the correct way to add a calculated column to a data table? → table.Columns.AddCalculatedColumn(name, expression)