We at TIBCO believe in Innovation through Experimentation; within the Enterprise sector we have been able to open up an otherwise closed system by means of Community Exchange. Each day we strive to improve our Analytics offerings over varied technology stacks and witness our Insights to Action models bring value to our customers. One step further in this direction was the TIBCO Spotfire® Hackathon at the Energy Forum 2016, that witnessed an overwhelming participation from from leaders, industry experts and consumers across the Energy sector.
Left to Right: Michael O’Connell, Chief Analytics Officer TIBCO; Winner: Alexander Lach from ConocoPhillips; Runner-up: John Wagner from Anadarko; DivyaJyoti Rajdev, TIBCO Tech Team.
John Wagner and Alexander Lach dominated the TIBCO Spotfire Hackathon right from the start by scoring high points on basic tasks and advanced exercises. They both finished with the same base score and tied on all counts of tiebreaker exercises. But in the end Alex Lach cinched the GoPro prize by demonstrating superlative overall skill in Spotfire.
We hope to extend the lessons we learnt and the knowledge assimilated by featuring model solutions for each of the exercises. You can also download the solutions dxp from the page for an indepth study of the configuration.
In task 1, participants were asked to plot GeoSpatial Data to a map chart and apply contour lines on it with bonus points for configuring a TMS layer. Detailed configuration included linking user selections with the measurements plotted on map chart. Here is a video walkthrough of the solution.
In task 2, participants were encouraged to try various out-of-box machine learning solutions on the data provided and comment on any insights gained from the exercise. Here is a video walkthrough of Clustering and Regression examples.
Task 3, explored concepts like brush-linking visualizations and using parameters returned by data function to plot curves. Decline Curves are frequently used to analyse energy production data and an analysis template for the same, from the exchange page formed the basis of this exercise. Here is a video illustrating setting up the DCA template with your data.
Novel Ideas from Participants
Many participants went beyond the expected model solutions and created analysis that tackled unique problems spanning the Energy Industry, Geoanalytics and Machine Learning. Some solutions of interest are featured below:
Leveraging Data functions: Participant 5
The participants started at the level field of having a data function that computed the parameters for setting up individual Decline Curves for each unique identifier. Participant5 was able to modify the script to calculate parameters for all well IDs and output them to a table. This modification allowed user to visualize all Decline curves simultaneously using Trellis option. Seeing all Decline curves together, user was able to gain insight that Arps hyperbolic sometimes captures recompilation in Production data and further customization may be needed to fit certain kinds of patterns in the data.
Leveraging Spotfire APIs: Participant 22
Participants were given a cheat sheet to assist in publishing their Analysis (or cherry-picked visualizations from this) onto the World Wide Web. Participant 22 created a web page with the sample visualizations and summarized it as the following simple steps:
- Create new spotfire cloud account
- Publish Analysis on Cloud
- Publish on user’s web server
And the webpage is live!
Leveraging Visualizations: Participant 5
Participant 5 went a step further in analysing K means clusters obtained from the line chart and visualized them them as Box plot, using Document properties in Spotfire participant could now choose which variable should be examined and based on that visualise lift and view statistics information. This combination of out-of-box clustering, geoanalytics and powerful Spotfire visualizations helped Participant to gain the insights shown.
In an effort to extend our resources to the open source community we encourage you to try your hands at the Hackathon dxp and send us your solutions at firstname.lastname@example.org. Interesting solutions get featured on this page and participants will be invited to talk at TIBCO Meetup events. Download and try Spotfire 7.6 here.
See what people are saying about us
"Data and visual analytics has been a transformative agent in gaining insight and making data driven decisions, resulting in cost savings and revenue generation in areas like planning and development, drilling and completions, and production and operations."
- Hitesh Pushpraj, BI Director - ConocoPhillips
The Spotfire Hackathon was my favorite part of the Energy Forum. The problem set was thoughtful, relatable, and challenging. It forced me to push my limits and improve my Spotfire skills in a short amount of time.
- John Wagner, Anadarko
- TIBCO Community Exchange contains under category "Analytics" reusable components and data functions that can be downloaded and then added to your dxp file
- TIBCO Answers page is a question and answer forum for TIBCO Products. Spotfire questions can be asked under Analytics or Spotfire tags.
- Quick Reference Topics contain quick tutorials, examples and how-to videos on basic Spotfire topics.
- Spotfire Reference Videos is the link to Spotfire Youtube channel that contains quick how-to videos on innovative Spotfire tricks. For more resources similar to above also see Catalina Herrera's Youtube channel.
- Dr Spotfire will feature online training and Q&A sessions biweekly for both new Spotfire users and existing Spotfire users.