Oracle Business Intelligence Competency
Areas of Specialization
- Domains
- Banking and Financial Services, Manufacturing, Retail, Logistics, Healthcare, Insurance
- Tools
- Oracle Fusion Middleware
- ETL: Oracle Warehouse Builder, Oracle Sunopsis Reporting, Oracle Discoverer, Oracle Spreadsheets, Oracle Reports
- BI Solutions
- Oracle BI Beans, Oracle BI Suite, Oracle BI Portfolio
- Portal: Oracle Portal, Oracle Applications, Oracle Financial Analyzer, Oracle OLAP Server
Service Offerings
- Oracle BI End-to-End Implementation
- Oracle BI Support and Operations
- Oracle BI Professional Services
- Oracle BI Migrations (Data and Application)
- Business Solutions surrounding Oracle based Source systems
- Oracle BI and Portal Integration
Focus Areas
- Oracle BI Enterprise Edition
- Oracle Customer Data Hub (Oracle CDH)
- Oracle OLAP
- Oracle Data Integrator • Oracle Data Mining
- Oracle AS Portal
The Approach
The solution was carried out in different phases:
- Design: Detailed design for the solution
- Develop: It involved target structure creation, ETL scripts, NSI jobs, Job Queues, BO Universe/reports
- Test: Performed Unit tests, System Integration Tests, and User Acceptance Test
- Deploy: Objects (tables, procedures, DB links, Jobs, BO Universe, reports) moved to production
- Operation/Support: Monitor daily and weekly load, periodical report refreshment and maintenance of objects moved to production
Advantages
- Enterprise Business View: DW and ERP ‘Go-Live’ will happen on the same day enabling the customer to achieve their business objectives immediately