That is no right answer for this. It actually depends on the needs, user capability, available infra and tools, and management's requirement. You can use Pentaho, Power BI or Superset if you are looking for free or cheap solutions. Else, you can go with Alteryx and Tableau, Enterprise Power BI, Qlik Sense, etc.
It all depends on couple of points, example: Targeted Users, Tool Usage, Budget for the tool,infrastructure etc.. Based on these factors you can decide about the tool. More or less all tools provide similar set of features. If you wanted to stay in Oracle area, you may use Oracle BI. Personally I like Power BI /Qlik Sense. Power BI is a very powerful tool for data analysis. However, along with Attunity and integration with snowflake makes Qlik sense a very good tool to be used on cloud.Also the insights from Qlik makes this tool great.
BI Architect/Cognos Solution Architect/ETL Design Architect at a media company with 201-500 employees
Real User
2019-12-05T14:33:33Z
Dec 5, 2019
Currently, there are a number of different BI tools in a market that allows you to work with different data sources. In the Oracle world, there is an Oracle BI itself that is rather sophisticated and not as intuitive. Cognos requires a pretty complicated modelling and programming in order to use all its flexibility together with a limited performance when many big dimensions used together and a security that I had to rework and automate in order to avoid a time-costly administration (not talking about other inconveniences), some other products are not cost-effective and not self-serve.
I would prefer (and now switched to) a Microsoft Power BI that has a wide range of sources to connect to (if no driver issues), cost-effective, simple to use, highly graphical, cloud-ready, allows a self-serve in most cases, nice performance, continuously improving software and providing new capabilities and objects, simple security system, though based on a cloud may have some refresh delays. I would stay now with MS Power BI.
Restricting this to the Oracle products world, the standard choice would be OBIEE or the Oracle Data Visualization tool. Otherwise, there are plenty of other tools: Tableau, Qlik, PowerBI.
Find out what your peers are saying about Microsoft, Salesforce, Amazon Web Services (AWS) and others in BI (Business Intelligence) Tools. Updated: December 2024.
BI Architect at a financial services firm with 1,001-5,000 employees
Consultant
2019-12-05T10:56:19Z
Dec 5, 2019
I would definitely recommend IBM Cognos. I have worked with many BI solutions that were based on IBM Cognos and Oracle.
If budget is an issue then PowerBI is a very good solution too. I have also worked with some open source big data solutions - for reporting and visualizations Apache Superset and for OLAP Apache Kylin.
I've been working with it for 7 years and I found it complex to use either for users and developers. It's rigid, with a lack of features and poor support.
I also worked with other BI platforms and I really feel the difference.
Definitely, you should try Microstrategy, Power BI, Tableau, QlickView.
I suggest you provide more information. For instance, do you expect significant data volumes ( > 100 million records), numbers of users, are you expecting to build some sort of data warehouse or are you more interested in reporting across existing applications, is it an enterprise-wide or departmental solution you're trying to address, do you have technical expertise available, self-service and/or report delivery, is $ an issue, etc etc. As stated earlier there are an awful lot of possible BI tools out there and thus options.
I am certainly no expert, in fact pretty new to this space, but I was recently doing web research to find alternatives for both data integration and data presentation, hence my looking at BI tools.
I pretty much concluded that the best, low-cost route to go would be to use OpsHub Integration Manager for a broad range of ready-built integrations, with the KNIME Analytics Platform for the BI toolset. Or just use KNIME as it also has built-in integration capability.
KNIME, though perhaps not as 'cute' as some of the pro tools, seems to offer a great range of functionality, so I believe well worth looking into.
Did I mention it's free for at least small scale usage?
Management Consultant at a tech services company with 51-200 employees
Consultant
2019-12-07T04:44:07Z
Dec 7, 2019
In the Oracle world, the preferred BI tool would be the Oracle Business Intelligence Enterprise Edition (OBIEE). You can read through their website about the pertinent features why it so, however, the most important factor for me would be its tight integration with the Oracle stack and support, which I believe is important for long-term production deployment, adoption, and investment protection.
Although we all have our personal preferences, I will always advise on what makes business sense.
Sales & Marketing at a tech services company with 11-50 employees
Real User
2019-12-05T16:39:29Z
Dec 5, 2019
You can make all modern BI tools work within Oracle. We have several hundred Oracle customers that use Qlik and Power BI. Your success is dependent upon your data quality and access for the BI Platforms you select. Also, if you are a JDE or EBS based shop, we have a number of off the shelf templates created for those modules in Qlik that allows us to rapidly deploy dashboards for JDE and EBS...
Data Warehouse Manager at a construction company with 10,001+ employees
Real User
2019-12-05T16:35:47Z
Dec 5, 2019
I've been using IBM Cognos and Tableau for my BI activity at a higher education institution. Tableau makes it easy to attach to Oracle tables/views, but I manage my own joins. Using Cognos, and developing a Framework package that includes all the relational joins so the end-user doesn't have to figure it out. It's expensive but eventually enables a good end-user experience
Interim Manager Supply Chain / IT at a consultancy with 501-1,000 employees
Real User
2019-12-05T11:27:38Z
Dec 5, 2019
The best one for me is Microsoft Power BI: it's cheap, simple, very functional, very smooth inside Office 365 and more, look at Ram Chitta's comment, I totally agree.
Business intelligence (BI) successfully combines business history and software to interpret data to analyze a business’s footprint and create action plans for success in the future. Business intelligence will look at the effects of various business decisions and summarize those effects in easy-to-understand reports, graphs, charts, and summaries.
There's OBIEE, have you ruled that out? Seems like it is not highly rated based on reviews: www.itcentralstation.com
Here's a review of someone using DOMO in an Oracle environment: www.itcentralstation.com
This reviewer compared Oracle BI with Tableau but chose Tableau: www.itcentralstation.com
That is no right answer for this. It actually depends on the needs, user capability, available infra and tools, and management's requirement. You can use Pentaho, Power BI or Superset if you are looking for free or cheap solutions. Else, you can go with Alteryx and Tableau, Enterprise Power BI, Qlik Sense, etc.
It all depends on couple of points, example: Targeted Users, Tool Usage, Budget for the tool,infrastructure etc.. Based on these factors you can decide about the tool. More or less all tools provide similar set of features. If you wanted to stay in Oracle area, you may use Oracle BI. Personally I like Power BI /Qlik Sense. Power BI is a very powerful tool for data analysis. However, along with Attunity and integration with snowflake makes Qlik sense a very good tool to be used on cloud.Also the insights from Qlik makes this tool great.
Currently, there are a number of different BI tools in a market that allows you to work with different data sources. In the Oracle world, there is an Oracle BI itself that is rather sophisticated and not as intuitive. Cognos requires a pretty complicated modelling and programming in order to use all its flexibility together with a limited performance when many big dimensions used together and a security that I had to rework and automate in order to avoid a time-costly administration (not talking about other inconveniences), some other products are not cost-effective and not self-serve.
I would prefer (and now switched to) a Microsoft Power BI that has a wide range of sources to connect to (if no driver issues), cost-effective, simple to use, highly graphical, cloud-ready, allows a self-serve in most cases, nice performance, continuously improving software and providing new capabilities and objects, simple security system, though based on a cloud may have some refresh delays. I would stay now with MS Power BI.
Restricting this to the Oracle products world, the standard choice would be OBIEE or the Oracle Data Visualization tool. Otherwise, there are plenty of other tools: Tableau, Qlik, PowerBI.
There are now good BI tools in the Oracle world. Go for an independent BI supplier like QLIK tech.
Depend of your use case, we are currently in an evaluation process for embedded analytics, the short list is: Looker, YellowFin, Domo, Sisense
I would definitely recommend IBM Cognos. I have worked with many BI solutions that were based on IBM Cognos and Oracle.
If budget is an issue then PowerBI is a very good solution too. I have also worked with some open source big data solutions - for reporting and visualizations Apache Superset and for OLAP Apache Kylin.
Power BI..Cost Effective, Self Service BI, Highly Graphical, Cloud Ready, Operational Report, Data connectivity.
Honestly, I don't recommend OBIEE.
I've been working with it for 7 years and I found it complex to use either for users and developers. It's rigid, with a lack of features and poor support.
I also worked with other BI platforms and I really feel the difference.
Definitely, you should try Microstrategy, Power BI, Tableau, QlickView.
I suggest you provide more information. For instance, do you expect significant data volumes ( > 100 million records), numbers of users, are you expecting to build some sort of data warehouse or are you more interested in reporting across existing applications, is it an enterprise-wide or departmental solution you're trying to address, do you have technical expertise available, self-service and/or report delivery, is $ an issue, etc etc. As stated earlier there are an awful lot of possible BI tools out there and thus options.
Power-BI is the best one.
I am certainly no expert, in fact pretty new to this space, but I was recently doing web research to find alternatives for both data integration and data presentation, hence my looking at BI tools.
I pretty much concluded that the best, low-cost route to go would be to use OpsHub Integration Manager for a broad range of ready-built integrations, with the KNIME Analytics Platform for the BI toolset. Or just use KNIME as it also has built-in integration capability.
KNIME, though perhaps not as 'cute' as some of the pro tools, seems to offer a great range of functionality, so I believe well worth looking into.
Did I mention it's free for at least small scale usage?
I would rather prefer, KNOWAGE suite because of its scalability, easy and fast implementation, etc.
In the Oracle world, the preferred BI tool would be the Oracle Business Intelligence Enterprise Edition (OBIEE). You can read through their website about the pertinent features why it so, however, the most important factor for me would be its tight integration with the Oracle stack and support, which I believe is important for long-term production deployment, adoption, and investment protection.
Although we all have our personal preferences, I will always advise on what makes business sense.
You should go for Oracle BI, Hitachi Pentaho BI suite.
Check this out: www.oracle.com
I found the the 2019 Gartner BI Magic Quadrant are quite insightful if you wish to look over and beyond:
interworks.com
Hope this helps.
Chee
You can make all modern BI tools work within Oracle. We have several hundred Oracle customers that use Qlik and Power BI. Your success is dependent upon your data quality and access for the BI Platforms you select. Also, if you are a JDE or EBS based shop, we have a number of off the shelf templates created for those modules in Qlik that allows us to rapidly deploy dashboards for JDE and EBS...
I've been using IBM Cognos and Tableau for my BI activity at a higher education institution. Tableau makes it easy to attach to Oracle tables/views, but I manage my own joins. Using Cognos, and developing a Framework package that includes all the relational joins so the end-user doesn't have to figure it out. It's expensive but eventually enables a good end-user experience
Oracle BI Publisher (Enterprise), {Documentation: Oracle Business Intelligence Publisher} Release 11g (11.1.1) and Oracle Analytics (Business Intelligence) - {Documentation: Oracle BIEE - Fusion Middleware Online Documentation 11g Release 1 (11.1.1.7)}
Please check TIBCO Spotfire, Streaming and data sciences.
There is nice tutorial at
www.udemy.com
You may want to check it out.
The best one for me is Microsoft Power BI: it's cheap, simple, very functional, very smooth inside Office 365 and more, look at Ram Chitta's comment, I totally agree.
The only BI tool I ever use is PowerBI from Microsoft. It has served me well.