Course details
Oracle BI : AS Discoverer 10g: Create Queries and Reports (Web)
This class will teach students the purpose and capabilities of the Discoverer 10g AS tool. Thereafter, each user can learn to apply this knowledge to the company`s internal data model.
View other Oracle Courses available
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
- Oracle Application Server 10g: Administration I is recommended, but not mandatory.
DATA ANALYSIS REVIEW :
- What is data analysis
- Introduction to oracle10g discoverer
- Discoverer components
- Important terminology
- The training environment
CREATING QUERIES :
- Starting discoverer as
- Online help
- The workbook wizard
- The results window
QUERY MANAGEMENT :
- managing workbooks
- Saving workbooks
- Opening workbooks
- Deleting workbooks
- Sharing workbooks
- Managing worksheets
- Moving/copying worksheets
- Editing worksheets
- Renaming and deleting worksheets
MODIFYING THE DISPLAY :
- adding a report title
- adding a report footer
- Print preview/page setup options
- Page setup options
- Formatting headings
- Modifying heading properties
- Formatting data
- Changing default column size
- Modifying data display properties
- Setting heading and data format defaults
WORKING WITH CONDITIONS AND PARAMETERS :
- Working with conditions
- Viewing, applying, disabling conditions
CREATING NEW CONDITIONS :
- using the new condition dialog
- Multiple and nested formula conditions
- Create conditions using the analysis bar
- Editing conditions working with parameters
- Viewing, applying, and disabling parameters
- Creating new parameters
- Executing the query with the parameter wizard
- Editing parameters
WORKING WITH CONDITIONAL FORMATS AND CALCULATIONS :
- working with conditional formats
- How conditional formats are used
- Viewing, applying, disabling exceptions
- Creating and editing conditional formats
- Working with calculations
- Viewing, displaying, hiding calculations
- Creating calculations using the edit calculation dialog
- Creating calculations using the tool bar
- Editing calculations
WORKING WITH SORTS, TOTALS, AND PERCENTAGES :
- Working with sorts
- Creating column sorts
- Creating group sorts
- The sort table dialog
- Working with totals
- Viewing, displaying, hiding totals
- Creating/editing totals using the total dialog
- Working with percentages
- Viewing, displaying, hiding percentages
- Creating/editing percentages
- Using the percentage dialog
- Using the tool bar to create percentages
- Drilling the data
- Using drills in discoverer
- Drilling from the workbook window
- Using the drill dialog
- Specifying drill options
- Drilling to external applications
GRAPHING DATA :
- Creating a graph
- Selecting a graph type
- The graph window
WORKBOOK MAINTENANCE :
- Scheduling workbooks
- Schedule workbook dialog
- Scheduling manager
- Opening scheduled workbooks
- Exporting discoverer output
- Using the export dialog
WORKING WITH SQL AND SETTING OPTIONS :
- Viewing, exporting, and importing sql
- The sql inspector/plan display
- Setting discoverer options
- General options
- Query governor options
- Sheet options
- Format options
- Advanced options
- Eul options using sql functions in discoverer
- Using functions in discoverer
- Function categories
- Types of functions
- String functions
- Character string formatting functions
- Character string manipulation functions
- Numeric functions
- Numeric comparison and presentation functions
- Date functions
- Date recalculation functions
- Nesting functions
- Using analytic functions
INTRODUCTION TO DISCOVERER VIEWER :
- What is discoverer viewer
- Starting discoverer viewer
- Using discoverer viewer
- Differences between discoverer plus and discoverer viewer
INTRODUCTION TO DISCOVERER DESKTOP INTERFACES (OPTIONAL) :
- Discoverer desktop
- Using discoverer desktop
- Compare/contrast plus and desktop
- Preparing for practice exercises
- Workshop system requirements
- Extracting the student files
- Preparing to run the sql scripts
- Creating student accounts
- Creating the camp_src schema
- Building the end user layer and business area
- Setting security and privileges
- Registering the sales_tax() function
- Copying the sample word document
- testing the setup
Course Location
About Professional Training Solutions Ltd
Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
See all Professional Training Solutions Ltd courses Are you from Professional Training Solutions Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on Oracle starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Programmer - CPD Certified Apex LearningEUR 165Duration: Upto 165 Hours
- EUR 11Duration: Upto 3 Hours
