Microsoft Power BI vs Oracle OBIEE vs Pyramid Analytics comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
33,848 views|28,652 comparisons
92% willing to recommend
Oracle Logo
11,656 views|5,901 comparisons
87% willing to recommend
Pyramid Analytics Logo
1,308 views|915 comparisons
87% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Power BI, Oracle OBIEE, and Pyramid Analytics based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools.
To learn more, read our detailed BI (Business Intelligence) Tools Report (Updated: April 2024).
769,334 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The dashboards of Microsoft BI are easy to use.""The most interesting feature of Microsoft Power BI is that it's very user-friendly.""There was a lot of manual work involved with Excel, whereas once we moved on to Microsoft Power BI, it was a cleaner dashboard and it was faster too.""This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it.""It allows individuals to do the analysis themselves​.""Key features are its dashboard functionality and ease of integration with various data sources.""Microsoft BI's initial setup is very straightforward.""I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated."

More Microsoft Power BI Pros →

"Dashboards provide us with various views and perspectives on our data, allowing us to analyze metrics such as revenue, occupancy rates, etc.""I like the cloud deployment feature. There are about 20 new features, and they are available on mobile and more. I haven't used any of them, but these features are highly attractive.""The technical support services are good.""The visualization is very good.""Its robustness is most valuable. It can handle massive amounts of data quickly. If it's properly configured and tuned, it can handle massive amounts of data very quickly to produce results. That to me is the number one feature.""It doesn't have many frills and is definitely older technology, but it is undeniably a workhorse.""The most valuable feature is the user-friendly set of tools that the customer can use to develop their own business dashboards.""The performance can issue queries to work in the Oracle database in Oracle's native language. There are a lot of visualizations which suit our business."

More Oracle OBIEE Pros →

"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.""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.""The on-premise version has quite good scalability.""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.""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."

More Pyramid Analytics Pros →

Cons
"Right now, their premium pricing is keeping us out of the premium market. The premium price per user just doesn't make sense for us, but we haven't reached the limit of 500 users to justify the premium.""My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset.""It is easy enough. I don't see any real substantial improvements that are needed. It is great as it is, but its interface could be a bit modern.""Microsoft needs to do some more research and development to make it more stable.""Their technical support can be better. They normally take too long to escalate and resolve a case.""Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users.""There needs to be improved guidance and documentation for the initial setup of Power BI as it currently remains complex.""The solution could be more customizable and you do not have too much freedom on the code."

More Microsoft Power BI Cons →

"An area for improvement is that Oracle pushes more users to Oracle BI Publisher rather than emphasizing Oracle OBIEE for reporting. The pricing for Oracle OBIEE could be improved.""The main problem we face is migrating all of the reports into the solution.""Its overall organization as an analytical tool, the layout of OBIEE, is not very good.""The pricing model could be improved. Right now, it's quite confusing. Many customers have this feeling that it's a super-expensive option.""Expanding beyond pure data reporting and into analytics, or expanding data science, would be areas for improvement.""There's a lot of redundancy, especially in relation to creating the code.""There are a lot of aspects of Oracle OBIEE that are exceptionally complicated, make things unnecessarily difficult for everyone who uses it. In terms of the integrations, Oracle needs to improve a little more, but I believe that they have tried to capture all those issues. The issues we are facing in the Oracle OBIEE 12C versions, in the Oracle Analytical Server Center or Analytical Cloud versions, Oracle has managed to overcome the challenges.""One feature I would definitely like to see is the ability to provide the in-memory data. Oracle might have some plugins but, as of now, that feature isn't available out-of-the-box. You might have to purchase that feature."

More Oracle OBIEE Cons →

"I find that this is quite a heavy, time-consuming tool for developers.""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.""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.""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.""The general amount of negative comments that I am hearing from my team makes me very wary."

More Pyramid Analytics Cons →

Pricing and Cost Advice
  • "There is room for at least 45% discount as compared to the initial price."
  • "MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution."
  • "All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights."
  • "I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill."
  • "Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? ​"
  • "Make it low in cost. It is a no-brainer!"
  • "Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost."
  • "Paid for itself in the first month."
  • More Microsoft Power BI Pricing and Cost Advice →

  • "It is high."
  • "It's expensive."
  • "I think to spread this across an enterprise will be a significant investment."
  • "Be prepared to spend a lot of time and money."
  • "The pricing we negotiated with Oracle. But, I do not have details."
  • "Oracle products are extremely expensive."
  • "This was not an expensive product for us, although the price varies depending on conditions for each company."
  • "The cost of this solution is a little bit high compared with other products like Zoho, so reducing it would make OBIEE more competitive."
  • More Oracle OBIEE Pricing and Cost Advice →

  • "The licensing cost is not excessively expensive, but it does increase with the addition of new features and modules."
  • More Pyramid Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    769,334 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would… more »
    Top Answer:Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are… more »
    Top Answer:Oracle OBIEE is designed to be relatively easy to set up and has a helpful customer support staff at the ready to assist… more »
    Top Answer:The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI… more »
    Top Answer:Licensing costs for Oracle OBIEE can be higher, and maintenance charges may also be significant.
    Top Answer:The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support… more »
    Top Answer:I find the price of Pyramid Analytics to be quite reasonable, especially when compared to other tools in the industry… more »
    Top Answer:Pyramid Analytics could improve by speeding up data refresh, especially for large datasets. While it is currently an… more »
    Ranking
    Views
    33,848
    Comparisons
    28,652
    Reviews
    27
    Average Words per Review
    619
    Rating
    7.9
    Views
    11,656
    Comparisons
    5,901
    Reviews
    25
    Average Words per Review
    481
    Rating
    8.0
    Views
    1,308
    Comparisons
    915
    Reviews
    6
    Average Words per Review
    554
    Rating
    7.8
    Comparisons
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
    Learn More
    Overview

    Microsoft Power BI is a powerful tool for data analysis and visualization. This tool stands out for its ability to merge and analyze data from various sources. Widely adopted across different industries and departments, Power BI is instrumental in creating visually appealing dashboards and generating insightful business intelligence reports. Its intuitive interface, robust visualization capabilities, and seamless integration with other Microsoft applications empower users to easily create interactive reports and gain valuable insights.

    Oracle OBIEE (Oracle Business Information Enterprise Edition) is a business intelligence (BI) tool developed by Oracle. OBIEE will gather, store and analyze an organization's network data and compile the information to create reports, dashboard graphs, and performance analysis. OBIEE’s unique platform allows clients to discover new awareness and improve the speed of completing important business decisions by providing robust visual tools and intuitive realization coupled with the latest unmatched enterprise analytics available. OBIEE helps IT enterprise organizations to experience an intelligent view of all enterprise data from across all sources and empowers trusted users with increased levels of reliable, dependable access, interaction, and the ability to utilize the data to increase the overall effectiveness and productivity of the organization.

    OBIEE provides unique immediate mobile access, intuitive dashboards, robust reporting, real-time alerts, metadata search, procedure management, direct access to Big Data resources, enlightened in-memory computing, and seamless systems management processes. These features seamlessly combine to make Oracle OBIEE a complete, top-of-the-line broad solution that is cost-effective, minimizes TCO, and provides a competitive, quick ROI for the entire organization.

    Oracle OBIEE Top Features 

    • Complete comprehension: Oracle OBIEE offers a full range of BI strategies, including intuitive smart dashboards, dynamic alerts and detection, efficient workflows, enterprise reporting, MS Office integration, real-time predictive analysis, and more. OBIEE also includes many next-generation options, including mission critical scalability and performance, diverse data access and integration, and a modern, robust, service-oriented architecture.
    • Hot-pluggable: OBIEE will take advantage of existing IT relationships, both Oracle and non-Oracle databases, solutions, and applications. Organizations that partner with OBIEE have access to an entire library of analytic tools that are immediately deployable and provide an improved TCO and a super-fast ROI. Additionally, in an outstanding collaboration with Hyperion, OBIEE incorporates BI tools that integrate well with the current suite to supply the grandest selection of BI tools available on the market today.
    • Extensive: OBIEE is very user-friendly and extremely intuitive, and the 100% Web UI brings robust and dynamic BI from diverse sources to any audience, distributing awareness when and where users require it to manage activities, decisions, and processes. 

    Reviews from Real Users

    Sandeep V., Process System Engineer at a comms service provider, tells us, “This solution is very easy for people who are building ad-hoc things. It's an enterprise solution so it can be deployed for a lot of users. There are some great new features that come with the 12c like data visualization, desktop BI Publisher, automation, and interactive dashboards. The product has good features. “ 

    A user who is a CEO at a consultancy relates, “The most valuable feature is the visualization. The data warehousing, data storage, and data wrangling are all features that are in there, and it's one of the better products out there. A good thing is that for large datasets, it's very stable, especially when you have an Oracle database.”

    A user who is a Principal Business Intelligence Architect at a computer software company suggests, "It is very biased towards Oracle infrastructure. One of the major red flags we have at the moment against Oracle is that it doesn't support deployment on other cloud providers. We're quite heavily vested in AWS as our infrastructure, and Oracle is yet to formally support deploying on those virtual infrastructure instances. That's quite disappointing, and it also cuts them out of over 70% of the market."



    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
    Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
    Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
    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
    Top Industries
    REVIEWERS
    Financial Services Firm15%
    Manufacturing Company13%
    Computer Software Company11%
    Energy/Utilities Company9%
    VISITORS READING REVIEWS
    Educational Organization35%
    Financial Services Firm8%
    Computer Software Company8%
    Government5%
    REVIEWERS
    Computer Software Company12%
    Financial Services Firm12%
    Manufacturing Company10%
    Government7%
    VISITORS READING REVIEWS
    Financial Services Firm18%
    Government12%
    Computer Software Company11%
    Manufacturing Company7%
    VISITORS READING REVIEWS
    Financial Services Firm12%
    Government12%
    Manufacturing Company10%
    Computer Software Company10%
    Company Size
    REVIEWERS
    Small Business39%
    Midsize Enterprise16%
    Large Enterprise45%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise41%
    Large Enterprise45%
    REVIEWERS
    Small Business22%
    Midsize Enterprise20%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    REVIEWERS
    Small Business75%
    Midsize Enterprise13%
    Large Enterprise13%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise12%
    Large Enterprise67%
    Buyer's Guide
    BI (Business Intelligence) Tools
    April 2024
    Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools. Updated: April 2024.
    769,334 professionals have used our research since 2012.