Know about Business intelligence?
Business intelligence analyze data to answer business questions and predict future trends.
Oracle Business Intelligence Discoverer is a great business intelligence tool because it enables users to analyze data.
Discoverer works in the same way It feeds the woorsheet data with sql codes correspondance to the database and results out from the database.
It has administration and user edition.
Admin edition components are,
End user layer-business layer-folder-items-joins
Perform Business Analysis of User requirements
Mapping User needs to Database Structures
Create End User Layer (EUL)
Create Business Areas
Refine Business Areas to fit User needs
Use Admin Edition to maintain Business Areas
Privileges to Users/Roles
Folders -- based on tables and views.
Items -- based on columns
Business areas are stored in the End User Layer.
Steps for Creating Workbook
Create new workbook / Open an existing workbook
Choose the type of layout
-Table,
-crosstab
-page detail table
-Page-Detail crosstab
Choose the Business Area
Choose the required columns from folders
Define conditions
Define sorting options
Define Calculations (Formula’s)