ICB Expert Project Manager-Data Analysis at a manufacturing company with 10,001+ employees
Real User
Top 20
Good support, and is stable, but the UI has room for improvement
Pros and Cons
  • "Live Query data on demand, R and Python integration, and the ability to write HTML and JavaScript text areas are all valuable features."
  • "The data compression has room for improvement."

What is our primary use case?

We use the solution to handle large datasets.

What is most valuable?

Live Query data on demand, R and Python integration, and the ability to write HTML and JavaScript text areas are all valuable features.

What needs improvement?

The data compression has room for improvement.

The usage of SPDF files can be improved.

I would like the ability to loop intellect queries the same way that I can with QVD data.

The UI has room for improvement.

For how long have I used the solution?

I have been using the solution for nine years.

Buyer's Guide
TIBCO Spotfire
March 2024
Learn what your peers think about TIBCO Spotfire. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,578 professionals have used our research since 2012.

What do I think about the stability of the solution?

The solution is stable.

How are customer service and support?

The technical support is responsive.

What other advice do I have?

I give the solution a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user495000 - PeerSpot reviewer
Sr. Data Scientist II - Information Research at a pharma/biotech company with 10,001+ employees
Real User
It takes some of the content management burden off of my group and gives our scientists a platform to explore their ideas.

Valuable Features

It can be made chemically aware. This is a must-have in pharmaceutical R&D

The in-memory architecture allows the software to be very responsive to user inputs even with large data sets. (This does require that we provide users with appropriate hardware to handle the workload.)

Spotfire is feature rich but not so complicated that users can't be trained to generate their own content. This takes some of the content management burden off of my group and it also, more importantly, gives our scientists a platform to explore their ideas around our data repositories.

Improvements to My Organization

In the past five or six years, we've moved away from multiple one-size-fits-all solutions attached to the various data warehouses to using Spotfire as a single point of entry to explore all (well... most) of our data repositories. We now have a team that works with the data stakeholders to make sure the data is federated and presented to the users appropriately. Operating under this model allows us to aggregate data at the project level and takes that burden from the users which allows them to do more science.

Room for Improvement

In the past few years, web-based analytics has come a long way. I would like to see Spotfire evolve into a product that handles the data volume with in-memory architecture (or some equivalent technology) server-side, but lets us feed the results into any web-based visualization that we can get our hands on.

Use of Solution

We brought Spotfire in-house in the pre-Tibco era of Spotfire DecisionSite. I'm guessing I have been using it about 10 years.

Deployment Issues

Our environment is two application servers and one web player server. Getting all the pieces operating inside of our corporate IT infrastructure was challenging, but the end result does serve well over 1000 thick-client and web-based users.

Customer Service and Technical Support

Being a life sciences company, our support comes from Perkin Elmer rather than Tibco. They have provided us with very good support.

We are running Spotfire with Perkin Elmer's Lead Discovery extension to handle chemical structures.

Implementation Team

We have implemented our last couple of major upgrades with an in-house team with remote vendor support. I would recommend this if you are building a large Spotfire environment. Both Tibco and Perkin Elmer can provide that type of support.

Other Advice

My rating for Spotfire is relative to similar software. In my opinion, no other product handles both the large volumes of data and has an easily managed extension to handle chemical structures along with the data.

Rating the software on its own relative to the capabilities I would like to see in a data analysis suite, I would put it at 6/10. It is not trivial to use the API to expand the capabilities of the software and it is cumbersome to manage the content/servers/feature licenses.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
TIBCO Spotfire
March 2024
Learn what your peers think about TIBCO Spotfire. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,578 professionals have used our research since 2012.
Digital Asset Manager at a energy/utilities company with 51-200 employees
Real User
Excellent for scientific applications with a good ability to customize
Pros and Cons
  • "Spotfire is excellent for scientific applications, especially because of its integration with RNG."
  • "The handling and consumption of realtime data could be improved."

What is our primary use case?

As a service company, we were using Spotfire for things like timesheet analysis for our own purposes. What was more important was that we were advising our corporate customers, chemical, oil and gas companies like Shell, Total, and Exxon about where they should use this tool and how to develop an application using it. I'm really on the service side and Spotfire was a tool that I could offer to my customers for delivering projects.

In terms of use case, process data analysis would be number one. Then I'd say industrial performance dashboard, and lastly, problem root cause analysis.

How has it helped my organization?

I championed the use of this solution in my company (an engineering service company) and ultimately we delivered a lot of projects. Often, we were working on development, more specifically user interface development, graphical user interface, and other things that were extremely costly and time consuming. When the BI tools arrived, it seemed to be a very fast way to not only analyze data, but also provide interactive dashboards to people, which before would've required the development of a custom tool. This would've been magnitudes higher in terms of price, so I really saw an opportunity there with the BI tools.

At this stage, it was clear that Spotfire was the top runner. I don't have much experience with Tableau, but clearly for scientific applications, Spotfire was awesome. Especially because of its integration with things like RNG. As an engineer, I was very excited.

What needs improvement?

To be completely frank, the main problem of Spotfire is that it's being destroyed by Power BI. That's the only problem. Otherwise, the product is superior from a technical perspective, but they are victim of an extremely aggressive strategy from Microsoft and therefore, become far too expensive because Power BI is free in organizations. That's Spotfire's biggest weakness.

Another thing is the realtime boarding capabilities and the integration with other realtime streaming products should be much easier. The handling of realtime data could be improved.

I would also improve the consumption of realtime data. I'd also probably improve integration with the RNG, and generally speaking, the data science techniques. I think this is where Spotfire can still play a role and be competitive compared to Power BI. Other than that, I love the product, but I don't know how they can survive the offensive of Microsoft commercially.

For how long have I used the solution?

I have been using this solution for around six years.

What do I think about the stability of the solution?

I've had projects running for a while and have no particular complaints about stability. Originally, Spotfire is an offline analysis tool, so stability isn't a huge issue. It's much more of an issue when you do realtime statistical treatment with realtime data . That's where I mentioned they have to improve. 

Tipco is a huge company and they have this policy of acquiring software all the time, which is an interesting yet aggressive policy for development. The problem when you keep acquiring companies is that at some point, you have to integrate the products. That's where things tend to take a lot of time. Afterwards, the integration can sometimes be wishy washy and I think this is what happens in the realtime space. 

Spotfire has identified that there was something in the market that was asking for the consumption of realtime data and the provision of realtime dashboards and analysis. What they've done is half integrate another product that they bought and I found this strategy weak. I think this is where the stability will really become a critical factor, but overall, I would say so far so good.

What do I think about the scalability of the solution?

I think scalability is pretty good. I've seen customers running thousands of reports. For reaching good scalability, it also depends on your network architecture and whether you host it on cloud or not. I would say there's nothing in the software that really worries me, but you can always mess it up.

How are customer service and support?

Overall it's quite good. As a partner, there's a big difference because my request for assistance is usually prioritized over regular customers. I probably had access to the hotline, but it's very clear that when you're a partner and you meet the commercial team, they know that you're pre-sale, and so you get a lot better answers from them than you do from the hotline. Overall, I have nothing to complain about, but I'm not blown away either.

How was the initial setup?

It depends how you deploy it and the use case. If you just want to install it on your computer and get going for self-service usage, that's a matter of five minutes, so that's extremely easy. If you want to deploy it at the corporate level with the web server, that can be more complex. For a corporate analysis solution or corporate dashboarding solution, it's more complex, but also not unexpected.

When you've installed or deployed the software in your company, you're still nowhere; that's probably the IT department's problem generally speaking: Is the product installed? Is someone doing something with it? Is there the necessary skillset around it? Are your engineering and technical personnel able to operate it on their own? That seems to be the least of their worries, but this is why you pay for the software. 

I would say that in terms of a deployment strategy, everyone will do the ITPs. If you have an IT person in your company that knows half of what they're doing, there's no problem. You manage. 

Nevertheless, putting a correct strategy around the use of business intelligence tools in the organization, it's relevant to ask: What will we use it for? What kind of training will we provide? What kind of algorithm will we develop on top of that? I told you that as an integration with the RNG, for example,which is extremely powerful, I think these are big questions that people often forget.

They think that just by a data science or dashboarding tool, results will come out of it miraculously, but no results come out of the software. Results come out of people using the software, so I would say the challenge in terms of a deployment strategy and the time it takes is a complete function of the ambition level that you have. We can deploy it in one night, but then it has no impact on the company and if you really want to make an impact on the company, then I believe that you are looking at deployment activities, which are much longer. Particularly after the deployment, you should probably do something to maintain the life cycle of the product. So I would say an ideal deployment is deployment that never ends.

To summarize, I would say from a technical point of view, deployment should be the least of your problems. It can be easy. Nevertheless, using a quick strategy around the use of business intelligence, that's something different. I believe that all decision makers should really focus their attention on this and not on something as silly as whether the solution is easy to install.

What other advice do I have?

I would rate this solution an eight or nine out of ten.

It's one of the best products I've worked with in my career. Especially in the engineering, oil and gas, or chemistry fields. A long time ago, you found a lot of niche software players, which were terrible software. Being able to introduce something modern like Spotfire was really fresh air for us. It's an excellent product. The ability to customize as well is really good. 

Particularly for us, because as a service company, we tend do things that are a bit more advanced than what the production people do and therefore, I was very pleased with it. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Vice President at a insurance company with 1,001-5,000 employees
Vendor
One of the main features is integrated statistical analysis. Compared to competitors, the UI is quite dated.
Pros and Cons
  • "One of the main features is integrated statistical analysis."
  • "Compared to competitors, the UI is quite dated."

What is most valuable?

One of the main features is integrated statistical analysis. At time of first purchase, presentation of tree maps was important, but competitors have closed that gap.

How has it helped my organization?

The same way any visualization product has improved things.

What needs improvement?

Compared to competitors, the UI is quite dated.

For how long have I used the solution?

Personally, I have used it for six years. In this organization, I have used it for three years.

What do I think about the stability of the solution?

The server product can have stability issues for certain use cases. The desktop product is fine.

What do I think about the scalability of the solution?

There were no scalability issues.

How are customer service and technical support?

We did not try technical support.

Which solution did I use previously and why did I switch?

We are a large organization, and so have Tibco and most of its competitors deployed in one place or another. So there hasn’t been a “switch” as much as an addition.

How was the initial setup?

The desktop product installation is straightforward. Don’t know about the server.

What's my experience with pricing, setup cost, and licensing?

Negotiating large/enterprise licenses has been a trial. The Tibco sales teams have been very difficult to work with - ignoring requests, misrepresenting level of demand, etc. Careful due diligence is required with any (and I do mean any) representation made during the sales/contracting experience.

Which other solutions did I evaluate?

We evaluated all of them.

What other advice do I have?

Keep an eye on competitors - the usual suspects like Tableau and Qlik as well as tools like Alteryx. There are still use cases for teams/applications where Tibco is a clear choice based on features and price, but the gaps are narrowing quickly. Add to this that your teams and processes are maturing, and may be maturing more quickly than the product suite deployed for them. It’s a mistake to just renew current products as, in many cases, the cost to change is coming down as well.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Business Analyst/Project Manager at a energy/utilities company with 501-1,000 employees
Real User
Great product for admins and for end users. Vendor listens to customer input.

Valuable Features

From an administrator’s standpoint, the most useful component is the Information Designer, which allows one to design links to SQL/Oracle/etc. datasets that query the source system when opened or refreshed. This provides the user base a self-service approach and ensures the query design is not something that jeopardizes the source system or warehouse.

From an end-user standpoint, the most useful features to me were data manipulation capabilities. Spotfire allows users to easily join multiple datasets (from Info Links, spreadsheets, etc.) and create calculations and visualizations against them. With a bit of experience, end users will find Spotfire wonderful for ad-hoc analysis. The other great capability is the extension with R allowing users with R code snippets more visual capabilities (comes with the Advanced Analytics module, I believe).

Improvements to My Organization

In my previous organization, Spotfire added a great deal of value by allowing Reservoir and Production Engineering teams self-service access to production and well data. Spotfire allowed our teams to query datasets for their analysis through the pre-defined lens that we had created in Spotfire. In addition, it allowed them to manipulate the data without introducing any risk to the source systems.

Room for Improvement

The administrative component of Spotfire could use some attention. The Information Designer tool is wonderful, but a level beyond that with hotfixes, updates, and security administration, things get complicated quickly. I have heard that other BI tools in the space are easier to administer.

There are basically two types of Spotfire administration, admin(s) who setup access to data and control the Spotfire library/ies, and admin(s) who manage the Spotfire server and component implementation. Usually, these are not the same person. The administration that involves setting up Data Sources, Data Elements, Filters, and Information Links comes very easily utilizing the Information Designer tool in Spotfire. The administration that is a pain is server administration, mainly because transferring Spotfire files/projects from one environment to another (test to prod during an upgrade) involves exporting the Spotfire library to file storage and then importing it into another Spotfire library. This was the approved method during my day. However, we ended up just doing database copy and refreshes to avoid that entire process.

It is unusual for IT to administer a software suite without the normal dev/test/prod processes. However, with Spotfire and some other BI tools, mass amount of end users create content only in the production environment. In many situations, a Spotfire admin would necessarily make library changes directly in the production environment because it is required to support their users. For Spotfire, it is important early on to define change control processes and procedures, to ensure quality control without limiting end user functionality (which is why you bought Spotfire to being with). Any changes to server or database configuration should go through normal test/prod processes but changes to the Spotfire library sometimes should not (because you are supporting a living and breathing thing with users creating and utilizing content).

Room for improvement would be more guidance up front on these real-world administration scenarios. I don't remember any guidance in these areas and ended up learning much of this the hard way. It is information that folks in the community share, but never gets formalized.

This only applies to enterprise implementations using Spotfire server, not stand alone installations not connecting to a Spotfire library.

Use of Solution

I have been using the solution for five years, including previous versions (5.0, 5.5, 6.0, 6.5). I haven’t used 7.5.

Stability Issues

We encountered a number of issues with certain Spotfire projects (.dxp files) after completing upgrades. These files were extremely complicated with R snippets running, and numerous datasets, transformations, and calculations being performed by the file. Spotfire allows users to create files that should not be created. In these cases, stability of a file is an issue. Stability and scalability of the solution itself is solid.

Customer Service and Technical Support

Customer Service:

Customer service is excellent, quick to respond and knowledgeable.

Technical Support:

Professional Services on the other hand is more questionable. I have had wonderful service from some technical staff, but I have also worked with some I would not wish on my worst enemy. It will be important for customers to find PSG resources they trust or to find another experience through a TIBCO partner, etc. I can suggest a number of these to anyone with interest.

Initial Setup

The initial setup is quite easy, made easier if you’re blessed with a good DW. Only when you start adding administrative features and distributed user bases with different security requirements does the solution become a pain to administer.

Implementation Team

Initial implementation was done before my time. I performed two major upgrades, one with the vendor on-site for two weeks, one alone. I had no issues with the one performed alone. That being said, new departments offering Spotfire as a solution will need support for their first couple hotfixes and upgrades. Refer to what I wrote regarding Professional Services.

Pricing, Setup Cost and Licensing

My previous employer purchased an enterprise license that accommodated our sharp spike in users (tripled user base in two years). Licensing the thick client versus the web developer or web consumer is critical for technical users. This is dependent upon the company and personnel using the tool. Technical users such as engineers or planners will most likely require the professional client. Light-touch users in organizations who’d rather receive a PDF than perform calculations and pivots will have web-client needs only. Picture MS Excel: If your users are Excel users, they will be thick-client/professional/expensive version users.

Other Solutions Considered

I’ve used other solutions in the space including Tableau and SAP BusinessObjects; even Excel and Access can roughly be considered a competitor of Spotfire. I prefer Spotifre to Tableau and BOBJ due to its flexibility and technical capability. Both Tableau and BOBJ seem more structured and stiff. Although beautiful, they sacrifice abilities for tech-savvy end users in return for a friendly-for-all, drag-and-drop, easy-to-print, set-it-and-forget-it-feel. In a bi-modal environment (one tool for key non-changing reports, a different tool for ad-hoc analysis), Spotfire wins the ad-hoc battle versus common competitors.

Other Advice

Spend time scoping the security/folder setup as well as the “Information Links” (queries Spotfire allows users to run). Changing either of these components after users construct their beautiful files against them is a very unpopular thing to do. Predict the dependencies you’re going to create and be strategic in your design.

Spotfire became everyone’s favorite tool if they could learn how to use it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user494067 - PeerSpot reviewer
Senior Analytics Consultant at a pharma/biotech company with 1,001-5,000 employees
Vendor
Build everything from data discovery , to enterprise reports, to simple dashboards, to predictive analytics and beyond

What is most valuable?

  • Data engine: numerous methods to load load, transform, and merge data from every major data source.
  • Web player: out of the box ability to share analysis through web browser. Advanced web functionality to customize with portals.
  • Analytics: basic stats functionality out of the box and ability to connect to all major analytics vendors/languages (SAS, MatLab, R, etc.).
  • Visualizations: equally suited for data discovery and reports.

How has it helped my organization?

  • Tibco Spotfire analysts from building Excel and PowerPoint reports and allows them to start analyzing information.
  • Standardizes metrics and flow of information within organizations.
  • Simple enough for non-tech users to use, but powerful enough for power users to produce advanced analytics.

What needs improvement?

  • Integration with a custom web portal is still challenging.
  • Version control should be included to aide development processes.
  • Further the out-of-the-box ability to customize visualizations.

For how long have I used the solution?

I've been using it for over five years, starting with v3.

What was my experience with deployment of the solution?

Initial deployments are normally issue-free. Spotfire supports numerous data sources, authentication methods, load balancers, and other IT environment configurations. Spotfire v7.5+ is a significant change in architecture and will require a different configuration and additional admin training.

Upgrades normally require minor adjustments to some Spotfire analyses. There are Spotfire tools to assess differences between files in each version and the change in performance.

What do I think about the stability of the solution?

The most common issue is insufficient resources on host servers or laptops. Most other issues arise from custom applications integrating with new versions of Spotfire.

What do I think about the scalability of the solution?

I’ve worked with deployments and upgrades at small organizations and all the way up to 20,000+ user organizations. Spotfire can be scaledeasily, but requires planning and is dependent on the underlying technology (as with any software).

How are customer service and technical support?

Customer Service:

Improved dramatically in recent years with rapid releases of updated versions.

Technical Support:

Professional and timely support. The Spotfire upgrade roadmap is a bit opaque though.

Which solution did I use previously and why did I switch?

Previously I have used Tableau, Business Object, SAS JMP, MiniTab and Excel. Spotfire is most commonly compared against Tableau, Qlik and MicroStrategy. Spotfire is typically selected for its data engine, web player and advanced analytics capabilities.

How was the initial setup?

It's generally straightforward except for when custom applications, e.g. in-house developed software, are to be configured with Spotfire.

What about the implementation team?

Usually large scale implementations are done by a vendor, but small scale deployments are possible with an internal team. Beyond the basic requirements, the key is to understand scalability needs, community use cases, authentication needs, and data architecture needs. Upgrades can be handled in-house.

What was our ROI?

ROI can be measured by how much time is saved by your analysts no longer needing to build reports. Typically, a core group of users build the Spotfire templates and everyone else in the organization analyzes information in the templates. Other than upkeep, once a template is built in Spotfire, your organization can analyze information and take action. Also, the time and sanity saved in no longer sharing PowerPoint slides or Excel spreadsheets throughout the organization can be priceless.

ROI can also be measured by the fact that Spotfire can integrate with existing IT infrastructure and existing IT expertise. Eg. Spotfire can make use of your existing SAS environment to apply SAS models and SAS expertise to data in Spotfire (which is then visualized).

What's my experience with pricing, setup cost, and licensing?

I recommend training a core group of analysts to build your Spotfire templates. The rest of your organization can use the less expensive Web Player licenses to analyze the data through their web browser.

What other advice do I have?

I also recommend the Spotfire Automation Services component. It allows Spotfire to automate certain tasks like loading data at defined times, sending automated emails, sending alerts, etc.

Disclosure: My company has a business relationship with this vendor other than being a customer: I work for the vendor PerkinElmer. PerkinElmer is the exclusive life sciences vendor for Spotfire.
PeerSpot user
it_user494847 - PeerSpot reviewer
Sr. Engineering Manager, Technical Fellow at a manufacturing company with 10,001+ employees
Real User
No row/column limitations. Many of our datasets of interest have tens of millions of rows and hundreds to thousands of columns.

What is most valuable?

Ability to connect to multiple databases. This is important because our company uses many different database solutions across the functional and geographic areas of the organization. Spotfire can map to all of them.

In-memory interactive capability to work with the data. The tool is relatively easy to use without any training, but has many features to slice and dice data in sophisticated ways.

No row/column limitations. Many of our datasets of interest have tens of millions of rows and hundreds to thousands of columns. Spotfire handles these situations with relative ease.

How has it helped my organization?

Many users have developed dashboards for management review that are now automatically generated, as opposed to something that requires many hours per week or month.

Some people are using Spotfire to provide analysis updates in meetings as opposed to using static PowerPoint slide decks. This allows for more interaction with the data, as ad-hoc questions can be answered by manipulating Spotfire to display data as requested.

Expert users can deploy analytic platforms for data that are periodically generated, which less-experienced analysts can then use to make good decisions. For example, yield review of batches of material received in manufacturing.

For how long have I used the solution?

The original version of the system was called DecisionSite, which we installed in 2004. We have maintained continuous capability since that time as the tool has changed over the years.

What was my experience with deployment of the solution?

No specific deployment, stability or scalability issues. We have a dedicated admin who maintains the servers, installs patches, and updates Spotfire to major new revisions as they become available. We have encountered issues and have got them corrected as necessary, but overall the platform is very stable. We have facilities across the world that are using it, so it is generally available 24-7. The Web Player version is heavily utilized, which has required hardware upgrades over the years to keep performance up.

How are customer service and technical support?

Technical support is acceptable, but not superior. Sometime after TIBCO purchased Spotfire (the company), they outsourced support to Perkin-Elmer. For minor problems, P-E is capable of finding solutions, but problems that require more detailed knowledge of the tool often take very long to resolve. P-E has to go back to TIBCO for assistance in these cases.

Which solution did I use previously and why did I switch?

We had a number of different tools, some off-the-shelf and some home-grown, before we chose Spotfire. When we decided to look into other options, we evaluated several tools in addition to Spotfire. We eventually chose Spotfire based upon a detailed comparison of its capabilities against the other contenders, including the features mentioned elsewhere in this review.

How was the initial setup?

The installation itself was fairly straightforward, but building up the database connection infrastructure has been an ongoing process. Although it is not problematic in the sense of having issues or bugs, it requires someone with good relational database skills to optimize the Information Model.

There are many tool configuration options that can be set during installation. Most of the default options appear to work well, although we have found a few that required modification in order to optimize the platform to our specific IT infrastructure and user preferences.

What about the implementation team?

We installed Spotfire in two distinct phases: initially, when it was DecisionSite, using an on-site Spotfire team for the heavy lifting, and then a second round when the current version of Spotfire was released. The second round was mostly performed by our in-house admin, with support from Spotfire. This all happened before Spotfire was purchased by TIBCO.

One claim to fame made by Spotfire is that doing sophisticated analyses does not require a team of IT professionals. This spreads the burden of report generation and ad-hoc analyses to the experts in the data itself, which we have definitely seen to be a benefit. We can use the tool without having to write detailed requirements, learning and experimenting as we go before setting up validated dashboards and other reports.

Find first-adopters and enthusiasts in your organization. If you have data, these folks exist. Let them play around with the tool, and then leverage their acquired skills to evangelize.

What was our ROI?

On a per-user basis, we are saving several hours per week of analysis time. This has been especially impactful for analysts who had been spending as much as 20% to 50% of their time managing and summarizing data each week, and who now have time to generate more detailed analyses in less time. This leads to better insights into the data, and has resulted in more targeted actions to address improvement opportunities.

For ad-hoc analyses, Spotfire allows us to manage much larger datasets than we had ever been able to look at before. This has led to many breakthroughs in productivity, customer focus, supplier management, issue resolution, etc. It is difficult to quantify these situations, but in many cases, we believe we reach solutions faster with Spotfire than we would have done otherwise. In one specific case during our initial evaluation, a large team had been working on a manufacturing yield issue for a month without nailing down the root cause. We decided to apply Spotfire (then DecisionSite) to the data, and literally within 15 minutes we had narrowed the problem down to a specific piece of equipment at a supplier facility. What made this possible was the ease with which we could aggregate the data in ways we had not been able to do without Spotfire.

What's my experience with pricing, setup cost, and licensing?

For licensing, try to obtain as broad a user base as possible. TIBCO offers a variety of licensing schemes, including less-costly individual licenses for the view-only version called Web Player. In order for that tool to be useful, you will need a number of people who are experts in Spotfire Professional to deploy analytic solutions.

What other advice do I have?

There are many options available that are built upon the Spotfire platform (S+, Operations Analytics, Lead Discovery, Cloud, etc.); make sure you review the capabilities of each before deciding which to include.

Determine how organized your internal data sources are, and then put together a strategy for how to build the Spotfire Information Model that will best utilize these resources. Unless you are very confident in your ability to execute, do not attempt to consolidate all of your data sources into one large warehouse. Spotfire works very well with many individual databases, so you may find that a better solution is to construct specific analytical tools within Spotfire that aggregate the data on-demand.

We have a small cadre of individuals who host a weekly online training session. Users can call in with specific questions about analyses they are currently performing. We have found this extremely beneficial in improving the level of Spotfire skill across the corporation. It only takes a handful of people to make this work, and the time investment is minimal, so it’s well worth the effort.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user3768 - PeerSpot reviewer
Consultant at a financial services firm with 10,001+ employees
Vendor
Great alternative to Excel and Pivot Tables, but lacks ability to fine-tune appearance options

What is Spotfire'

Spotfire is a BI (business intelligence) tool that enables you to explore and represent “big data” sets. It’s one of a class of tools that focus on making it easy to explore masses of data without being a database ninja. It’s head-to-head with tools like Tableau and Qlikview. I’d previously been put off trying Spotfire partly because Tibco had a head-spinning number of industry-specific variants and I had no idea where to start. Thankfully they have simplified their product range to one product, with variants of funtionality based on how much you are prepared to pay. This is a review based on my personal experiences over the last few weeks of using Spotfire, so I’m not going to comprehensively review all the feature set, just those that I have used and found noteworthy. So is Spotfire the solution to your data analysis hassles'

User interface – what’s it like to drive'

Spotfire’s interface is a teeny bit introverted. It has a clean simple interface that really doesn’t let you know what delights lie within. Unlike a package like Tableau, which has plenty of “user interface bling”, much of the functionality is tucked away in property dialogs that you need to call up with a right mouse click. So you are presented with pretty plain interface. There’s a big button in the blank workspace that will take you to Spotfires introductory tutorial (well worth checking out, but pretty brief).


The first thing you see when Spotfire opens

Getting data into Spotfire

The first thing to do is to open the data you intend to analyse. For Excel data this is a doddle, just go to the little folder icon and open your spreadsheet.


You click the folder icon to connect to your data

You will be asked which tabs you want to import and which columns. Intuitive and simple…


Choosing which data you want to import from an Excel workbook

Opening data from a database is a little more convoluted (by necessity) requiring details of the database and of the SQL query you would like to run.

Analysing data

It can take a while to import the data into Spotfire (a couple of minutes for my query to a 15GB SQL database) but this may be more a function of my database server than Spotfire. It took about 35 seconds to open a 80MB, 800,000 (30 columns) row spreadsheet.

Once the data is imported you are ready to start analysing the data. Filters give you lots of flexibility about which data you include or exclude. You just select your chart (or table) type from the icons at the top and drag and drop your data into the chart. If you have used pivot tables it’s a similar routine. This is the bit that makes you go “wow”. The charts refresh almost instantly. You then fine-tune your analysis by telling it what type of aggregation you want (for example count, sum, median etc.) You do this by clicking the little arrow on the axis label.


With a few clicks the charts start to make sense

You can nest the axis, so have “months” with”day of month” nested within it. Because of the way Spotfire handles dates there is pretty much complete flexibility with how you structure time axes (it splits dates out in numerous ways, allowing you to mix-and-match those elements).

You can do just the same process with tables as well, or mix and match charts and tables with a “Graphical Table” that allows you to drop Sparklines or Bullet charts in cells next to the data – very nice.

Laying out charts and tables – working your dashboard magic

Once you have created your first chart, chances are you will create another. You have two options, either drop another on the same sheet – building a dashboard, or you create another “tab” with your new analysis on. If you put more than one chart on a tabbed page you can use the buttons on the toolbar to arrange them or just manually drag the border to resize the windows. You can add text or data windows onto the same page.


A simple Spotfire dashboard whipped up in a few mouse clicks

Filters – your new best friend – if you can work them out

Filters are really important in Spotfire. They enable you to choose which data you are going to show from a given column, allowing you to exclude certain data (just like filters in Excel, but a bit more elegant). Maybe I’m a bit stupid, but I was surprised that changing the filter on one page affected every other tab in the workbook. After a little Googling I discovered that filters don’t apply to just the page you set them on. You need to create a new filter and then apply it. This isn’t very intuitive as the “Show filtering scheme” option is turned off by default, you need to go into “Document properties” then select the “Filtering Scheme” tab to turn it on – not very obvious at all. Once you have worked this out, filters and simple and easy to use.


The pesky (and important) “Show filter scheme menu in Filters Panel” option

Calculated Columns – super handy feature for all your calculation needs

There’s almost certainly a lot more  functionality buried in Spotfire, but one feature I found myself using was “calculated columns”. Let’s say you have columns called “weight” and “height” and you wanted to have “Body mass index” (kg/(height squared)) you would go Insert>Calculated Column. You are presented with a page that enables you to build an expression based on available columns, available column properties and a list of possible functions.


The expression builder for adding a calculated column

When you are done building your expression you give your column a name before clicking “OK”. It’s simple enough that I didn’t need to look at the documentation once – perfect.

Visualisation of data – charts, graphs and other bling

I have simple tastes when it comes to representing data, rarely branching out past column, line and scatter plots. Spotfire has a good selection of ways of plotting data, including heatmaps, maps, treemaps and all the usual suspects. Here are a selection of examples….


A simple Spotfire heatmap


A Spotfire scatterplot

When appropriate, there are lost of options to vary marker size, colour and even shape based on data. It’s best not to get carried away with this but it can allow you to squeeze some vital extra data onto your visualizations.


A Spotfire treemap

Likes

With the exception of intially loading the data set, Spotfire pounded through the analysis I threw at it. One of the data sets was a 15GB SQL database, another was a 800k line Excel workbook. It returned the analysis almost instantly in both cases. Jaws dropped as my colleages (used to Excel) saw the speed and ease of cutting data. As one of my team said “That tool would completely have replaced my job at the last bank I worked at!”

There seems to be good forum support, most queries you have can be resolved with a couple of minutes Google research.

There are some real time-savers, like the ability to import and export corporate colour schemes. You can also drag and drop data, with clever – icon based – targets that let you determine how the dragged data is used, like this….


The clever icon tool bar makes dragging and dropping data into charts easy

It handles things like dates brilliantly, breaking them down into any combination of day, week, month, quarter, day of week. It’s a breath of fresh air and makes periodic analysis really simple.

It is wonderfully fast, at least on the data set I used.

Confused by

  • Things such as changing the order of data series can be a bit non-intuitive.
  • Filters can take a little figuring out, but are very straightforward once you understand how to set them up and switch between them.
  • Changing the colour scheme is also not very intuitive, but a huge time saver in a corporate environment once you have figured it out.
  • Refreshing data when a spreadsheet changes.

Dislikes

PowerPoint slide export has the potential for greatness but is let down by it’s execution. The exported slides are a bit of a mess, with both images and text a bit too large and badly laid out. You will end up having to hand tweak each slide. I guess Tibco expect users to serve up their dashboards over the corporate intranet but in reality most of my clients still function of the PowerPoint-Email distribution system. I didn’t have the opportunity to test it’s ability to serve up analysis as web pages, but I think it’s quite a big part of Spotfire’s feature set.

The other irritating aspect of the package is the way that axes are labelled. They are logically labelled based on the data source (e.g. Record Count) and the aggregation type (e.g Unique Count). This is all handled automatically and is fine most of the time, as long as you don’t mind axes with labels like “Unique Count(Record Count)”.  If you want to “fine tune” the labels for the “sensitive senior exec types” of customer you will find yourself fiddling about in PowerPoint trying to overlay a text box with the revised label over the top of the image from Spotfire. Not great when you are in a hurry.

Some of the spreadsheets I tried to connect to managed to choke Spotfire (and not through their size, the problematic ones were tiny) – necessitating a trip to Task Manager to kill the program. After a quick copy>paste special>paste values and format into a new sheet and everything seemed to work OK. Workeable but very tedious when there are lots of revisions going on. It may not be a Spotfire issue, but Excel had no issues opening and editing these workbooks.

Verdict

Using Spotfire you get the feeling that someone finally got fed up with messing around with Excel and Pivot tables and decided to implement that approach, but properly.

The whole tool feels nicely focussed around cutting, analysing and displaying data. It doesn’t try to spread itself too thinly and really succeeds at what it sets out to do. One example of this focus would be on scatter plots. I needed to plot a number of points that were nearly co-incident. Spotfire has a dedicated “jitter” control that will jiggle the points about (with the ability to vary the “jitter” amplitude), so you can sacrifice precision for readiblity – brilliant!

Where I found myself getting a bit frustrated was in trying to fine-tune some of the appearance options. For example, on my scatter plot you can label the points, but the only thing you can change on the labels is the font size. You are stuck with a crude enclosing box, no choice on background or on the colour or weight of lead-line to the point.

Part of the reason these minor formatting issues grate is that the rest of the workflow with Spotfire is a delight. Once you have got into the way the package works (a couple of days of light use and you should be there) it is a joy to use. It is fast, logical and flexible. If you find yourself regularly using pivot tables, producing lots of charts or creating dashboards in Excel you really owe it to you (or your team) to check this tool out, it could transform the way you produce analysis.

Trying Spotfire out – getting a free trial

You can try Spotfire out by visiting their site here. You get 2 weeks of the full product and after this it drops back to the “personal edition” which drops a number of the more useful chart types, the abilty to export to PowerPoint and connections to databases (limits you to Excel spreadsheets).

Disclosure

I didn’t get paid a bean to write this article – just so you know.

Version tested 4.5.0.33

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user5052 - PeerSpot reviewer
it_user5052Director of IT at a tech vendor with 10,001+ employees
Vendor

Great review. We are just starting to deploy spotfire in our company for advanced visualization and analysis capabilities. It has been well received. The challenge has been query performance with larger data sets. One of our use cases is pulling twelve years worth of warranty data for failure rate analysis. been a struggle tuning performance. we are starting to use of the in-memory caching capabilities. that is helping.. Need to see more improvements in delivering/distributing/collaborating with the analysis and also with the mobile capabilities

Buyer's Guide
Download our free TIBCO Spotfire Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
Buyer's Guide
Download our free TIBCO Spotfire Report and get advice and tips from experienced pros sharing their opinions.