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

Databricks vs Pyramid Analytics comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

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

Categories and Ranking

Databricks
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
89
Ranking in other categories
Cloud Data Warehouse (7th), Data Science Platforms (1st), Streaming Analytics (1st)
Pyramid Analytics
Average Rating
7.6
Reviews Sentiment
6.4
Number of Reviews
8
Ranking in other categories
BI (Business Intelligence) Tools (16th), Data Visualization (12th)
 

Mindshare comparison

While both are Business Intelligence solutions, they serve different purposes. Databricks is designed for Cloud Data Warehouse and holds a mindshare of 8.8%, up 3.7% compared to last year.
Pyramid Analytics, on the other hand, focuses on BI (Business Intelligence) Tools, holds 0.8% mindshare, up 0.7% since last year.
Cloud Data Warehouse
BI (Business Intelligence) Tools
 

Featured Reviews

ShubhamSharma7 - PeerSpot reviewer
Capability to integrate diverse coding languages in a single notebook greatly enhances workflow
Databricks offers various courses that I can use, whether it's PySpark, Scala, or R. I can leverage all these courses in a single notebook, which is beneficial for clients as they can access various tools in one place whenever needed. This is quite significant. I usually work with PySpark based on client requirements. After coding, I feed the Databricks notebooks into the ADF pipeline for updates. Databricks' capability to process data in parallel enhances data processing speed. Furthermore, I can connect our Databricks notebook directly with Power BI and other visualization tools like Qlik. Once we develop code, it allows us to transform raw data into visualizations for clients using analysis diagrams, which is very helpful.
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

"The solution is an impressive tool for data migration and integration."
"We like that this solution can handle a wide variety and velocity of data engineering, either in batch mode or real-time."
"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."
"The most valuable aspect of the solution is its notebook. It's quite convenient to use, both terms of the research and the development and also the final deployment, I can just declare the spark jobs by the load tables. It's quite convenient."
"The ability to stream data and the windowing feature are valuable."
"The solution is very easy to use."
"It helps integrate data science and machine learning capabilities."
"I like that Databricks is a unified platform that lets you do streaming and batch processing in the same place. You can do analytics, too. They have added something called Databricks SQL Analytics, allowing users to connect to the data lake to perform analytics. Databricks also will enable you to share your data securely. It integrates with your reporting system as well."
"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."
"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."
"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."
"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."
"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 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."
 

Cons

"Databricks has added some alerts and query functionality into their SQL persona, but the whole SQL persona, which is like a role, needs a lot of development. The alerts are not very flexible, and the query interface itself is not as polished as the notebook interface that is used through the data science and machine learning persona. It is clunky at present."
"I would like more integration with SQL for using data in different workspaces."
"There are no direct connectors — they are very limited."
"There is room for improvement in visualization."
"There would also be benefits if more options were available for workers, or the clusters of the two points."
"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."
"Can be improved by including drag-and-drop features."
"The API deployment and model deployment are not easy on the Databricks side."
"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."
"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."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"The general amount of negative comments that I am hearing from my team makes me very wary."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"I find that this is quite a heavy, time-consuming tool for developers."
 

Pricing and Cost Advice

"Databricks' cost could be improved."
"We're charged on what the data throughput is and also what the compute time is."
"The solution is based on a licensing model."
"I'm not involved in the financing, but I can say that the solution seemed reasonably priced compared to the competitors. Similar products are usually in the same price range. With five being affordable and one being expensive, I would rate Databricks a four out of five."
"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."
"Licensing on site I would counsel against, as on-site hardware issues tend to really delay and slow down delivery."
"The licensing costs of Databricks is a tiered licensing regime, so it is flexible."
"There are different versions."
"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 Cloud Data Warehouse solutions are best for your needs.
849,686 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
10%
Manufacturing Company
9%
Healthcare Company
6%
Financial Services Firm
15%
Computer Software Company
14%
Government
11%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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 Python. It offers many different cluster choices and excellent integration with ...
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 designed to accelerate innovation projects. It is based on Spark so it is very fast. It...
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 analytics teams that have to interpret data to further the business goals of their orga...
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 support for DAX queries.
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. It is a cost-effective choice, particularly for mid-sized or larger companies ...
What needs improvement with Pyramid Analytics?
Pyramid Analytics could improve by speeding up data refresh, especially for large datasets. While it is currently an in-memory tool, efforts are underway to enhance direct connections to source sys...
 

Also Known As

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

Overview

 

Sample Customers

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 Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse. Updated: April 2025.
849,686 professionals have used our research since 2012.