Oracle Discoverer Desktop for End Users
|
Summary
|
|
|||||||||||||
Oracle Discoverer Desktop for End Users
The Oracle Discoverer Desktop for End Users training course introduces the end user to the Oracle Discoverer Tool for processing workbooks. It introduces the concept of the Oracle Discoverer End User Layer (EUL) and how, by building and manipulating workbooks, they can perform analysis of the data sources at their disposal
The delegates will practise:
- Creating Workbooks and Worksheets
- Creating Table and Crosstab layouts
- Formatting Worksheets
- Using Graphs
- Using the Data Analysis tools
- Scheduling Workbooks
- Using the Scheduling Manager
- Using the Command Line Interface
- Using Discoverer Plus
- Using Discoverer Viewer
Anyone who wishes to use Oracle Discoverer to analyse data.
To provide the skills needed to analyse data using Discoverer Workbooks.
An ability to use a Windows interface.
- Oracle 10g Discoverer for Administrators
NOTE: Course technical content is subject to change without notice.
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Overview of Oracle Discoverer
- Oracle Discoverer Components
- Connecting to Oracle Discoverer
- Workbooks and Worksheets
- The Discoverer Workbook Window
- The Button Bars
- Displaying Data
- Selecting Worksheet Sections
- Viewing Pages
- Re-Ordering and Resizing Columns
- Formatting Headings and Data
- Using Graphic Bars
- Worksheet Titles
- Overview of Workbook Creation
- Adding a Table Layout Worksheet
- Adding a Crosstab Layout Worksheet
- Page-Detail Worksheets
- Duplicating Sheets
- Worksheet Management
- Creating and Editing a Condition
- Creating and Using Parameters
- Advanced Conditions
- Creating COUNTS on a worksheet
- Creating and Editing Calculations
- Introduction to Oracle functions
- Overview of Graphs in Oracle Discoverer Worksheets
- The Graph Tool Bar
- Creating a Graph
- Modifying a Graph
- Reference Lines and Pull-Outs
- Rotating a Graph
- Pivoting Data
- Drilling into Data
- Sorting Data
- Overview of the Data Analysis Tools
- Creating and Editing a Total
- Creating and Editing a Percentage
- Formatting Exceptions
Note - in practice this session may start on the first day
- Printed Reports
- Scheduled Reports
- Using the Scheduling Manager
- Subqueries
- Correlating a Subquery
- Setting Oracle Discoverer Options
- Introduction - Analytical Functions and their Purpose
- Examples of Analytical Functions
- Creating Calculations using Analytical Functions
- Overview of Discoverer on the Web
- Discoverer on the Web components
- Accessing Oracle Discoverer Workbooks
- Running Oracle Discoverer Plus for the first time
- Maintaining Discoverer Preferences
- Accessing the connections page
- Creating Private Connections
- Using Oracle Discoverer Plus
- Using Oracle Discoverer Viewer
- Accessing the connections page
- Creating Private Connections
- Using Oracle Discoverer Plus
- Using Oracle Discoverer Viewer
If you want to find out more about Oracle Discoverer Desktop for End Users, you can make an information request below and the school will contact you with further information.
Expenses
StayAhead Training
StayAhead Training - SQL, Oracle, UNIX and Linux training courses delivered by IT experts
StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.
StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.
Specialist IT training for professionals
StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena.
UNIX training courses not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle training courses also have depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.
In-house Professional IT training for your organisation
In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.
StayAhead's focus on IT training
StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.
Show all courses with
StayAhead Training
Request information - obligation free
Contact information for StayAhead Training
Phone no: +44 (0)20 7600 6116 
To request information from Oracle Discoverer Desktop for End Users, please fill out the following details:
