Oracle 10g Release 2 Business Intelligence Discove
Oracle 10g Release 2 Business Intelligence Discoverer Plus for End Users培训
培训大纲:
1. Introduction to Workbooks
Benefits of BI Discoverer
Understanding BI Discoverer components
Starting BI Discoverer
Opening a workbook
2. Working with Workbooks
The workbook Window
Selecting Sections in worksheets
Formatting worksheets
3. Creating Workbooks
Types Of worksheets
Creating tabular worksheets
Creating crosstab worksheets
4. Customizing the Display
Customizing item headings
Customizing data displays
Customizing worksheet titles
5. Conditions and Parameters
Creating a condition
Parameters in conditions
Designing the parameter screen
Multiple conditions
6. Group Sorts and Summaries
Creating group-sorted output
Including totals and subtotals
7. Calculated Items
Creating calculated items
Calculating percentage of the whole
Applying functions
Conversion functions
Date functions
Numeric functions
String functions
Miscellaneous functions
8. Managing Queries, Worksheets, and Workbooks
Copy a worksheet as a table
Copy a worksheet as a crosstab
Monitoring query execution
9. Conditional Formats and Stoplights
Creating conditional formats for visual differentiation
Creating stoplights for 3-band conditional highlighting
10. Drills in Worksheets
Identifying drill types
Identifying and using the various types of drills
11. Analyze Data Graphically
Graphically analyze table output
12. Scheduling and Managing Queries
Scheduling periodical queries
13. Advanced Options
Support for MS Excel HTML
Other advanced features