User Interface

• File import and export dialogs
• Database import and export dialogs
• Point and click dashboards are combination of visualisations and pages to showcase insights
• Assists you in analysing the data by providing recommendations on visualizations that fit the data you want to display
• Data Canvas provides an overview on how each data table in the analysis was created, and you can add data or edit settings for different data sources
• When you add a visualisation to an analysis, you can:
  – Start by selecting data
  – Start by selecting visualisation type
  – Search for what you’d like to visualise
• Copy-and-paste to Word, PowerPoint and Excel
• Export visualisation to Image or PDF and data to a file
• Export dashboard to PDF or Microsoft PowerPoint
• Create custom toolbars
• On-line help, manuals and how to videos

Integrate with many data formats

• Load data into the internal data engine of TIBCO Spotfire (in-memory analysis) from a number of different sources
  – by pasting data from the clipboard
  – by dragging and dropping or opening simple text files, Microsoft Excel files or SAS files
  – by connecting to a database via ODBC or OLE DB
• ASCII: fixed format, comma-separated, and tab-delimited – (*.csv), (*.txt)
• Microsoft Excel Workbook
• Spotfire Analysis file (*.dxp)
• Script Function Definition (*.sfd)
• TIBCO Spotfire Text Data format
• Microsoft Access Databases
• SAS (*.sas7bdat)
• Universal Data Link (*.udf)
• Sfs file (*.sfs)
• Spotfire Server Log Files (*.log)
• Spotfire Binary Data Format (*.sbdf)
• ESRI Shape Files (.shp)
• Amazon Redshift
• Apache Drill
• Apache Spark SQL
• Attivio
• Cloudera Hive
• Cloudera Impala
• Dremio
• Google Analytics
• Google BigQuery
• Hortonworks
• IBM DB2
• IBM Netezza
• Microsoft SQL Server
• Microsoft SQL Server Analysis Services
• OData
• Oracle
• Oracle Essbase
• Oracle MySQL
• Pivotal Greenplum
• Pivotal HAWQ
• PostgreSQL
• Salesforce
• SAP BW
• SAP HANA
• Snowflake
• Teradata
• Teradata Aster
• TIBCO Cloud™ Live Apps
• TIBCO ComputeDB
• TIBCO Data Virtualization
• TIBCO Spotfire Data Streams
• Vertica

Visualisations

• Table
• Cross Table
• Graphical Table
• Bar Chart
• Waterfall Chart
• Line Chart
• Combination Chart
• Pie Chart
• Scatter Plot + add linear and non-linear statistical model curves with a few clicks
• 3D Scatter Plot
• Map Chart
• Treemap
• Heat Map
• KPI Chart
• Parallel Coordinate Plot
• Summary Table
• Box Plot
• Text Area
• Edit colours, lines, axes, annotations and layout
• Interact with visualisations by marking, highlighting, drag-and-drop and zoom sliders
• Multiple data tables in one visualisation
• Hierarchies
• Trellis Visualisations – create multiple charts conditioned by levels of one or more variables
• Details Visualisations – selecting points on a main visualisation allows drill down on a 2nd and subsequent visualisations

TIBCO® Enterprise Runtime for R (TERR)

• In-built high-performance statistical engine that is compatible with open-source R.
• Provided in your installation of Spotfire so you can script and run data functions or create predictive models.
• TERR Tools are provided to give you access to the TERR console to test scripts and functions, and to the TERR Language Reference for help with installed packages.
• You can use TERR Tools to launch the RStudio interactive development environment for script authoring. TERR Tools also provides an interface to download and install packages from the Comprehensive R Archive Network (CRAN).
• Note: Some statistical methods below are accessible through the TERR engine in Spotfire via data functions

Data Relationships

• Linear Regression
• Spearman R
• Anova
• Kruskal-Wallis
• Chi-square

Cluster Analysis

• K-means
• Hierarchical clustering

Regression

• Linear regression
• Polynomial regression
• Model diagnostics
• Prediction and confidence intervals
• Parametric spline models
• Logistic regression
• Generalized linear models
• Visually compare polynomial regression and traditional methods

Hypothesis Tests and Confidence Intervals through TERR engine

• One-sample and two-sample t-test and Wilcoxon
• Paired t-test
• Correlation: Pearson, Kendall’s tau, Spearman’s rho
• Goodness-of-Fit: Chi-square, Kolmogorov-Smirnov, Shapiro-Wilk
• Rank tests: Kruskal-Wallis, Friedman
• Proportions: exact Binomial test, Normal approximation
• Contingency tables and tests for independence: Chi-square, Fisher, Mantel-Haenszel, McNemar

Analysis of Variance

• Univariate and multivariate ANOVA
• Flexible specification of variables, covariables, interactions, nesting, transformations
• F-test to compare two variances
• Multiple comparisons: Fisher, Tukey, Bonferroni

Nonlinear Regression and Maximum Likelihood

• Nonlinear regression
• Nonlinear maximum likelihood
• Constrained nonlinear regression

Nonparametric Regression

• Loess smoother
• Super smoother
• Kernel smoother
• Spline smoother

Tree Models

• Classification trees
• Regression trees
• Pruning, shrinking, and splitting
• Scoring

Multivariate Analysis

• Canonical correlation
• Factor analysis
• Principal components
• Biplots

Time Series Analysis 

• Autocovariance, autocorrelation and partial autocorrelation
• Box-Jenkins ARIMA models
• Classical and robust AR
• Seasonal decompositions
• Fourier transformations
• Classical and robust smoothers and filters