IT Central Station is now PeerSpot: Here's why

Microsoft BI vs Oracle Essbase comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
44,262 views|35,295 comparisons
Oracle Logo
3,308 views|2,618 comparisons
Featured Review
Buyer's Guide
Business Intelligence (BI) Tools
April 2022
Find out what your peers are saying about Microsoft, Tableau, SAP and others in Business Intelligence (BI) Tools. Updated: April 2022.
595,546 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"We like the drag and drop interactability visualization. We really like that. It's user-friendly.""I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice.""We have found the solution to be stable.""The scalability overall has been quite good.""The tool is very flexible so it allows creativity.""The stability is good.""It is more user-friendly compared to SSRS.""It integrates with all of the Microsoft tools."

More Microsoft BI Pros →

"Essbase is extremely stable and low-maintenance.""Unlike relational, where you're linking together multiple tables, with Essbase, you basically define what the dimensions are beforehand, and you define the hierarchy, and then load the data. This allows you to do a pretty sophisticated analysis so that you can drill into it and slice and dice the data."

More Oracle Essbase Pros →

Cons
"They are improving it all the time. What would be nice is if they could respond to feature requests more quickly. They can provide faster support for new features.""I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint.""The only challenge I have found is that they do not have a Mac version.""I would like to see a change in the premium capacity.""There are some other visuals that are available in the Microsoft marketplace, however, you need to use them via trial and error. There needs to be a write-up about how to use them with a quick guide describing the visual.""In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization.""From an improvement perspective, I think if the Power BI developers of that platform would really focus on being more detailed and specific on the error messages, it would help a lot of developers troubleshoot and maintain the report ECT or the dashboard ECT.""It should have more report outputs. They should expand the report outputs. Its documentation should also be better."

More Microsoft BI Cons →

"The ability to drive external reporting out for development could be improved.""Essbase has a programming language, and it has a couple of functions to do forecasting, however, their feature set for that is not that good."

More Oracle Essbase Cons →

Pricing and Cost Advice
  • "We have a premium Power BI license in-house that's quite an expensive license. It's $10 a month for four users and then I think 35,000 at the premium rate."
  • "It is somewhere in the middle in terms of price. Licensing is quite clear."
  • "Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version."
  • "Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable."
  • "The pricing is very reasonable compared to any other tool."
  • "Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
  • "This product offers good value for the money."
  • "Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
  • More Microsoft BI Pricing and Cost Advice →

  • "Essbase is competitively priced."
  • More Oracle Essbase Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Business Intelligence (BI) Tools solutions are best for your needs.
    595,546 professionals have used our research since 2012.
    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 recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer: 
    Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle… more »
    Top Answer: 
    The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources.
    Top Answer: 
    It's not a very scalable solution. Essbase has a programming language, and it has a couple of functions to do forecasting, however, their feature set for that is not that good. What they had for doing… more »
    Top Answer: 
    The solution is a multidimensional database that's used by a lot of different products.
    Top Answer: 
    While the product can be used both on the cloud and on-premises, I have not tried the cloud version. I would advise new users to make sure they do very thorough design sessions beforehand instead of… more »
    Ranking
    Views
    44,262
    Comparisons
    35,295
    Reviews
    183
    Average Words per Review
    534
    Rating
    8.1
    Views
    3,308
    Comparisons
    2,618
    Reviews
    2
    Average Words per Review
    540
    Rating
    8.5
    Comparisons
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Power BI, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    Essbase
    Learn More
    Overview

    Microsoft BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.

    Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server, with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end-users to better analyze their data, collaborate and better present their data.

    Oracle Essbase is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications.
    Offer
    Learn more about Microsoft BI
    Learn more about Oracle Essbase
    Sample Customers
    Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex.
    CHU de Rennes, Bellco Credit Union, Akindo Sushiro Co. Ltd, Deutsche Telekom AG, Samarco MineraÊo S.A., PCCW Ltd., QDQ media S.A.U., Boiron Italia, Specialized Bicycle Components Inc., Akindo Sushiro Co. Ltd., Air Canada, Daelim Industrial Co. Ltd.
    Top Industries
    REVIEWERS
    Financial Services Firm15%
    Manufacturing Company13%
    Computer Software Company11%
    Government10%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Comms Service Provider19%
    Financial Services Firm8%
    Government6%
    VISITORS READING REVIEWS
    Computer Software Company28%
    Financial Services Firm13%
    Comms Service Provider12%
    Retailer6%
    Company Size
    REVIEWERS
    Small Business38%
    Midsize Enterprise16%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise21%
    Large Enterprise61%
    No Data Available
    Buyer's Guide
    Business Intelligence (BI) Tools
    April 2022
    Find out what your peers are saying about Microsoft, Tableau, SAP and others in Business Intelligence (BI) Tools. Updated: April 2022.
    595,546 professionals have used our research since 2012.

    Microsoft BI is ranked 1st in Business Intelligence (BI) Tools with 188 reviews while Oracle Essbase is ranked 4th in Database Development and Management with 3 reviews. Microsoft BI is rated 8.0, while Oracle Essbase is rated 9.0. The top reviewer of Microsoft BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". On the other hand, the top reviewer of Oracle Essbase writes "Everybody uses it for financial purposes, but it can also be used for other analytic purposes, such as mathematical models, statistical models, and so on". Microsoft BI is most compared with Tableau, Amazon QuickSight, MicroStrategy, Oracle OBIEE and SAP BusinessObjects Business Intelligence Platform, whereas Oracle Essbase is most compared with SAP BusinessObjects Business Intelligence Platform, Oracle Analytics Cloud, IBM Cognos, Tableau and Oracle OBIEE.

    We monitor all Business Intelligence (BI) Tools 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.