Welcome to my blog where I hope to provide a useful resource on developing web based data analysis and visualisation tools (a.k.a informatics, analytics or business intelligence tools).

Primarily this will focus on my experience with the TIBCO Spotfire software as a mechanism to produce these applications but I will talk about more generic data analysis and web development points as well.

With over 15 years of experience of scientific analysis and web development I hope I can show that not only am I qualified to discuss these topics but I can help you with your aims in this area.

Recent Posts

Dec 4 2014

Personalised Information Links and Finding the User Name in Spotfire

Often there is a need to retrieve data specific to an individual user or group, or you need to find out and use the username of the person logged on.

TIBCO SpotfireInformation LinkUsernameUsersPython
Jun 30 2014
Apr 3 2014

(Updated Oct 2014) Filtering Individual Charts, Tables and Visualisations in Spotfire

Filtering your charts is highly configurable. Here I present a summary and a few tricks to improve your analysis.

filteringTIBCO SpotfireData AnalysisCharts
Jan 30 2014

Creating Dynamic Tables using Scripts

Tables in Spotfire aren't as easy to make dynamic as other table visualisations. Using scripts we can control columns, sorting etc

sortingTIBCO SpotfireTablesScripts
Jan 24 2014

Spotfire 6 - The Game Changer

My impressions of Spotfire version 6 which has added many new features

TIBCO SpotfireVersion 6Mapping
Oct 25 2013

How to Control Bookmarks using Scripts

A guide on how scripting can be used to find and apply bookmarks in Spotfire.

TIBCO SpotfireBookmarksScripts
Aug 12 2013

(Updated 05-Nov-2014) How to embed the Spotfire web player inside a web page

A guide on the bare minimum HTML and JavaScript code to embed the Spotfire web player into another web page

Jul 18 2013

How to mark and unmark rows using scripts in Spotfire

How to mark and unmark rows using scripts in Spotfire and combine with property controls.

TIBCO SpotfireMarkingScripts
May 6 2013

Build dynamic charts using scripts for use through the Spotfire Web Player

A demonstration on how scripts can be used to create dynamic charts for use through the Spotfire Web Player and Spotfire client.

May 1 2013

Changing the default visualisation plot and other settings in Spotfire

A quick pointer to some of the default options you can set in Spotfire such as the default visualisation plot type and hiding scroll bars.

TIBCO SpotfireSettings
Apr 4 2013

Creating Select All, Reset Filters and Set To Default links using bookmarks in Spotfire

Using bookmarks, actions and links can be create that will select all, reset filters and set to default (filters) in Spotfire

TIBCO SpotfireAction ScriptsFiltersBookmarks
Mar 11 2013

How to fix cross tables that can't be exported in the Spotfire web player

How to fix cross tables that can't be exported through the web player, as well as how to control this for each cross table.

SpotfireCross TableWeb PlayerExport Data
Mar 4 2013

How to get map charts working from Spotfire version 4.5 to 5.0

When creating map charts from data tables with spatial calculated columns there is now an extra step needed that wasn't required in version 4.5

SpotfireMap Chart
Feb 12 2013

View All Schemas using the Server Explorer in Visual Studio

A quick tip on how to view more than one schema in the server explorer for Visual Studio.

Visual StudioDatabase Schema
Feb 8 2013

Remove duplicate rows in Spotfire

A summary of methods that can be used to deal with duplicate data in Spotfire

DuplicateSpotfireRowsData
Nov 29 2012

How to resize a list box filter in a text area or the filters menu in Spotfire

A quick and easy trick showing you how to resize a list box in Spotfire.

Text areaSpotfirelist box
Nov 27 2012

How to rename and hide headers or chart labels in a table or chart in Spotfire

How to change your headers or chart labels in Spotfire. Then using the same method hide any header's text.

headershide
Nov 6 2012

The Power of Data Relationships and Avoiding Database Joins

Avoid using unnecessary joins on data tables by using data table relationships in TIBCO Spotfire

JoinsrelationshipsdatabaseSpotfirefiltering
Nov 5 2012

Executing scripts within other scripts (from TIBCO Spotfire)

A neat trick published on Spotfire's own Tip of the Week showing you how to execute scripts within other scripts.

SpotfireScripts
Oct 19 2012

OVER Statements in Cross Tables and Beyond

A simple example of how to use custom expressions and OVER statements in cross tables and graphs

SpotfireCross TableCustom ExpressionCalculated ColumnPercentage Difference
Oct 18 2012

First Impressions from the Spotfire 5 Webcast

First impression of Spotfire 5 and Big Data

Oct 11 2012

Using Oracle Spatial MDSYS SDO GEOMETRY columns in Spotfire

A guide on how to implement Oracle Spatial MDSYS SDO.GEOMETRY columns in Spotfire

SpotfireMap ChartOracle SpatialMDSYSSDO GEOMETRY
Oct 5 2012

Show all data when a filter is set to None in Spotfire

How to create a filter in a text area that defaults to showing all data but can be filtered to individual items.

SpotfireFilters
Oct 3 2012

UNION ALL (SQL) statement in Spotfire

An explanation on how to use UNION ALL SQL statements through information links in Spotfire.

SpotfireUNION ALLSQLInformation Link
Oct 1 2012

Selective Labelling in Spotfire Visualisations and Charts

How to display labels on a Spotfire visualisation or chart only for the data points of interest.

SpotfireLabels
Sep 30 2012

Basic Principles of Developing Data Analysis Applications - Start with a question, end with a question

A guide to some of the basic principles of developing analyses and informatics applications for any industry.

Data AnalysisWeb Development
Sep 27 2012

In The Beginning (there was my data analysis using Tibco Spotfire blog)

Introduction to Bear on Spotfire. The blogs aims and hopes.

Spotfire
The brilliant green dial omega replica uk gives new life to the watch. The combination of traditional watchmaking and rolex watches fashion colors perfectly demonstrates the charm of the other side of men, which is very suitable for fake replica fashion men's choice.