Tutorial: How to Have Selectable Countries or Regions on a Map Chart

Map chart in Spotfire is one of the coolest native tools available. The ability to have spatial data makes your analysis not only look comprehensive but also gives users another angle to observe the data from. That being said, map charts can be finicky. Having point data is one thing, but what if you want to be able to highlight regions of a map or highlight whole countries? I found myself up against this exact issue when I was working on a recent Spotfire template that looks at Olympic historical data.

Read More

Parsing Text: Numerical Data from Historical Accounts

In a recent article on Data Shop Talk, I introduced an interesting set of analyses on Olympic data. One of the analyses focused on Olympians who had died or gone missing due to war. The data from Sports-Reference.com came in a csv file format with the following information: Athlete, Gender, Country, Sport, and Notes. This was a great start to my analysis but there was something critical missing in order to properly illustrate the timeline of deaths: the date of death.

Read More

The Olympics: Stories You Never Knew

The Rio 2016 Summer Olympics have been getting a lot of bad press recently, but these aren’t the first Olympics to be drama filled. Consider the 1956 Olympics in Melbourne, Australia when Cold War tensions led to the withdrawal of multiple countries and the defection of many Olympic athletes (especially from Hungary). Or how about the 1916 Olympics that were originally planned to happen in Berlin, but never did because of the outbreak of World War I? 

Read More

Comparing Average with Values in Same Plot in Spotfire

A common task for an analyst is to plot averaged values in the same chart against quantities of compared variables in order to show the deviation. For instance, a visual representation of salaries of a certain job function in 3 US cities in the last year, can include the US national average to inform viewers of the departure of each city salary from the national average.

Read More

Data Science Design Pattern: Train & Predict

Spotfire is a great tool that lets you run asynchronous R code right next to your data and visualizations. This makes for what I like to call the Data Science Trifecta. There’s lots of applications out there that provide the Data Science Trifecta – data, visualizations, and computation – and I prefer Spotfire’s relational data model, snappy visualizations, and embedded R engine. So let’s talk about reusing predictive models in this Trifecta. If you’re eager to try it out, you can grab the template off of Exchange.ai.

Read More

Well Deliverability (IPR/TPR) using Spotfire

The deliverability of a system is its ability to deliver gas as a function of pressure. Ruths.ai Well Deliverability tool is developed to assist oilfield operators in determining the flow rates of gas-drive wells using inflow performance relationship (IPR) and tubing performance relationship (TPR) of reservoir, wellbore and production data.

Read More