It’s interesting to note that operational data can be derived not only from an Oracle database but also from external sources. The following diagram gives a conceptual depiction of what a Business Intelligence system backed by an Oracle database might look like
Oracle business intelligence applications plus#
To make the data more suitable for analysis, Discoverer Plus allows us to organize it into worksheets, grouped in turn into workbooks. It begins with Discoverer Administrator, which is used to create a business-oriented view of the underlying data, a grouping that data into the so-called ‘business areas’-collections of related information to be used by Discoverer Plus as input data. The Business Intelligence system shown employs several Oracle Business components to convert data into information. The following diagram illustrates a simple example of a Business Intelligence system built using Oracle Business Intelligence components: Oracle Spreadsheet Add-In for sharing data, making it possible for you to work with Oracle OLAP data in MS Excel.Oracle Reports Developer for building and publishing reports.Oracle Discoverer Desktop for analyzing relational data and creating reports, which is a Windows-only application.Oracle Warehouse Builder for designing and deploying data warehouses, data marts, and Business Intelligence applications.Oracle Discoverer Administrator for structuring data for analysis.In addition, there are some useful tools in the Oracle Business Intelligence Tools package: Interested in taking the Intellipaat OBIEE developer training course to get ahead. Oracle Reports for reporting and publishing.Oracle Discoverer Portlet Provider for publishing existing Discoverer reports to OracleAS Portal.Oracle Discoverer Viewer for reporting and publishing.Oracle Discoverer Plus OLAP for analyzing multidimensional data and creating reports.Oracle Discoverer Plus Relational for analyzing relational data and creating reports.The following is a list of the most popular components designed for analysis and reporting, which are included in the Oracle Business Intelligence package: Learn more in this Intellipaat OBIEE training now. Oracle Business Intelligence is implemented as a collection of components grouped into suites, which are part of either Oracle Application Server or Oracle Fusion Middleware. Oracle Business Intelligence allows us to go beyond simple database-driven applications with the help of SQL queries to derive information from the data being collected and stored.
0 kommentar(er)
