Skip to main content

List of Statistical Functions Available in Spotfire

You can include any additonal Statistical methods using Open Source R, Tibco Enterprise Runtime for R,
SAS, Matlab

Data relationships Linear regression (numerical vs numerical), 
Spearman R (numerical vs numerical),
Anova (numerical vs categorical), 
Kruskal-Wallis (numerical vs categorical) 
Chi-square (categorical vs categorical).

Hierarchical Clustering
Single Linkage
Complete Linkage
Ward's Method

Hierarchical Clustering Distance Measures
Cosine Correlation
Tanimoto Coefficient
Euclidean Distance
City Block Distance
Square Euclidean Distance
Half Square Euclidean Distance

Regression Modelling Linear Regression
Regression Tree Method

Classification Modelling Logistic Regression Method
Classification Tree Method

Forecast Holt-Winters
Forecast using Regression Modelling,Classification model methods above

K-means Clustering
Line similarity comparison


Popular posts from this blog

Persoanlized Info Links and Scheduled Updates

imagine a store manager has access to his or her own store.. and can only view that data

Step 1 -- create a information link that is NOT personalized and gets data for all stores.. so if you open this link it will show everything to everyone, lets say it has a column called as "store number".

Step 2 -- Create an personalized info link that brings back list of stores current user has access too
Generally this is will bring very small number of rows a

Step 3 - In the analysis, add the first information link, Don't worry that at this point it is bringing all data.

Step 3 -- Then do Insert column, select  from Information Link and select the link you created in step 2.

Step 4 -- As part of the insert steps, Match the two tables on the store number column and select the correct kind of join

step 5 -- Now Go to Edit >> Data Table Properties >> Select the table from Info Link created in step 1

Step 6) You should see a tab "schedulde updates" updates tab in that …

Spotfire Writing back to a database

Lot of time users need to write back to a database.

Spotfire provides different ways to do this, Without going thru the code I am going to talk thru the different options available. But if you need detailed instructions, please leave some comments and will try to provide one

1) Stored Procedures.

Advantages : Complex logic is easy to encapuslate in procedures. Also you are not storing username/passwords anywhere 

Spotfire can execute stored procedures and these procedures could be fetching data, or can be procedures that can be run Pre or Post running a query. You can then use procedures that basically update your database table or even inserts new rows in tables.

When using Spotfire information model it allows you to use these procedures which you can repurpose for updating your database.
Spotfire also understands inputs to a procedure and they can be mapped to your marked rows/filtered rows/ properties/constants etc from your analytics.

Steps to do that would be
1)Create a procedure …

Using Accordions in Spotfire Text Areas

Spotfire 6.0 provides great tools for quickly building your dashboard, but here we will learn to spice up things with the help of new 6.0 text area. If you are not aware the new 6.0 Text area supports HTML, Javascript and CSS.
This opens up possibilities for doing a lot more with the text area.
Some of the basic stuff can be seen here
One of the cool things you can do is build an accordion panel in the text area for better utilization of the valuable screen real estate and helping the overall experience.(Watch the 0:15 second video below to see how accordion works - Sorry for the jitter in the video. The screen recorder does not record fast enough)

Here is the html behind the text area : Please note that Spotfire controls are automatically created when you add text area controls, like filters, drop down lists etc.
<DIV id="myaccordion"> <H3>Analysis Details</H3> <DIV> Author : John Doe <BR&g…