2019-12-01T06:08:00Z
  • 20
  • 102

What is a good BI tool in the Oracle world?

Hi community,

I'm researching BI tools in the Oracle world. Which would you recommend and why?

Thanks! I appreciate the help.


24
PeerSpot user
24 Answers
Franco Fontana - PeerSpot reviewer
Business Intelligence at UTE
Real User
Top 5Leaderboard
2020-02-06T15:05:21Z
Feb 6, 2020

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.

Search for a product comparison in BI (Business Intelligence) Tools
Russell Rothstein - PeerSpot reviewer
CEO at PeerSpot (formerly IT Central Station)
Community Manager
2019-12-03T14:08:37Z
Dec 3, 2019

There's OBIEE, have you ruled that out? Seems like it is not highly rated based on reviews: https://www.itcentralstation.com/products/oracle-obiee-reviews

Here's a review of someone using DOMO in an Oracle environment: https://www.itcentralstation.com/product_reviews/domo-review-62133-by-kim-galan

This reviewer compared Oracle BI with Tableau but chose Tableau: https://www.itcentralstation.com/product_reviews/tableau-review-63022-by-cristobal-rodriguez

Ts Nurul Haszeli - PeerSpot reviewer
Technology Consultant (Data, BI, IT) at Freelance
Real User
Top 10
2019-12-06T08:12:42Z
Dec 6, 2019

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.

AmitKumar2 - PeerSpot reviewer
BI Analyst at eVision Industry Software
Real User
2019-12-05T15:18:22Z
Dec 5, 2019

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.

Artour Aslanian - PeerSpot reviewer
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.

Giuseppe-Naldi - PeerSpot reviewer
Principal Full Stack Data Scientist at ICTeam
Real User
2019-12-05T13:09:18Z
Dec 5, 2019

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.

Learn what your peers think about IBM Cognos. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
655,994 professionals have used our research since 2012.
CE
User with 5,001-10,000 employees
Real User
2019-12-05T11:49:56Z
Dec 5, 2019

There are now good BI tools in the Oracle world. Go for an independent BI supplier like QLIK tech.

RG
President with self employed
User
2019-12-05T11:46:37Z
Dec 5, 2019

Depend of your use case, we are currently in an evaluation process for embedded analytics, the short list is: Looker, YellowFin, Domo, Sisense

GC
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.

RC
Data Visualization Practice Head at a tech services company with 10,001+ employees
User
2019-12-05T08:50:23Z
Dec 5, 2019

Power BI..Cost Effective, Self Service BI, Highly Graphical, Cloud Ready, Operational Report, Data connectivity.

Paul Kellett - PeerSpot reviewer
BI Practioner - Consultant at KIS Ltd
Real User
Top 10
2019-12-16T02:00:44Z
Dec 16, 2019

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.

NK
Delivery Manager at a tech services company with 1,001-5,000 employees
Real User
2019-12-10T13:50:54Z
Dec 10, 2019

Power-BI is the best one.

it_user1181187 - PeerSpot reviewer
Account Manager with 201-500 employees
User
2019-12-09T06:28:12Z
Dec 9, 2019

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?

AbdulshukoorMohammed - PeerSpot reviewer
General Manager Information Technology & Enterprise Applications Manager at OXFORD HOLDING
Real User
Top 5
2019-12-07T08:55:35Z
Dec 7, 2019

I would rather prefer, KNOWAGE suite because of its scalability, easy and fast implementation, etc.

it_user1194042 - PeerSpot reviewer
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.

ManojKumar3 - PeerSpot reviewer
BI Developer at a tech vendor with 201-500 employees
Real User
2019-12-07T03:42:57Z
Dec 7, 2019

You should go for Oracle BI, Hitachi Pentaho BI suite.

Chee De Visser - PeerSpot reviewer
Financial System Analyst at City of Richmond
Real User
2019-12-05T23:13:24Z
Dec 5, 2019

Check this out: https://www.oracle.com/ca-en/middleware/technologies/bi.html.

I found the the 2019 Gartner BI Magic Quadrant are quite insightful if you wish to look over and beyond:
https://interworks.com/blog/ksloan/2019/04/03/the-2019-gartner-bi-magic-quadrant-visualized-in-tableau/

Hope this helps.

Chee

DP
Sales & Marketing at a tech services company with 11-50 employees
Real User
Top 20
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...

JM
Data Warehouse Manager at a construction company with 10,001+ employees
Real User
Top 20
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

CO
Computer Programmer/Analyst with 10,001+ employees
User
2019-12-05T14:39:08Z
Dec 5, 2019

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)}

MJ
Customer Account Professional at a tech vendor with 201-500 employees
User
2019-12-05T11:55:50Z
Dec 5, 2019

Please check TIBCO Spotfire, Streaming and data sciences.

User
2019-12-05T11:36:10Z
Dec 5, 2019

There is nice tutorial at

https://www.udemy.com/course/tableau10/?gclid=CjwKCAiA8qLvBRAbEiwAE_ZzPRjTTOa8KN8hqj9xJ9botjfK0x5CEXYkaaYhap2H57HjHHn6Mx9zdBoCEoUQAvD_BwE&matchtype=b&utm_campaign=LongTail_la.EN_cc.ROW&utm_content=deal4584&utm_medium=udemyads&utm_source=adwords&utm_term=_._ag_80675483882_._ad_386750759715_._kw_%2Bbusiness+%2Bintelligence+%2Btutorial_._de_c_._dm__._pl__._ti_kwd-322823583782_._li_1010110_._pd__._

You may want to check it out.

Norbert Langewiesche - PeerSpot reviewer
Interim Manager Supply Chain / IT 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.

CA
Accountant at a government
Real User
2019-12-05T09:38:09Z
Dec 5, 2019

The only BI tool I ever use is PowerBI from Microsoft. It has served me well.

Related Questions
GP
Research Student at Technische Hochschule Deggendorf
Nov 24, 2022
Hello peers,  I am a research student at a large educational organization. There are many business intelligence tools in the market but only a few of them are well known. Why is AWS QuickSight not as popular as other business intelligence tools? What BI tool do you use and why? Thank you.
See 2 answers
Deepak Damodarr - PeerSpot reviewer
Data Office Lead at a comms service provider with 501-1,000 employees
Nov 24, 2022
First of all, AWS QuickSight is a versatile BI tool and is cloud-native. Some of the reasons which discourage BI teams from using AWS QuickSight are I) AWS QuickSight access requires AWS account setup ii) AWS QuickSight usage requires some knowledge of setting up AWS resources and IAM policies iii) AWS QuickSight lic is split between read-only and author roles, so additional admin work iv) Using AWS QuickSight for building or accessing dashboards, both incur cost v) Being a cloud-native app steady internet connection is required for a smooth experience vi) AWS QuickSight doesn't have a desktop client vii) AWS QuickSight is fairly new the industry and still improving on features.
Xavier Suriol - PeerSpot reviewer
Freelancer at Freelancer
Nov 24, 2022
Hello Pandu,  I may be wrong but to the best of my knowledge AWS QuickSight doesn't accept scripts in R or Python. Other BI tools do. I am a user of both languages and somehow my machine learning (ML) projects can be easily implemented in a company with such user-friendly BI tools. I take them to be an entry point for managerial ML solutions (not so much for industrial solutions).   That's why I disregard BI tools that don't handle R and Python. 
reviewer1772406 - PeerSpot reviewer
User at Unionbank Philippines
Feb 2, 2022
Hi experts, I work at a large financial organization. I have been wondering what types of problems (=use cases) can be solved/optimized using the Edge AI technology in industries such as Banking and  Finance, Power and Land and Agriculture?  I appreciate your thoughts and suggestions.
See 1 answer
Djalma Gomes, Pmp, Mba - PeerSpot reviewer
Managing Partner at Data Pine
Feb 2, 2022
AI has already been used for decades in banking, finance and agriculture.  Credit and loan analysis use a lot of logistic regression to know who to loan money to. Finance uses AI for regression analysis of forecasts and optimum stock portfolios, agriculture to predict production and supplies needs based on the amount of rain forecasted. What we have is the evolution of tools, methods and techniques. We no longer need cubes. Although Hadoop is meant for safe storage at low cost and not for AI purposes, tools have evolved and new tools arose providing the speed required for AI analysis. We have evolved in terms of data governance with the use of DMBoK (Data Management Body of Knowledge), visual planning frameworks like the Machine Learning Canvas, Self Service BI approaches stimulating collaboration amongst users.  We now have tools, practices, frameworks and enough manpower that makes the job more challenging. We have been using AI in those sectors for quite a while, but now we have the momentum to reach a different level of data thinking organizations.
Related Articles
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
May 2, 2022
Hi peers, We're happy to share our new bi-weekly Community Spotlight with you. Here you'll find recent contributions by PeerSpot community members: questions, articles and trending discussions. Trending See what your peers are discussing at the moment! What to choose: an endpoint antivirus, an EDR solution, or both? What is your recommended IT Service Management (ITSM) tool in 2022? W...
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Apr 4, 2022
Hi peers, This is our new Community Spotlight that includes recent contributions (questions, articles and discussions) by the PeerSpot community members. Trending Is RPA beneficial for a healthcare organization? With the increasing risk of cyber attacks in the west, due to the war in Ukraine, how safe is your data in the cloud? Articles 8 Business Automation Ideas to Save Time and...
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Mar 18, 2022
Hi community members, Here we go with a new Community Spotlight. We publish it to help YOU catch up on recent contributions by community members. Trending What open-source HCI solution do you recommend? How much time does SSO save? What are the main technical differences between Microsoft Power Automate and Blue Prism? Articles Top HCI in 2022 What is Web Design? The Ultima...
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Mar 4, 2022
Hi community members, Here is our new Community Spotlight for YOU. We publish it to help you catch up on recent contributions by community members. Do you find it useful? Please comment below! Trending Top HCI in 2022 What are the main differences between XDR and SIEM? Articles Top 5 Ethernet Switches in 2022 SASE: what is it and what are the main benefits? Questions Che...
Shibu Babuchandran - PeerSpot reviewer
Regional Manager/ Service Delivery Manager at ASPL INFO Services
Oct 16, 2021
What Is Intelligent Process Automation? Intelligent process automation (IPA) refers to tasks that are automated or optimized in part by artificial intelligence and machine learning algorithms. IPA tools can reduce human intervention in a variety of business processes. IPA solutions go beyond simple, rule-based tasks. For example, IPA tools can apply artificial intelligence to process unst...
Related Articles
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
May 2, 2022
Community Spotlight #13: Top Products and Solutions
Hi peers, We're happy to share our new bi-weekly Community Spotlight with you. Here you'll find ...
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Apr 4, 2022
Community Spotlight #11
Hi peers, This is our new Community Spotlight that includes recent contributions (questions, a...
Download Free Report
Download our free IBM Cognos Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
655,994 professionals have used our research since 2012.