Skip to main content

Data & Intelligence

Oracle BI vs Tableau vs Microsoft BI

Introduction

OBIEE: Oracle Business Intelligence Enterprise Edition Plus, also termed as theOBI EE Plus, is Oracle Corporation’s set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings.

Tableau: Tableau Software is a software that produces interactive data visualization products focused on business intelligence.

MSBI (SSRS): This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server.

When to choose what

OBIEE is primarily used when analytical use is required by an organization. Slice and dice of data in complex dashboards, through prompts, filters navigation, comparison etc. are primary features of OBIEE. OBIEE is also one of best tools to enable adhoc reporting among the business users. OBIEE was designed for the web and had from the beginning an excellent scalability. So if the customers want to run reports and dashboards for a very large number of users they will be better of with OBIEE. Data visualization options are available in latest versions of OBIEE as well as it’s cloud counterpart.

Tableau: Select Tableau when data visualization is the primary and probably the only aspect for a customer hands down. Data Visualization Tools are the software tools through which the raw and unstructured data can be used as informative data to increase the Business insights and sales. Tableau offers you to make rapid business strategy and decision according to your huge data but with a simple data modelling approach. Anything complex in design will NOT work with Tableau.

MSBI: It should be used when there is a need to report large volume of data. But with the introduction of Power BI, a data visualization tool and it’s integration with the cloud as well as shared point, (SQL Server 2016) it has spread its hand into visualization as well.

 

Comparative Study

 

1. OBIEE Pros and Cons:

2. Tableau Pros and Cons:

3. MSBI Pros and Cons:

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Avik Dutta

Avik is working as a Solutions Architect in Oracle BI practice in Perficient Inc. in Colorado, United States. His primary role is to lead, design & implement end to end BI projects: starting from estimation, requirement gathering, hardware sizing, design, development, testing phase, go-live, support, user training and finally handover. Avik's experience includes managing and leading small to moderate sized teams focusing primarily into OBIEE/OBIA. Avik has ~ 10.5 years of experience in DWBI domain with industry knowledge in Healthcare, Recruitment, Retail, Pharmaceutical, Education, Telecommunications, Media and Entertainment, Tours and Travels, Shipyard Constructions, Financial Services and Health Insurance. Avik has worked in different modules such as Finance, HR, Supply Chain Management, Projects, Procurement & Spend, Sales and Marketing, Student Analytics etc. In these years Avik has worked extensively in OBIA (7964 and 11g) - OBIEE (12c, OAC, BICS, 11g, 10g), BI Publisher (10g, 11g, 12c), SAP BO 4.0, BO XIR2, CR XI, SSRS 2008R2 and in PL/SQL as well. Other than these Avik has working knowledge of Informatica, ODI 11g and IBM Datastage as well.

More from this Author

Follow Us