Month: February 2014


Posted on Updated on

Spotfire is an easy-to-use, extensible and customizable visualization product – a more viable long-term alternative to Tableau. It has great GIS integration features and other APIs such as webplayer JS API allowing integration with GIS software and extensions such as OpenSpirit® for the energy sector. Further, it can be customized to build custom charts.

Tableau: Table Calculations and Time Series Analysis

Posted on Updated on

Using Running total for duplicate SUM(Sales)

Table Calc and Time Series 1

We can see that Corporate is performing best

Table Calc and Time Series 2

Looking at the year on year percent difference in Sales

Table Calc and Time Series 3

Using bar charts to look at the quarterly performance. We can further drill down to more granular levels to check monthly and daily performances

Table Calc and Time Series 4

Looking at every day sales with “Running Sum” and “Moving Average” of Sales

Editing calculations at the date level with “Previous value” as 30 – for the 30 day moving average

Table Calc and Time Series 5

And using filters to see the data for particular years

Table Calc and Time Series 6

At Tableau Public: 

Time Line

Spotfire: Position Data on Map Charts with Geocoding or Coordinates

Posted on Updated on

There are two methods for our coordinates to appear on the map chart.

  1. Giving the coordinates using Longitude and Latitude values
  2. Using Geocoding

Using the Longitude and Latitude values for mapping


Create a new page and add a new map chart


For better presentation remove legends, filters and enable labels for cities (on click)


2. Using Geocoding

Use the map layer setting in “My Data” to use geocoding data (a Spotfire feature) by “City”


Automatic geocoding automatically adds three data columns from data table and uses US cities for mapping


You can see the point by selecting them in marking mode


FYI. TIBCO provides Geocoding data tables for different geographies


The Data Landscape

Posted on Updated on

Storage and Processing:

  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • MySQL
  • PostgreSQL
  • NoSQL (MongoDB, Neo4j etc.)

Data Integration:

  • Informatica
  • Ab Initio
  • IBM InfoSphere DataStage
  • SAP BusinessObjects Data Services
  • Microsoft SSIS

Data Modeling:

  • CA ERwin Data Modeler
  • IBM InfoSphere Data Architect

Data warehousing and Business Intelligence:

  • Teradata
  • IBM Netezza
  • Oracle Exadata
  • Sybase IQ (SAP)

Business Intelligence and Reporting:

  • Microstrategy
  • IBM Cognos
  • SAP Business Objects
  • Microsoft SQL Server Reporting Services (SSRS)


  • SAS
  • R

Data Visualization:

  • Tableau
  • TIBCO Spotfire
  • QlikView
  • MicroStrategy Analytics Desktop

Cloud Solutions:

  • Amazon EC2
  • Google Big Query
  • Amazon  RDS

Big Data Frameworks:

  • Cloudera
  • Hortonworks
  • MapR
  • Pivotal

Big Data Analytics:

  • Aster data (Teradata)
  • Greenplum (EMC)
  • Vertica (HP)
  • Splunk
  • ParAccel
  • Infobright
  • Pentaho
  • Talend

Spotfire: Forecasting

Posted on Updated on

Importing data from a .dxp file


Drilling down on the data



Using filters to customize views for different categories


Using Forecast – Holt-Winters feature


Creating a forecasting model


Setting up confidence level: 0.99