Databricks vs Pyramid Analytics comparison

The compared Databricks and Pyramid Analytics solutions aren't in the same category. Databricks is ranked #1 in Data Science Platforms , with an average rating of 8.2, and holds a 19.1% mindshare in the category. Pyramid Analytics is ranked #18 in BIT , with an average rating of 7.8, and holds a 0.7% mindshare. Additionally, 96% of Databricks users are willing to recommend the solution, compared to 87% of Pyramid Analytics users who would recommend it.

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Databricks and Pyramid Analytics based on real PeerSpot user reviews.

Find out what your peers are saying about Databricks, Knime, Microsoft and others in Data Science Platforms.

To learn more, read our detailed Data Science Platforms Report (Updated: November 2024).

Buyer's Guide

Data Science Platforms

November 2024

Download the complete report

Helped 815,854 peers since 2012

Categories and Ranking

IBM SPSS Statistics

Mindshare comparison

Data Science Platforms

BI (Business Intelligence) Tools

Featured Reviews

AbakarAhmat

Software Engineer at a university with 10,001+ employees

Sep 21, 2023

Enhancing survey analysis that provides valued insightfulness

I use it to analyze questionnaire surveys related to a product, solution, or application, such as open data services, which I provide to consumers and end-users. These surveys contain evaluation assessments, and I use SPSS to analyze the responses The most valuable feature is its robust…

Read full review

Dunstan Matekenya

Data Scientist at a financial services firm with 10,001+ employees

Jul 10, 2024

Process large-scale data sets and integrates with Apache Spark with notebook environment

I primarily use Databricks to process large-scale data sets with Apache Spark. My main use case is processing large data sets, such as 600 GB or 800 GB Databricks integrates natively with Apache Spark, which I use as a processing engine for large-scale datasets. This native integration is one of…

Read full review

Shyam Pendyala

Manager, BI Platforms at Refinitiv, an LSEG Business at LSEG (London Stock Exchange Group)

Sep 12, 2023

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.

Read full review

Quotes from Members

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

Pros

"Most of the product features are good but I particularly like the linear regression analysis."

"Custom tables and macros: They allow us to create useful reports quickly for a broad audience."

"The most valuable feature of IBM SPSS Statistics is all the functionality it provides. Additionally, it is simple to do the five-way analysis that you can into multidimensional setup space. It's the multidimensional space facility that is most useful."

"The best part is that they have an algorithm handbook, so you can open it up and understand how it works, and if it is useful, this is very important."

"I've found the descriptive statistics and cross-tabs valuable. The very simple correlations and regressions are as well."

"One feature I found very valuable was the analysis of variance (ANOVA)."

"It is perfectly adequate if all you need are the results and not the trail of evidence."

"SPSS is quite robust and quicker in terms of providing you the output."

More IBM SPSS Statistics pros

"The simplicity of development is the most valuable feature."

"Its lightweight and fast processing are valuable."

"A very valuable feature is the data processing, and the solution is specifically good at using the Spark ecosystem."

"Databricks has improved my organization by allowing us to transform data from sources to a different format and feed that to the analytics, business intelligence, and reporting teams. This tool makes it easy to do those kinds of things."

"I like the ability to use workspaces with other colleagues because you can work together even without seeing the other team's job."

"I work in the data science field and I found Databricks to be very useful."

"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."

"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."

More Databricks pros

"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."

"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."

"It seems quite performant in analyzing multi-dimensional information sets and presenting them."

"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."

"The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job."

"The on-premise version has quite good scalability."

"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."

Cons

"The statistics should be more self-explanatory with detailed automated reports."

"The technical support should be improved."

"Improvements are needed in the user interface, particularly in terms of user-friendliness."

"The product should provide more ways to import data and export results that are user-friendly for high-level executives."

"IBM SPSS Statistics does not keep you close to your data like KNIME."

"SPSS slows down the computer or the laptop if the data is huge; then you need a faster computer."

"The solution could improve by providing a visual network for predictions and a self-organizing map for clustering."

"It could allow adding color to data models to make them easier to interpret."

More IBM SPSS Statistics cons

"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."

"It would be great if Databricks could integrate all the cloud platforms."

"Databricks is an analytics platform. It should offer more data science. It should have more features for data scientists to work with."

"Databricks can improve by making the documentation better."

"The solution could be improved by adding a feature that would make it more user-friendly for our team. The feature is simple, but it would be useful. Currently, our team is more familiar with the language R, but Databricks requires the use of Jupyter Notebooks which primarily supports Python. We have tried using RStudio, but it is not a fully integrated solution. To fully utilize Databricks, we have to use the Jupyter interface. One feature that would make it easier for our team to adopt the Jupyter interface would be the ability to select a specific variable or line of code and execute it within a cell. This feature is available in other Jupyter Notebooks outside of Databricks and in our own IDE, but it is not currently available within Databricks. If this feature were added, it would make the transition to using Databricks much smoother for our team."

"Instead of relying on a massive instance, the solution should offer micro partition levels. They're working on it, however, they need to implement it to help the solution run more effectively."

"It would be better if it were faster. It can be slow, and it can be super fast for big data. But for small data, sometimes there is a sub-second response, which can be considered slow. In the next release, I would like to have automatic creation of APIs because they don't have it at the moment, and I spend a lot of time building them."

"The biggest problem associated with the product is that it is quite pricey."

More Databricks cons

"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 think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."

"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."

"I find that this is quite a heavy, time-consuming tool for developers."

"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."

"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."

"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."

Pricing and Cost Advice

"The pricing of the modeler is high and can reduce the utility of the product for those who can not afford to adopt it."

"If it requires lot of data processing, maybe switching to IBM SPSS Clementine would be better for the buyer."

"The price of IBM SPSS Statistics could improve."

"It's quite expensive, but they do a special deal for universities."

"I rate the tool's pricing a five out of ten."

"The price of this solution is a little bit high, which was a problem for my company."

"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."

More IBM SPSS Statistics pricing and cost advice

"I do not exactly know the costs, but one of our clients pays between $100 USD and $200 USD monthly."

"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 licensing costs of Databricks is a tiered licensing regime, so it is flexible."

"Databricks' cost could be improved."

"The cost for Databricks depends on the use case. I work on it as a consultant, so I'm using the client's Databricks, so it depends on how big the client is."

"Price-wise, I would rate Databricks a three out of five."

"We implement this solution on behalf of our customers who have their own Azure subscription and they pay for Databricks themselves. The pricing is more expensive if you have large volumes of data."

"The basic version of this solution is now open-source, so there are no license costs involved. However, there is a charge for any advanced functionality and this can be quite expensive."

More Databricks pricing and cost advice

"The licensing cost is not excessively expensive, but it does increase with the addition of new features and modules."

See which vendors are best for you

Use our free recommendation engine to learn which Data Science Platforms solutions are best for your needs.

See recommendations

815,854 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

17%

Computer Software Company

University

Manufacturing Company

Financial Services Firm

16%

Computer Software Company

12%

Manufacturing Company

Healthcare Company

Financial Services Firm

14%

Computer Software Company

11%

Government

11%

Manufacturing Company

10%

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.

See all answers

What is your experience regarding pricing and costs for IBM SPSS Statistics?

While the pricing of the product may be higher, the accompanying service and features justify the investment. However...

See all answers

What needs improvement with IBM SPSS Statistics?

In some cases, the product takes time to load a large dataset. They could improve this particular area.

See all answers

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 ...

See all answers

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...

See all answers

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...

See all answers

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...

See all answers

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...

See all answers

What needs improvement with Pyramid Analytics?

Pyramid Analytics could improve by speeding up data refresh, especially for large datasets. While it is currently an ...

See all answers

Comparisons

IBM SPSS Modeler vs IBM SPSS Statistics

Compared 14% of the time

Alteryx vs IBM SPSS Statistics

Compared 14% of the time

TIBCO Statistica vs IBM SPSS Statistics

Compared 13% of the time

Microsoft Azure Machine Learning Studio vs IBM SPSS Statistics

Compared 12% of the time

Google Cloud Datalab vs IBM SPSS Statistics

Compared 6% of the time

More IBM SPSS Statistics Competitors

Dataiku vs Databricks

Compared 11% of the time

Informatica PowerCenter vs Databricks

Compared 8% of the time

Amazon SageMaker vs Databricks

Compared 8% of the time

Dremio vs Databricks

Compared 8% of the time

Microsoft Power BI vs Databricks

Compared 6% of the time

More Databricks Competitors

Microsoft Power BI vs Pyramid Analytics

Compared 44% of the time

Tableau vs Pyramid Analytics

Compared 21% of the time

Alteryx vs Pyramid Analytics

Compared 7% of the time

SAP Analytics Cloud vs Pyramid Analytics

Compared 7% of the time

Qlik Sense vs Pyramid Analytics

Compared 5% of the time

More Pyramid Analytics Competitors

Product Reports

Buyer's Guide

IBM SPSS Statistics

November 2024

Download IBM SPSS Statistics product report

Buyer's Guide

Databricks

November 2024

Download Databricks product report

Buyer's Guide

Pyramid Analytics

November 2024

Download Pyramid Analytics product report

Also Known As

SPSS Statistics

Databricks Unified Analytics, Databricks Unified Analytics Platform, Redash

No data available

Learn More

Video not available

IBM

Databricks

Video not available

Pyramid Analytics

Overview

IBM SPSS Statistics is a powerful data mining solution that is designed to aid business leaders in making important business decisions. It is designed so that it can be effectively utilized by organizations across a wide range of fields. SPSS Statistics allows users to leverage machine learning algorithms so that they can mine and analyze data in the most effective way possible.

IBM SPSS Statistics Benefits

Some of the ways that organizations can benefit by choosing to deploy IBM SPSS Statistics include:

Ease of use. SPSS Statistics enables users to simply and intuitively take control of their statistical needs. The solution is designed so that analysts who do not know how to code can easily make full use of the various tools and capabilities that SPSS Statistics has to offer. Its command language is so straightforward that it does not require users to undergo special training before they use it.

Comprehensive and flexible build. SPSS Statistics is designed to be both a comprehensive and highly flexible analytics solution. It enables users to utilize a variety of integrations that make it easy for users to add features that they might feel they are missing.

Automation. SPSS Statistics makes it simple for users to automate basic tasks that they might otherwise devote too much time worrying about. Tasks like calculation or data gathering can be delegated to the system while more conceptual tasks like data analysis are given to an organization’s analysts to handle.

IBM SPSS Statistics Features

Intuitive user interface. SPSS Statistics enables users to deploy an intuitive interface that makes the process of system management simple. Among the other components of this interface is a drag-and-drop feature that makes analysis and management possible for anyone who wants to use it.

Advanced data visualizations. Analysts that employ SPSS Statistics gain access to tools that empower them to create and export data visualizations. These visualizations can be formatted in many different ways depending on what the user needs.

Local data storage. SPSS Statistics has the ability to securely store data on a user’s computer. This enables them to add layers of security that would not necessarily be present if the data was stored in the cloud.

Reviews from Real Users

IBM SPSS Statistics is a highly effective solution that stands out when compared to many of its competitors. Two major advantages it offers are the wealth of functionalities that it provides and its high level of accessibility.

An Emeritus Professor of Health Services Research at a university writes, "The most valuable feature of IBM SPSS Statistics is all the functionality it provides. Additionally, it is simple to do the five-way analysis that you can in a multidimensional setup space. It's the multidimensional space facility that is most useful."

A Director of Systems Management & MIS Operations at a university, says, “The SPSS interface is very accessible and user-friendly. It's really easy to get information from it. I've shared it with experts and beginners, and everyone can navigate it.”

Databricks is utilized for advanced analytics, big data processing, machine learning models, ETL operations, data engineering, streaming analytics, and integrating multiple data sources.

Organizations leverage Databricks for predictive analysis, data pipelines, data science, and unifying data architectures. It is also used for consulting projects, financial reporting, and creating APIs. Industries like insurance, retail, manufacturing, and pharmaceuticals use Databricks for data management and analytics due to its user-friendly interface, built-in machine learning libraries, support for multiple programming languages, scalability, and fast processing.

What are the key features of Databricks?

User-friendly interface: Simplifies operations and usability.
Built-in machine learning libraries: Facilitates machine learning tasks.
Support for multiple programming languages: Enhances flexibility.
Scalability: Efficiently handles growing data needs.
Fast processing: Improves performance and speed.
Automated optimization: Reduces manual efforts.
Data visualization: Provides insightful visuals.
Collaborative features: Enhances teamwork.
Delta Lake performance: Boosts data management.
Seamless cluster management: Simplifies system operations.

What are the benefits or ROI to look for in Databricks reviews?

Efficiency in handling large datasets: Ensures smooth processing.
Interactive workspace environment: Improves user collaboration.
Integration with platforms: Provides connectivity benefits.
Performance optimization: Enhances overall system performance.
Support for data governance and security: Ensures data integrity and protection.

Databricks is implemented in insurance for risk analysis and claims processing; in retail for customer analytics and inventory management; in manufacturing for predictive maintenance and supply chain optimization; and in pharmaceuticals for drug discovery and patient data analysis. Users value its scalability, machine learning support, collaboration tools, and Delta Lake performance but seek improvements in visualization, pricing, and integration with BI tools.

The BI Office from Pyramid Analytics is a web-based governed data discovery and analytics platform. It integrates the four principal functions of any comprehensive BI strategy into a single, seamless application. Users can now analyze, present, report and predict on their data in a single application. Pyramid Analytics has native apps to cover the entire mobile spectrum, iOS, Android and Windows. With BI Office users can integrate SAP data with data from other sources giving them the right tools and better data to make data-driven decisions.

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

Buyer's Guide

Data Science Platforms

November 2024

Download Free Report

Find out what your peers are saying about Databricks, Knime, Microsoft and others in Data Science Platforms. Updated: November 2024.

DOWNLOAD NOW

815,854 professionals have used our research since 2012.

We monitor all Data Science Platforms reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.