Databases Reference
In-Depth Information
Figure 10-4. Oracle Business Intelligence Dashboard
Oracle has an enterprise portal offering, WebCenter, available as part of the Oracle
Application Server, providing an integration point for custom-built business intelli‐
gence applications using Oracle Business Intelligence tools. For example, the BI Pre‐
sentation Services offer an interface using the Simple Object Access Protocol (SOAP)
to embed results into WebCenter. WebCenter can also enable social collaboration using
the BI content.
Business Intelligence Applications
Business intelligence applications are prebuilt solutions providing extended reporting
and “dashboard-like” interfaces to display business trends. These applications directly
access data warehouse schema and sometimes also blend in transactional data sources.
The data warehousing type of solutions can include prebuilt ETL from known trans‐
actional data sources. The business intelligence applications often focus on specific areas
of the business, such as marketing or financial analysis, or industry data models in areas
such as communications, finance, healthcare, and retail.
Oracle Business Intelligence Applications include star schema data models with con‐
formed dimensions deployed to relational databases such as Oracle, more than 2,500
KPIs displayed in predefined dashboards, and feature prebuilt ETL mappings from
Oracle Fusion Applications, Siebel CRM, Oracle E-Business Suite, PeopleSoft, JD Ed‐
wards, SAP, and other applications. The applications cover the areas of Sales, Service
and Contact Center, Marketing, Financial, Supply Chain, Projects, and Workforce.
Oracle is continuing to extend the KPIs provided, the ETL mappings, and the business
areas covered.
