TIBCO Spotfire Analytics 1 — Questions and Answers
Question 1: What type of analytics platform is TIBCO Spotfire?
- A self-service visual analytics and business intelligence platform with in-memory data processing, predictive analytics, and embedding capabilities (Correct answer)
- A relational database management system optimised for OLAP workloads
- A real-time CEP engine for detecting patterns in event streams
- A master data management platform for governing enterprise reference data
Correct answer: A self-service visual analytics and business intelligence platform with in-memory data processing, predictive analytics, and embedding capabilities
TIBCO Spotfire is a BI and analytics platform known for its interactive visual exploration, in-memory computation, guided analytics (TERR/Python scripts), and ability to connect to live data sources including TIBCO TDV.
TIBCO Spotfire is a self-service analytics platform used by data analysts, data scientists, and business users. Its core strengths include: in-memory data loading for fast interactive exploration; a rich visualisation library (scatter plots, heat maps, box plots, network charts, geographic maps); guided analytics using TERR or Python integration for predictive models embedded directly in dashboards; live connections to TIBCO Data Virtualization, databases, Salesforce, and S3; and an embedding API for integrating Spotfire visualisations into custom web applications.
Question 2: What is a Spotfire Information Link and what is its purpose?
- A reusable, parameterised query definition that data administrators create against a data source, allowing business users to load data into Spotfire without writing SQL (Correct answer)
- A hyperlink embedded in a Spotfire visualisation that opens an external web page
- A REST endpoint exposed by Spotfire for embedding dashboards in external applications
- A file system path pointing to the Spotfire server's shared data directory
Correct answer: A reusable, parameterised query definition that data administrators create against a data source, allowing business users to load data into Spotfire without writing SQL
An Information Link is a pre-defined, governance-controlled query stored in the Spotfire Library that users can parameterise and execute to load data, abstracting the underlying SQL and database connection details from end users.
Spotfire Information Links allow data administrators to create curated, parameterised data access queries stored in the Spotfire Library. Business users execute these Information Links with user-provided parameter values (date range, region) without knowing the underlying SQL, database name, or connection credentials. Administrators can define join logic, calculated columns, and column-level security within Information Links, providing a governed self-service data access model.
Question 3: What is the TIBCO Spotfire TERR engine and how is it used?
- TIBCO Enterprise Runtime for R — an embedded R execution engine within Spotfire that runs R scripts for statistical analysis and predictive modelling directly within dashboards (Correct answer)
- A TIBCO-proprietary rule language for defining data transformation logic in BW
- A GPU-accelerated rendering engine for 3D data visualisations in Spotfire
- A C++ numerical library used internally by Spotfire's chart rendering layer
Correct answer: TIBCO Enterprise Runtime for R — an embedded R execution engine within Spotfire that runs R scripts for statistical analysis and predictive modelling directly within dashboards
TERR is Spotfire's embedded R runtime, enabling analysts to write R scripts that execute within the Spotfire environment to perform statistical tests, fit models, and return results as data tables or visualisations in the dashboard.
TIBCO Enterprise Runtime for R (TERR) is a production-grade R execution engine embedded into Spotfire. Analysts write R scripts in Spotfire's data function editor. These scripts receive Spotfire data tables as inputs, execute R statistical functions (regression, clustering, time series forecasting), and return result data frames back into Spotfire as new data tables or columns. TERR is compliant with base R and most CRAN packages. Spotfire also supports Python data functions.
Question 4: What is the purpose of Spotfire Mods?
- Custom visualisation types or analytical components developed in JavaScript/TypeScript by partners or developers that can be embedded into Spotfire analyses like native chart types (Correct answer)
- TIBCO-approved hardware modifications to servers running Spotfire for performance tuning
- Database driver extensions for connecting Spotfire to unsupported data sources
- Admin plugins for adding custom authentication providers to the Spotfire server
Correct answer: Custom visualisation types or analytical components developed in JavaScript/TypeScript by partners or developers that can be embedded into Spotfire analyses like native chart types
Spotfire Mods are custom visualisation and analytics components built with the Spotfire Mods API (TypeScript/JavaScript) that integrate seamlessly into Spotfire's data model and property system, extending the built-in chart library.
Spotfire Mods allow developers to create custom visualisations using the Spotfire Mods API. A Mod is a self-contained web component built with TypeScript/JavaScript that subscribes to Spotfire's data model (receiving filtered, marked data just like native charts do), reads and writes document properties, and renders itself in a Spotfire analysis panel. Mods are packaged as .mod files and can be shared via the Spotfire Library or the TIBCO Exchange marketplace.
Question 5: How does Spotfire's marking feature support interactive data exploration?
- Marking allows users to select data points across multiple linked visualisations simultaneously; all charts that display the same data update to highlight the marked subset, enabling multi-chart cross-filtering (Correct answer)
- Marking bookmarks a dashboard page for easy navigation back to a specific view
- Marking inserts a physical marker annotation into the underlying source database
- Marking increases the display priority of a specific chart on the dashboard
Correct answer: Marking allows users to select data points across multiple linked visualisations simultaneously; all charts that display the same data update to highlight the marked subset, enabling multi-chart cross-filtering
Spotfire's marking is a cross-visualisation selection mechanism: clicking or lashing data points in one chart marks them and all other linked charts immediately highlight the same underlying records.
Marking is one of Spotfire's defining interactive features. A marking is a named selection set in the Spotfire data model. When a user selects data points in one visualisation, the marked records are highlighted simultaneously in every other chart on the page that references the same data table and marking. For example, selecting 5 customers in a scatter plot immediately highlights their transactions in a bar chart, their geographic positions on a map, and their orders in a cross-table.
Question 6: How does TIBCO Spotfire connect to TIBCO Data Virtualization for live analytics?
- Using a JDBC/ODBC connection to TDV's published data layer, treating TDV as a database and querying virtual views directly without requiring data extraction to Spotfire's in-memory store (Correct answer)
- By exporting TDV results as CSV files that Spotfire imports on a schedule
- Via a custom TIBCO binary protocol that only works when both products are on the same server
- Spotfire cannot connect to TDV — they are separate product lines with no integration
Correct answer: Using a JDBC/ODBC connection to TDV's published data layer, treating TDV as a database and querying virtual views directly without requiring data extraction to Spotfire's in-memory store
Spotfire connects to TDV via standard JDBC/ODBC (TDV exposes itself as a SQL server), allowing Spotfire to query virtual views in real time and display live data without loading a copy into Spotfire's memory.
TIBCO Data Virtualization exposes a JDBC/ODBC interface. TIBCO Spotfire can therefore add TDV as a data connection using its standard JDBC connector, and browse TDV's published Schemas and their virtual views as if they were database objects. Spotfire can query TDV views in live mode (every filter interaction sends a new query to TDV, which federates it to source systems in real time) or load a snapshot into Spotfire's in-memory engine for faster interaction.
TIBCO Spotfire Analytics 1
What type of analytics platform is TIBCO Spotfire?