Top 8 Business Intelligence (BI) Tools

Microsoft BITableauSAP Analytics CloudOracle OBIEESAP BusinessObjects Business Intelligence PlatformMicroStrategyDomoIBM Cognos
  1. leader badge
    In contrast to what we were using before I think that Power BI has given us more extensive results.Microsoft BI is scalable.
  2. leader badge
    Easy to create graphs and visualizations. The stability seems to be very reliable.
  3. Find out what your peers are saying about Microsoft, Tableau, SAP and others in Business Intelligence (BI) Tools. Updated: June 2021.
    511,307 professionals have used our research since 2012.
  4. The ability to collaborate and plan together is great. Its user-friendliness is valuable. It is a product for end-users and not for IT, which is an advantage.
  5. The solution has great reporting and forecasting capabilities.In terms of features, everything is good. It is also stable and scalable.
  6. The reporting features the solution offers are excellent.The platform uses a lot of Java technologies so the performance and system-level management are tricky because it needs a lot of resources.
  7. The solution is ideal for enterprise-level companies or corporations. It is easy to use and visually very appealing. One thing that sets it apart is that it has got a great ETL tool. As compared to some of the other solutions, it is much easier to process data from other applications in MicroStrategy. That's why we prefer using it.
  8. report
    Use our free recommendation engine to learn which Business Intelligence (BI) Tools solutions are best for your needs.
    511,307 professionals have used our research since 2012.
  9. One feature which I have found to be very interesting is the Beast manager, where you can create calculated fields. They are shared in one common repository so someone else can use the same calculated fields; they don't have to rewrite or reinvent the APIs.
  10. This solution allows you to input a wide range of file formats.The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report.

Advice From The Community

Read answers to top Business Intelligence (BI) Tools questions. 511,307 professionals have gotten help from our community of experts.
M_V
Currently, I am using SAP BO Enterprise and running on Oracle. I'm looking for a much less expensive solution. It's not enough to use MS SQL instead of Oracle.  I'm still profiling the SAP BOE implementation, but would like to head towards a DWH implementation that users can report off. Various users have mentioned in passing: PowerBI, Qlik, Tableau.  At this point, the only solid knowledge I have is that management want to get rid of SAP and Oracle. Any recommendations?
author avatarPaul Grill
Real User

There is no easy way to convert or replace BusinessObjects which is why most BusinessObjects customers today are in a state of co-existence (BO-Tableau being the most popular followed by BO-PowerBI). Since neither Tableau nor PowerBI are great at BI reporting, customers keep BO for the reporting and use Tableau/PowerBI for data discovery and visualization. You should look at right-sizing your BO deployment to save on costs. For the DWH, if you are looking at Cloud then Snowflake or Azure are the most popular with BO customers

author avatarGene Hammons, MBA
MSP

So, operating with a segment of our client base, mostly commercial stage startups where the staff comes from larger, national firms, we often get a directive: We want new infrastructure software and it can be anything as long as it's not Tier One (SAP/Oracle and similar). I guess the $5m upgrades were getting old at their previous companies. 


Also, with the Covid issue last year, many companies had to pivot very quickly to stay alive. Looking at a SAP 18-24 month rollout was looking company death in the eye, so again, please perform the impossible with the unlikely were the marching orders. 


Fortunately, around 2014 we'd started what we called 'component software' which relied on made for cloud backends (NetSuite/Acumatica/Intaact). Mostly because these were recent (in relative terms) developments but more because of being built to integrate with other external systems, along with an open development toolsets  - what we couldn't find to integrate, we could develop ('we'- being the developers we could find to handle the job). 


That approach has helped a lot of the early stage startups through the IPO process and launched into initial 5 year growth stages. We've also implemented NetSuite sub systems so we could launch eCommerce or other pivot options quickly and they're feeding financials to backend SAP/Oracle. 


In any case, we have some relatively large clients who've had substantial success with this approach, and if your management is serious about parachuting out of Tier One, perhaps you could set up your backend data in a more easily reportable structure (just a wild stab - not knowing the real issues). 


I'd also point you toward the FP&A side instead of BI if it's truly reporting that's needed. Anaplan/Host/Hyperion - (I think Hyperion has undergone rewrites, the verision we mostly use is the NetSuite Planning Budgeting and Analytics - which the users say, "Oh look, it's Hyperion").


Hope some of that is relevant to what you're looking for. 

author avatarRaviLagu
Real User

Hi,


You cannot build a DWH by using PowerBI, Qlik or Tableau as they are mainly data visualization platforms. Qlik does have its own tool but it creates proprietary datasets that cannot be accessed from outside Qlik. It seems you want a data mart tool instead of a DWH as you want users to be able to create reports. Please look into my review of SAS Data Integration studio for a better idea.

author avatarJhornber
Real User

I'd second looking into Snowflake, Big Query or Redshift for your DW (and would lean toward Snowflake). I'd also recommend doing some research on Looker. For us, and likely for some others, it has been a viable alternative to Business Objects (and Data Cubes). Tableau, while arguably the strongest data viz tool, doesn't lend itself well to business user, drag and drop report authoring and/or report scheduling and distribution. I believe Qlik was a little stronger here with their acquisition of nPrinting a ways back, but it's been a long time since I've worked with Qlik in any capacity.   

author avatarGabriel Marafon
User

Hello, 



It would be great to know a little more about your architecture and problems to be more helpful.


But as a general guide, something like BigQuery (Redshift/Snowflake) would work as your "DWH" and Qlik/Tableau/Looker/PowerBI/Datastudio would work as your visualization tools.

author avatarStephan Schaumburg-Lippe
Consultant

If I understand your question correctly, then you are looking for a replacement for SAP and Oracle, since both are too expensive. 


You can look at the issue of costs from different perspectives. The easiest way would be to look at the license costs, then the implementation and operating costs of your solution. I would not overestimate the construction costs, because they are one-time, it is much more expensive to keep a solution alive. 


An unsuitable architecture causes the highest costs. For me, architecture has nothing to do with a software product. So when you know what you are going to deliver to your users (your product), then you can design your architecture, and only then do you look for the right software. When you try to solve problems with software, in the end, it is like having just a hammer: every problem becomes a nail. 


In summary, I mean, first, describe your problem, then think about your architecture, and at the very end, the question of the tools for implementation arises.

author avatarH.Emre Arıkan
Real User

Managements want to get rid of a lot of things but at the end of the day some other guys are responsible for the seamless replacement and migration of those things :)..


BO lets you set your reporting layer(Universe in BO World) on ANY data model with any complexity, literally on ANY! You don't have this option in Tableau. So how complex is your environment?


DWH: you want to replace Oracle with SQL Server. SQL Server may not perform so well compared to Oracle. Ok Oracle ist costly, but once it has the data in memory, it is lightning fast for any selects.


So if you stick to BO-Oracle the only thing left is the need of replicating the data to DWH/Oracle. And there are some replication solutions in the markt..


As last since you hardware is fast, you can virtualize(DB Views) your modelling/cleansing needs.


So it means you can survive without ETL's in your old solution! against additional costs for BO/Oracle. (virtualize(DB Views) your modelling/cleansing needs if you don't need to historize the data)


 I would look at two things in your place: How complex is my reporting layer, what are some complex queries hitting the db's? to ease answering the question: Can Tableau/SQL Server pair can master the tasks I have?


2. I would look at the most complex use case(universe) I have : copy the relevant data to Sql Server and try to implement the reports in Tableau what you originally had at BO on Oracle. It is a costly effort but just look at the future: you migrated to Tableau/SQL Server and things are not going as you dreamed of! ;)

Menachem D Pritzker
Which BI tools are the best out of the box for basic calculations that all SaaS businesses need to track to survive? Are some tools better for startups vs enterprise?
author avatarMahalingamShanmugam
Real User

Looker, Domo, Sisense, Tableau, and Power BI are tools are good for enterprise. If you are looking for SMB (Small Medium Business), where you have 5-10 users who use BI for portfolio, then you should look at small Startup (ConverSight.ai, ToughtSpot etc.) for a per-user license, which is comparatively low in the market.

author avatarDavid Hudgins
Real User

This is a common question for many businesses that have gone down the SaaS route. SaaS Applications provide a critical application in the cloud based on a subscription model, which is great for companies looking to add software or shift capital expenses to operational expenses. However, the problem is that most of these applications are getting your data out of the SaaS and into a reporting data warehouse or another third party application.

The most common means of accessing your data is normally via an ODBC/OLE connection that is purchased at an additional monthly cost from the SaaS. This is normally a read-only connection but does provide a limited degree of access to your data. Don’t expect the SaaS Company to provide you with ER diagrams or table structures, nor should you assume the data model or schemas will follow any of the best practices or common design methods. They won’t. You must remember that SaaS-based applications try to fit everyone’s needs into a standardized set of tables. So expect odd columns and table joins throughout the application.

Once you figure out where your data is, you need to decide if you're just going to query the data from the SaaS database when the reports are run or if you're going to extract your data into a data warehouse nightly and then run your reports. This also means you now have to have a database server either on-premise or in the cloud.

I prefer the latter of the two options however it does introduce a gap in the data since the extracted data won’t be real-time. The benefit is that you can query the data as often as you want without impacting the live application. The most common tools normally used for this are MS SSIS and SAP Data Services. Both applications perform similar functions however there are many other ETL tools on the market.

Once you have the data extracted, your reporting software can run it reports. Gartner provides in-depth studies on the various applications however it really comes down to the following tools:
Microsoft Power BI
SAP Business Intelligence
Qlikview/Qliksense

These are the top reporting applications. Each has their pros and cons when compared however each can do basically the same thing as the others.

Here’s what makes them stand out from each other:

Microsoft Power Bi - Easy for end-users to create Adhoc reports from almost any dataset out there.
SAP Business Intelligence- Global standard for reporting, established tools and community
Qlikview/Qliksense- Top-rated dashboard and visualization tool.

author avatarAgus Kurdiyanto (Ericsson)
Real User

Power BI, Tableau, and Qlik have the capability to do calculations for KPIs, are easy to create visualizations, and also have the capability to get the source from any data sources. Qlik and Tableau have more advantage than Power BI. Qlik and Power BI provide the desktop for personal use. Tableau only provides trials. For the Enterprise version, it has a feature to share and collaborate with the team. Now, only Tableau can deploy the tools on Linux environments (Qlik and Power BI only for windows).

author avatarJayesh Bohara (Capgemini)
Consultant

Oracle EPM is more robust and provides comprehensive coverage for calculating KPIs. The products follow a global standardized pattern which has ease of adoption and implementation.

author avatarChunqiangGong
Real User

I think Qlik is strong at data processing and has a high performance within a large scale of data with its unique in-memory database.

author avatarAngus Lou
Real User

I have been doing data science by Python, now looking for a tools that can easily scale up the projects at low cost. KNIME seems to be a good one so I had tried it for a few months, but find difficult to copy my concepts in Python to KNIME.

Take 07_Customer_prediction_with_H2O as an example, I can code it in Python and well understand the concepts and codes, but when it comes to "nodes" in KNIME, I can't easily understand the relationship between nodes. I copied the sample process and modify a bit according to my data and understand the propose and concept, but I still don't understand why "Parameter Optimization Loop Start --> H2O Cross Validation Loop Start --> ......" in the Random Forest Metanode for instance, now I just copy to make it work but don't understand what reasons to put the nodes in that way.

Having said that I like the concept to make data science in nodes, as I am quite experience in playing around with Node-Red.

author avatarAlfredo Vidal Davalos Mora
Consultant

Domo or Pentaho and the differences between the startup version and enterprise version are the tools that you can use to pull out or get in the data and it is important to have the flexibility to get the information in different ways.

See more Business Intelligence (BI) Tools questions »

Business Intelligence (BI) Tools Articles

Data Sleek
Owner at a consultancy with 1-10 employees
May 20 2021

Over the past week, I had an opportunity to study Metabase quite extensively. I am pretty confident about my opinions. As a use case, I tried to recreate daily reports, that have already been published through Tableau .

Here are some advantages of Metabase:
1) It is fairly simple to use, and learn, compared to Tableau
2) It has unique features:
 a) you can mail reports or dashboards daily / monthly/ or after any specified time period directly to an email list.
 b) It is very easy to join tables on keys.
 c) It is EASIER to drag and drop tables/ visualizations onto dashboards compared to Tableau.
 d) It is quite easy for a beginner with no experience in building dashboards- to create visualizations. The tool provides certain suggestions such as aggregates on which visualizations can be developed. For example, it gives suggestions for calculating mean of a particular column, say, order amount by customer, and the tool does it directly for you.
 e) If the data is fed correctly through database, visualizations can be created simply by drag and drop.

Here are some disadvantages:
1) The tool is quite inflexible: I wanted to create one filter that can filter data based on orders in last x days. I cannot do that here. I have to create separate visualizations for each of: yesterday, last 90 days, last 60 days, last 30 days. Creating filters is not great with this tool.
2) The tool has a lot less tutorials and community support.
3) Highly reliant on SQL. I can see that there are a lot of duplicates in the dashboard that I have created. It is impossible for me to filter the duplicates through metabase. I am sure that I have joined the tables in a similar manner as I did in Tableau.
4) No formatting flexibility. I cannot add custom labels, I cannot change colors.
5) There is no way to share dashboards other than through an email. I have added you to the email list, and therefore, you should be receiving the daily report everyday at 8 pm PST.

Overall, if I were to create visualisations through Metabase, I will be bound by the limits of the tool. I would better prefer Microsoft Excel over Metabase since Excel also has the ability to integrate with live data for daily reports.

Ariful MondalThis is very helpful. Thank you for sharing you views on Metabase. 
Ariful Mondal@Data Sleek you are most welcome. Microsoft Power BI, Tableau, Qliksense are… more »
Find out what your peers are saying about Microsoft, Tableau, SAP and others in Business Intelligence (BI) Tools. Updated: June 2021.
511,307 professionals have used our research since 2012.