MS SharePoint / SQL vs. Spotfire

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
MS SharePoint / SQL
Score 8.1 out of 10
N/A
MS SharePoint / SQL refers to Microsoft Sharepoint, a web-based collaborative platform, being used in tandem with Microsoft SQL Server to provide business intelligence analytics and reporting. They can provide BI content such as data connections, reports, scorecards, dashboards, and more.N/A
Spotfire
Score 8.6 out of 10
N/A
Spotfire® is a data visualization platform that utilizes predictive analytics. In addition to data viz, it includes data wrangling capabilities, predictive analytics, location analytics, and real-time streaming analytics. Spotfire® is a business unit of Cloud Software Group, formerly known as TIBCO Spotfire.
$0.99
Per Hour (Starting)
Pricing
MS SharePoint / SQLSpotfire
Editions & Modules
No answers on this topic
TIBCO Spotfire for Amazon Web Services
$0.99
Per Hour (Starting)
TIBCO Cloud Spotfire - Consumer
$250/yr
per seat
TIBCO Cloud Spotfire - Business Author
$650/yr
per seat
TIBCO Cloud Spotfire - Analyst
$1250/yr
per seat
TIBCO Spotfire Platform
Please contact TIBCO sales
TIBCO Spotfire Cloud Enterprise
Please contact TIBCO sales
Offerings
Pricing Offerings
MS SharePoint / SQLSpotfire
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsFor Enterprise engagements, please contact TIBCO directly for a custom price quote.
More Pricing Information
Community Pulse
MS SharePoint / SQLSpotfire
Top Pros
Top Cons
Features
MS SharePoint / SQLSpotfire
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
MS SharePoint / SQL
8.9
55 Ratings
8% above category average
Spotfire
8.3
299 Ratings
1% above category average
Pixel Perfect reports8.936 Ratings8.030 Ratings
Customizable dashboards8.653 Ratings9.1294 Ratings
Report Formatting Templates9.145 Ratings7.9258 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
MS SharePoint / SQL
9.0
52 Ratings
10% above category average
Spotfire
8.2
311 Ratings
1% above category average
Drill-down analysis8.942 Ratings8.3289 Ratings
Formatting capabilities9.552 Ratings7.8302 Ratings
Integration with R or other statistical packages8.030 Ratings8.3224 Ratings
Report sharing and collaboration9.750 Ratings8.5274 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
MS SharePoint / SQL
9.0
56 Ratings
7% above category average
Spotfire
8.3
283 Ratings
1% below category average
Publish to Web8.852 Ratings8.2228 Ratings
Publish to PDF8.048 Ratings8.6267 Ratings
Report Versioning8.745 Ratings8.018 Ratings
Report Delivery Scheduling9.740 Ratings8.4178 Ratings
Delivery to Remote Servers10.032 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
MS SharePoint / SQL
9.2
34 Ratings
13% above category average
Spotfire
8.2
310 Ratings
1% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)8.933 Ratings8.7306 Ratings
Location Analytics / Geographic Visualization10.032 Ratings8.4271 Ratings
Predictive Analytics10.029 Ratings8.1234 Ratings
Pattern Recognition and Data Mining8.01 Ratings7.68 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
MS SharePoint / SQL
9.3
67 Ratings
8% above category average
Spotfire
8.1
250 Ratings
6% below category average
Multi-User Support (named login)10.059 Ratings8.7241 Ratings
Role-Based Security Model9.062 Ratings8.5206 Ratings
Multiple Access Permission Levels (Create, Read, Delete)9.466 Ratings7.8228 Ratings
Report-Level Access Control9.01 Ratings7.48 Ratings
Single Sign-On (SSO)9.053 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
MS SharePoint / SQL
9.2
57 Ratings
15% above category average
Spotfire
7.3
189 Ratings
8% below category average
Responsive Design for Web Access9.654 Ratings7.9177 Ratings
Mobile Application9.133 Ratings7.6126 Ratings
Dashboard / Report / Visualization Interactivity on Mobile8.038 Ratings7.5148 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
MS SharePoint / SQL
9.3
37 Ratings
16% above category average
Spotfire
8.3
89 Ratings
5% above category average
REST API9.028 Ratings8.371 Ratings
Javascript API9.926 Ratings8.370 Ratings
iFrames9.027 Ratings8.454 Ratings
Java API9.025 Ratings8.257 Ratings
Themeable User Interface (UI)9.032 Ratings8.269 Ratings
Customizable Platform (Open Source)9.923 Ratings8.560 Ratings
Best Alternatives
MS SharePoint / SQLSpotfire
Small Businesses
BrightGauge
BrightGauge
Score 8.9 out of 10
BrightGauge
BrightGauge
Score 8.9 out of 10
Medium-sized Companies
Reveal
Reveal
Score 9.9 out of 10
Reveal
Reveal
Score 9.9 out of 10
Enterprises
TIBCO Jaspersoft Community Edition
TIBCO Jaspersoft Community Edition
Score 9.7 out of 10
TIBCO Jaspersoft Community Edition
TIBCO Jaspersoft Community Edition
Score 9.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
MS SharePoint / SQLSpotfire
Likelihood to Recommend
8.8
(74 ratings)
8.6
(335 ratings)
Likelihood to Renew
8.8
(7 ratings)
8.2
(29 ratings)
Usability
9.0
(7 ratings)
8.0
(27 ratings)
Availability
-
(0 ratings)
9.0
(14 ratings)
Performance
-
(0 ratings)
7.1
(14 ratings)
Support Rating
8.7
(7 ratings)
8.7
(27 ratings)
In-Person Training
-
(0 ratings)
7.3
(52 ratings)
Online Training
-
(0 ratings)
8.8
(55 ratings)
Implementation Rating
7.0
(2 ratings)
8.0
(17 ratings)
Configurability
-
(0 ratings)
7.1
(3 ratings)
Ease of integration
-
(0 ratings)
7.0
(2 ratings)
Product Scalability
-
(0 ratings)
7.0
(4 ratings)
Vendor post-sale
-
(0 ratings)
5.0
(1 ratings)
Vendor pre-sale
-
(0 ratings)
5.0
(1 ratings)
User Testimonials
MS SharePoint / SQLSpotfire
Likelihood to Recommend
Microsoft
A simple and important scenario well suited is that you can configure alerts to notify you when the production server fails. another best feature is the report server is the central component of reporting services. For me something less appropriate is that the admin must ensure optimal performance for farm operations, they recommend that you install SQL Server on a dedicated server that does not run other farm roles and does not host databases for other applications.
Read full review
Spotfire
A high level of data integration is available here it supports various data sources and so on. Collaborating features allow users to give access to the dashboard and merge data analytics with other team members. It can meet the demands of both small and large size business enterprises. A customized dashboard and reports are provided to meet the specific needs and get support of extensibility through APIs and customized scripts.
Read full review
Pros
Microsoft
  • Flexible - able to make any changes we would like vs traditional service desk system.
  • ROI - We were already using SharePoint for internal intranet, so we are simply getting more use out of licensing we had already committed to.
  • Easy to use for end users.
Read full review
Spotfire
  • It has the best coding integration (python, R) of any BI product
  • The ability to work with very large datasets (10 mil+) is better than competitors
  • Export options are more complete and have better functionality
  • The data canvas is the best tool to join and transform data vs. competitors
Read full review
Cons
Microsoft
  • It is hard to setup and nightmare
  • It requires a of infrastructure, thus it could be costly because of requirement and licensing required for everything to run smoothly
  • If it is not setup and organized properly from the beginning it could be maintenance nightmare
  • It is hard to have "test" environment to do patches or similar
Read full review
Spotfire
  • The donut chart is I guess a powerful illustrations but I hope it should be done quite simple in Spotfire. But in Spotfire there are lots of steps involve just to build a simple donut chart.
  • Table calculation (like Row or Column Differences) should be made simple or there should be drag and drop function for Table Calculation. No need for scripting.
  • Information Link should be changed. If new columns are added to the table just refreshing the data should be able to capture the new column. No need extra step to add column
Read full review
Likelihood to Renew
Microsoft
This was a long-term buy-in from a corporate perspective, to remain in the SharePoint space. Migration is certainly possible, which is good for planning and having options further out. At this point, the only planned migration is to eventually move the architecture up to SharePoint/SQL 2013. At that point, we will be able to leverage some greater efficiencies, some enhanced content design and management features, and some more current social features. It is well worth a full consideration in any shop looking at a new implementation of or migration to SharePoint (although you will probably be considering 2013 versions or beyond in those discussions), but the platform should be a strong competitor to any alternatives. Realizing the capability of a fully-branded and customized website was not part of the original choice for the architecture at Lincoln, but seeing it implemented and functioning now with this capacity far beyond original expectations has certainly cemented plans to continue using it.
Read full review
Spotfire
-Easy to distribute information throughout the enterprise using the webplayer. -Ad hoc analysis is possible throughout the enterprise using business author in the webplayer or the thick client. -Low level of support needed by IT team. Access interfaces with LDAP and numerous other authentication methods. -Possible to continually extend the platform with JavaScript, R scripts, HTML, and custom extensions. -Ability to standardize data logic through pre-built queries in the Information Designer. Everyone in the enterprise is using the same logic -Tagging and bookmarking data allows for quick sharing of insights. -Integration with numerous data sources... flat files, data bases, big data, images, etc. -Much improved mapping capability. Also includes the ability to apply data points over any image.
Read full review
Usability
Microsoft
SharePoint is very complex. This makes usability somewhat difficult from an IT perspective. An IT generalist will be able to pick it up and run with basic tasks. More customized functions would require significant specialized training and therefore limit what a standard user would be able to achieve. From an end user perspective, it's pretty straightforward to use.
Read full review
Spotfire
Basic tasks like generating meaningful information from large sets of raw data are very easy. The next step of linking to multiple live data sources and linking those tables and performing on the fly analysis of the imported data is understandably more difficult.
Read full review
Reliability and Availability
Microsoft
No answers on this topic
Spotfire
Even though, it's a rather stable and predictable tool that's also fast, it does have some bugs and inconsistencies that shut down the system. Depending on the details, it could happen as often as 2-3 times a week, especially during the development period.
Read full review
Performance
Microsoft
No answers on this topic
Spotfire
Generally, the Spotfire client runs with very good performance. There are factors that could affect performance, but normally has to do with loading large analysis files from the library if the database is located some distance away and your global network is not optimal. Once you have your data table(s) loaded in the client application, usually the application is quite good performance-wise.
Read full review
Support Rating
Microsoft
It's been fantastic in terms of Premier Support so far. If there is an issue and if you report if the product has an issue, they will act upon it immediately. In some cases, if you design/develop something using the platform, Microsoft appreciates it and... publishes it on their public website. But you have to wait for some time if it is a non-Premier Support issue as you may experience delays.
Read full review
Spotfire
Support has been helpful with issues. Support seems to know their product and its capabilities. It would also seem that they have a good sense of the context of the problem; where we are going with this issue and what we want the end outcome to be.
Read full review
In-Person Training
Microsoft
No answers on this topic
Spotfire
The instructor was very in depth and provided relevant training to business users on how to create visualizations. They showed us how to alter settings and filter views, and provided resources for future questions. However, the instructor failed to cover data sources, connecting to data, etc. While it was helpful to see how users can use the data to create reports, they failed to properly instruct us on how to get the dataset in to begin with. We are still trying to figure out connections to certain databases (we have multiple different types).
Read full review
Online Training
Microsoft
No answers on this topic
Spotfire
The online training is good, provides a good base of knowledge. The video demonstrations were well-done and easy to follow along. Provided exercises are good as well, but I think there could be more challenging exercises. The training has also gone up in price significantly in the last 3 years (in USD, which hurts us even more in Canada), and I'm not sure it is worth the money it now costs (it is worth how much it cost 3 years ago, but not double that.)
Read full review
Implementation Rating
Microsoft
Not implemented in best practice way, there are many customizations
Read full review
Spotfire
The original architecture I created for our implementation had only a particular set of internal business units in mind. Over the years, Spotfire gained in popularity in our company and was being utilized across many more business units. Soon, its usage went beyond what the original architectural implementation could provide. We've since learned about how the product is used by the different teams and are currently in the middle of rolling out a new architecture. I suggest:
  • Have clearly defined service level agreements with all the teams that will use Spotfire. Your business intelligence group might only need availability during normal working hours, but your production support group might need 24/7 availability. If these groups share one Spotfire server, maintenance of that server might be a problem.
  • Know the different types of data you will be working with. One group might be working with "public" data while another group might work with sensitive data. Design your Library accordingly and with the proper permissions.
  • Know the roles of the users of Spotfire. Will there only be a small set of report writers or does everyone have write access to the Library?
  • ALWAYS add a timestamp prompt to your reports. You don't want multiple users opening a report that will try and pull down millions of rows of data to their local workstations. Another option, of course, is to just hard code a time range in the backing database view (i.e. where activity_date >= sysdate - 90, etc.), but I'd rather educate/train the user base if possible.
  • This probably goes without saying, but if possible, point to a separate reporting database or a logical standby database. You don't want the company pounding on your primaries and take down your order system.
Read full review
Alternatives Considered
Microsoft
At the time of the two large projects, SharePoint was the enterprise solution so we were required to use that. We have since lobbied the enterprise teams to review and consider Atlassian Confluence and were successful. Confluence is cheaper than Sharepoint which is why we wanted to bring that in. The enterprise has now made Confluence an enterprise solution as an alternative to SharePoint. After using both I think SharePoint has many more add-ins than Confluence. It has much more customization ability than Confluence. SharePoint is not good for mobile readiness. Confluence is so there is a difference that might lead you to Confluence over SharePoint. I would also say that SharePoint is very document-centric and that Confluence has better KM than SharePoint does. even with the use of SQL Server. We were told that we could not use Google Drive even though it had features we liked.
Read full review
Spotfire
Spotfire is significantly ahead of both products from an ETL and data ingestion capability. Spotfire also has substantially better visualizations than Power BI, and although the native visualizations aren't as flexible in Tableau, Spotfire enables users to create completely custom javascript visaualizations, which neither Tableau or Power BI has. Tableau and Power BI are likely only superior to Spotfire with respect to embedded analysis on a website.
Read full review
Scalability
Microsoft
No answers on this topic
Spotfire
In an enterprise architecture, if Spotfire Advanced Data services(Composite Studio),data marts can be managed optimally and scalability in a data perspective is great. As the web player/consumer is directly proportional to RAM, if the enterprise can handle RAM requirement accomodating fail over mechanisms appropraitely, it is definitely scalable,
Read full review
Return on Investment
Microsoft
  • I've installed SharePoint in many different industries and each industry has seen greater collaboration among their teams both locally and nationally. The ability to collaborate more efficiently has reduced the need to have employees centrally located.
  • Companies which have used SharePoint in a end user training portal have had great ROI, since they can create the content once and share with all their users who subscribe to their training service. The web content management aspect of SharePoint is a very helpful feature.
Read full review
Spotfire
  • It is costly, so not suitable for small scale implementations.
  • Dashboards are as good as the developer, so need experience to get most out of it
  • You need to be on Spotfire 11 at least to implement out of the box visualizations
  • Integration with Python and R is a game changer, it comes very handy to onboard data scientists without much hassle
  • performance is exceptionally well.
  • Secure
Read full review
ScreenShots

Spotfire Screenshots

Screenshot of Smart Visual AnalyticsScreenshot of Geospatial AnalyticsScreenshot of Intelligent Data WranglingScreenshot of Point-and-click Data ScienceScreenshot of Real-time Streaming Analytics