Oracle based BI Solution with Oracle Data Warehouse
July 26, 2016

Oracle based BI Solution with Oracle Data Warehouse

Hemant Prabhakar Patil | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Warehouse

Currently, we are using Oracle Data Warehouse for service analytics, sales order management and install base module analytics. Business users are using it to solve their business problems where they want to analyse & understand different service contracts made by company, products orders, sales in different territories.
  • It provides ease, feasibility and flexibility to use Oracle out of box pre-built solutions with different verticals and horizontals of industries such as Insurance Analytics, Financial Analytics, Sales and Marketing Analytics, etc.
  • It's always easy to use Oracle Data Warehouse where you have Oracle EBS and other Oracle Transactional Systems. Since it provides pre-built data models based on various standard BI solutions (in ERP & CRM Areas).
  • With various customers and businesses using Oracle dbs for transactional systems, it is always easy to recommend oracle data warehouse in numerous beneficial ways like cost, ease for implementation and maintenance, support for various top Oracle BI tools efficiently, etc
  • Query Performance in Oracle Data warehouse compared to other parallel execution dbs is a little low. But given a chance on concentration with good Oracle DB design can overcome those problems in warehouse.
  • For Big Data Implementation, it's not very cost effective compared to other big data solutions that are based on Hadoop systems and light weight BI Tools.
  • It's more preferable with Dimensional Modeling compared to 3NF models datawarehouse.
  • It has always fulfilled BI solutions to all Business Problems in various sectors like Financial, Insurance, Pharma, Communication, etc
  • Its always easy to recommend the Oracle BI & Data Warehouse Solution with different transactional source systems based out of Oracle,SAP,Peoplesoft, JD Edwards because of proven out of box solutions in Datawarehouse in terms of pre-built ETL, reports & dashboards.
  • Now suggesting and recommending the Oracle BI & Datawarehouse solution is a toss-up based on where it's being considered, since it can not be possible to always recommend due to lot of various factors and systems involved in entire IT architecture.
Oracle Data Warehouse became immediate selection whenever we were implementing BI solutions with Dimension Modeling and Oracle based Transactional Systems, compared to other places where we used Teradata and Netezza with 3NF model structure for BI solutions. For other various businesses, where we were required to solve data/business problems with structures/unstructured data we preferred Cloudera.
It's more preferred where ERP, CRM systems are built with Oracle and then it's always highly recommendable to use Oracle data warehouse and all Oracle solutions. It also does well with other source data systems from SAP, Peoplesoft, JD Edwards. For BI/Data warehouse solutions with Structured and Unstructured Data (Big Data Solutions) it's preferable to use Hadoop systems and other visually appealing tools.