Try our new research platform with insights from 80,000+ expert users

Databricks vs Pyramid Analytics comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM SPSS Statistics
Sponsored
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
37
Ranking in other categories
Data Mining (3rd), Data Science Platforms (9th)
Databricks
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
84
Ranking in other categories
Data Science Platforms (1st), Streaming Analytics (1st)
Pyramid Analytics
Average Rating
7.6
Reviews Sentiment
2.7
Number of Reviews
8
Ranking in other categories
BI (Business Intelligence) Tools (18th), Data Visualization (13th)
 

Mindshare comparison

Data Science Platforms
BI (Business Intelligence) Tools
 

Featured Reviews

Md Masudul Hassan - PeerSpot reviewer
Comprehensive data analysis capabilities with a user-friendly interface, providing an efficient and reliable platform for researchers and analysts
I believe that offering short-term SPSS licenses, perhaps when customer sourcing is available, could make it more affordable. These licenses shouldn't include features tailored for universities or large sales organizations. Instead, they could offer discounts or additional facilities for smaller entities to access the software. In developing countries, it would be beneficial to provide certain features to users at no cost initially, while also customizing pricing options. For example, offering basic features to the first hundred users can help them become familiar with the software and its capabilities. This approach encourages users to upgrade to higher tiers as they become more experienced and require additional functionality.
Dunstan Matekenya - PeerSpot reviewer
Process large-scale data sets and integrates with Apache Spark with notebook environment
Databricks integrates natively with Apache Spark, which I use as a processing engine for large-scale datasets. This native integration is one of its strengths. Another strength is that the platform makes it very easy to manage resources. For example, setting up a cluster of five or fifteen nodes is straightforward with Databricks. The notebook environment is also excellent, making it easy to perform various tasks.
Shyam Pendyala - PeerSpot reviewer
A comprehensive and user-friendly business intelligence for enhanced data insight
When developing multidimensional IMDS models in Pyramid Analytics, there is a need for better features to maintain and analyze data. The application currently lacks the ability to easily track the original physical table and field names, making it challenging to relate them to business names. It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields. Such features would simplify documentation, facilitate understanding of how calculations depend on physical fields and aid in explaining the development process to others. Having this lineage and easy-to-generate data dictionary would greatly enhance the usability of Pyramid Analytics for developers.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It is a modeling tool with helpful automation."
"The learning curve to using this product is not steep. The program is appropriate for those who do not have a lot of background in programming, yet have to perform basic statistical analysis."
"It is perfectly adequate if all you need are the results and not the trail of evidence."
"Capability analysis is one of the main and valuable functions. We also do some hypothesis testing in Minitab and summary stats. These are the functions that we find very useful."
"The most valuable features mainly include factor analysis, correlation analysis, and geographic analysis."
"The most valuable features are the solution is easy to use, training new users is not difficult, and our usage is comprehensive because the whole service is beneficial."
"The most valuable feature is the user interface because you don't need to write code."
"It has helped our analyst unit deliver work with more transparency and confidence, given that we can always view the dataset in totality, after each step of data transformation."
"The most valuable feature is the Spark cluster which is very fast for heavy loads, big data processing and Pi Spark."
"The initial setup is pretty easy."
"This solution offers a lake house data concept that we have found exciting. We are able to have a large amount of data in a data lake and can manage all relational activities."
"Databricks makes it really easy to use a number of technologies to do data analysis. In terms of languages, we can use Scala, Python, and SQL. Databricks enables you to run very large queries, at a massive scale, within really good timeframes."
"The processing capacity is tremendous in the database."
"The ability to stream data and the windowing feature are valuable."
"I like how easy it is to share your notebook with others. You can give people permission to read or edit. I think that's a great feature. You can also pull in code from GitHub pretty easily. I didn't use it that often, but I think that's a cool feature."
"The most valuable feature of Databricks is the integration with Microsoft Azure."
"The on-premise version has quite good scalability."
"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."
"The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job."
"It offers a wide range of analytics options including statistics and visualizations, as well as prediction capabilities, allowing users to make forecasts based on the latest data."
"I think the most valuable Pyramid Analytics feature is the solution's ability to drill down and dice in the loop. I think it is better than InExcel or Power BI."
"It proved to be a very powerful and useful tool due to its breakdown capabilities, easy reporting features, flexibility in building custom calculations, and the ability to integrate them into reports."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"Pyramid has a wide level of uses, as it's a complete ETL process and has a good level of connecting to a lot of data sources."
 

Cons

"The reports could be better."
"I know that SPSS is a statistical tool but it should also include a little bit of analytical behavior. You can call it augmented analysis or predictive analysis. The bottom line is it should have more graphical and analytical capabilities."
"The product should provide more ways to import data and export results that are user-friendly for high-level executives."
"The solution needs more planning tools and capabilities."
"In some cases, the product takes time to load a large dataset. They could improve this particular area."
"SPSS slows down the computer or the laptop if the data is huge; then you need a faster computer."
"I would like SPSS to improve its integration with other data-filing IBM tools. I also think its duration with data, utilization, and graphics could be better."
"I feel that when it comes to conducting multiple analyses, there could be more detailed information provided. Currently, the software gives a summary and an overview, but it would be beneficial to have specific details for each product or variable."
"I would love an integration in my desktop IDE. For now, I have to code on their webpage."
"Overall it's a good product, however, it doesn't do well against any individual best-of-breed products."
"When I used the support, I had communication problems because of the language barrier with the agent. The accent was difficult to understand."
"The interface of Databricks could be easier to use when compared to other solutions. It is not easy for non-data scientists. The user interface is important before we had to write code manually and as solutions move to "No code AI" it is critical that the interface is very good."
"I would like it if Databricks made it easier to set up a project."
"Databricks may not be as easy to use as other tools, but if you simplify a tool too much, it won't have the flexibility to go in-depth. Databricks is completely in the programmer's hands. I prefer flexibility rather than simplicity."
"I have had some issues with some of the Spark clusters running on Databricks, where the Spark runtime and clusters go up and down, which is an area for improvement."
"I'm not the guy that I'm working with Databricks on a daily basis. I'm on the management team. However, my team tells me there are limitations with streaming events. The connectors work with a small set of platforms. For example, we can work with Kafka, but if we want to move to an event-driven solution from AWS, we cannot do it. We cannot connect to all the streaming analytics platforms, so we are limited in choosing the best one."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"The general amount of negative comments that I am hearing from my team makes me very wary."
"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."
"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"There is room for improvement in terms of the user interface, particularly when it comes to modifying connections between filters and visual components in a dashboard."
"I find that this is quite a heavy, time-consuming tool for developers."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
 

Pricing and Cost Advice

"While the pricing of the product may be higher, the accompanying service and features justify the investment."
"We think that IBM SPSS is expensive for this function."
"If it requires lot of data processing, maybe switching to IBM SPSS Clementine would be better for the buyer."
"More affordable training for new staff members."
"The pricing of the modeler is high and can reduce the utility of the product for those who can not afford to adopt it."
"SPSS is an expensive piece of software because it's incredibly complex and has been refined over decades, but I would say it's fairly priced."
"Our licence is on a yearly renewal basis. While pricing is not the primary concern in our evaluation, as products are assessed by whether they can meet our user needs and expertise, the cost can be a limiting factor in the number of licences we procure."
"It's quite expensive, but they do a special deal for universities."
"I would rate Databricks' pricing seven out of ten."
"The product pricing is moderate."
"We pay as we go, so there isn't a fixed price. It's charged by the unit. I don't have any details detail about how they measure this, but it should be a mix between processing and quantity of data handled. We run a simulation based on our use cases, which gives us an estimate. We've been monitoring this, and the costs have met our expectations."
"The price of Databricks is reasonable compared to other solutions."
"I am based in South Africa, where it is expensive adapting to the cloud, and then there is the price for the tool itself."
"We only pay for the Azure compute behind the solution."
"We're charged on what the data throughput is and also what the compute time is."
"I rate the price of Databricks as eight out of ten."
"The licensing cost is not excessively expensive, but it does increase with the addition of new features and modules."
report
Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.
823,875 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
9%
University
8%
Manufacturing Company
8%
Financial Services Firm
16%
Computer Software Company
11%
Manufacturing Company
9%
Healthcare Company
6%
Financial Services Firm
15%
Computer Software Company
12%
Government
12%
Insurance Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM SPSS Statistics?
The software offers consistency across multiple research projects helping us with predictive analytics capabilities.
What is your experience regarding pricing and costs for IBM SPSS Statistics?
The cost of IBM SPSS Statistics is managed by organizations, not individual researchers. It is a very expensive produ...
What needs improvement with IBM SPSS Statistics?
IBM SPSS Statistics does not keep you close to your data like KNIME. In KNIME, at every stage, you can see the result...
Which do you prefer - Databricks or Azure Machine Learning Studio?
Databricks gives you the option of working with several different languages, such as SQL, R, Scala, Apache Spark, or ...
How would you compare Databricks vs Amazon SageMaker?
We researched AWS SageMaker, but in the end, we chose Databricks. Databricks is a Unified Analytics Platform designe...
Which would you choose - Databricks or Azure Stream Analytics?
Databricks is an easy-to-set-up and versatile tool for data management, analysis, and business analytics. For analyti...
What do you like most about Pyramid Analytics?
The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust suppo...
What is your experience regarding pricing and costs for Pyramid Analytics?
I find the price of Pyramid Analytics to be quite reasonable, especially when compared to other tools in the industry...
What needs improvement with Pyramid Analytics?
Pyramid Analytics could improve by speeding up data refresh, especially for large datasets. While it is currently an ...
 

Also Known As

SPSS Statistics
Databricks Unified Analytics, Databricks Unified Analytics Platform, Redash
No data available
 

Learn More

Video not available
Video not available
 

Overview

 

Sample Customers

LDB Group, RightShip, Tennessee Highway Patrol, Capgemini Consulting, TEAC Corporation, Ironside, nViso SA, Razorsight, Si.mobil, University Hospitals of Leicester, CROOZ Inc., GFS Fundraising Solutions, Nedbank Ltd., IDS-TILDA
Elsevier, MyFitnessPal, Sharethrough, Automatic Labs, Celtra, Radius Intelligence, Yesware
US Department of Veterans Affair, Volkswagen, Siemens, Blackboard, Hallmark, Orange, CDW, LA Fitness, Atelier GS, Memorial Healthcare, Acadia Insurance, BancoBic, Advanced Learning, Microsoft, Drake University
Find out what your peers are saying about Databricks, Knime, Amazon Web Services (AWS) and others in Data Science Platforms. Updated: December 2024.
823,875 professionals have used our research since 2012.