OVERVIEW
Oracle Business Intelligence Discoverer Plus is a web-based utility that can be used to specify queries and access data in the database according to the specifications given. BI Discoverer makes finding the data easier than it often is with other interfaces. The data set that you can find is restricted to the data that is known to exist in the database. .
Students will learn how to create simple and advanced calculations to perform data analysis and create reports that answer a variety of business questions, such as, year-to-year comparisons and ranking.In addition, students will learn how to schedule reports in batch mode, share workbooks with other users, and export reports to many other applications, including MS Excel, HTML, and Oracle Reports
DURATION: 2 Days
- Generate reports and ad hoc queries
- Format queries, analyze and chart multidimensional data
- Generate parameterized reports
- Schedule reports in batch mode and share reports with other users
- Export reports to other applications
- View reports using Oracle 10g Discoverer Viewer
- Define the common words used in join terminology.
INTENDED AUDIENCE
This course is designed for people who will be designing, maintaining and/or creating queries from a relational database using Oracle Discoverer, primarily End Users, Data Warehouse Analyst, Data Warehouse Administrator.
PREREQUISITES
Experience and familiarity with Microsoft Windows applications
FORMAT/MATERIALS
This course includes a combination of lecture, discussion and numerous computer lab exercises. Each participant will receive a copy of the course manual, which will prove to be a valuable reference after class.
CONTENT – Day 1
Introduction to Oracle 10g Discoverer for End Users
- The Oracle 10g Application Server
- Oracle's Business Intelligence Solutions
- Oracle 10gAS Discoverer Components
Data Warehouse Versus Transactional Systems
- Using Discoverer with a Data Warehouse
- Starting Oracle 10gAS Discoverer
- Creating and Editing Discoverer Connections
- Where to Get Helpful Information
Creating Ad-hoc Queries
- Creating a Query and Viewing Output
- Using the Workbook Wizard
- Using the Item Navigator
- Customizing the Viewing Output
- Editing a Query
Managing Queries
- Building and Executing Queries
- Controlling Query Execution
- Customizing Worksheets
- Managing Workbooks
- Sharing Workbooks
- Setting Advanced Options
Customizing Display Properties
- Customizing Display Properties
- Setting Default Worksheet Layout Options
- Setting Default Format Options
- Applying Custom Format Options to a Worksheet
CONTENT – Day 2
Applying Conditions and Parameters
- Overview of Conditions and Parameters
- Selecting and Applying Predefined Conditions
- Creating Conditions
- Creating Complex Conditions
- Creating Parameterized Conditions
Creating Group Sorts and Applying Summary Functions
- Creating a Group Sort Output
- Creating Totals and SubTotals
- Creating Percentages
- Displaying Percentage in the Results Window
Creating Calculated Items
- Identifying Types of Calculations
- Creating a Simple Calculation
- Building a Complex Calculation
- Overview of Analytic Functions
- Analytic Functions Examples
- Using Calculations in a Condition
- Passing a Parameter to a Calculation
Analyzing Data with Drills
- Identifying the Drill Types
- Drill Up or Down
- Using the Drill Dialog Box Options
- Drilling to an External Application
Analyzing Data Graphically
- Creating Graphs
- Customizing Graphs
Exporting Worksheets to Other Applications
- Exporting to Excel
- Exporting to Reports
- Printing a Discoverer Worksheet Using the Print Wizard
CONDITIONAL FORMATS AND STOPLIGHTS
- Creating Conditional Formats for Visual Differentiation
- Creating Stoplights for 3 Band Conditional Highlighting
DRILLS IN WORKSHEETS
- Identifying Drill Types
- Identifying and Using the Various Types of Drills
ANALYZE DATA GRAPHICALLY
- Graphically Analyze Table Output
SCHEDULING AND MANAGING QUERIES
- Scheduling Periodical Queries
- Support for MS Excel HTML
- Other Advanced Features