Saturday, 23 April 2016

Analytics and BI


Client:

§  World’s most complete, open, and integrated business software and hardware systems, with more than 370,000 customers in more than 145 countries across the globe.

§  Oracle Innovations Behind Cloud Computing.

§  Oracle aims to become #1 in middleware and #1 in applications, just as they are in database

Business  Need:
§  To reduce demand latency.

§  To improve the consistency and accuracy of external demand data to more effectively leverage demand data across functions, teams and applications.

§  Ad hoc queries and analysis capabilities for users to create their own reports and dashboards.

§  Handling of huge amount of volume

Solution:
We used the following:

§  To capture data  - Oracle Warehouse Builder.

§  To manage data - Oracle Database 10g.

§  To analyze and integrate data - Oracle Business Intelligence Enterprise Edition (OBIEE) & BPEL.

§  To connect with applications via standards-based integration  - Oracle Internet Application Server , Oracle SOA Suite.

§  Dedicated application to capture and manage large volume of external data.

§  Scalable, extensible data model based on the Oracle Data Warehouse for Retail data model.

§  Data captured, stored and analyzed at the day/SKU/store level.

§  Pre-built category  management, score carding dashboards and reporting templates.

§  Proactive detection and alerts based on user define goals and thresholds.

§  Prebuilt integration of cleansed, harmonized  data to Oracle Demantra

Benefits:
§  Demand started being fulfilled very quickly.

§  Better reporting tools were developed helping in strategizing business.


Technology Platform:

§  Oracle Warehouse Builder.

§  Oracle Internet Application Server , Oracle SOA Suite.


§  Oracle Demantra