Szkolenie Analysing Data with OracleBI Discoverer Plus 10g
Czas trwania
16 godzin(y) (po 8h lekcyjnych dziennie)
W cenie szkolenia:
- efektywne szkolenie w małej grupie - średnio 4 osoby
- materiały szkoleniowe (przygotowane przez wykładowcę)
- książka powiązana tematycznie ze szkoleniem lub materiały drukowane
- certyfikaty w języku polskim i angielskim, e-certyfikat
- obiad
- catering (napoje i słodycze)
Terminy Szkoleń Otwartych
| Data rozpoczęcia | Miejscowość | Cena netto kursu | ||
|---|---|---|---|---|
| 2012-06-11 | Gdańsk | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-06-11 | Łódź | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-06-11 | Warszawa | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-06-11 | Lubin | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-06-11 | Szczecin | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-06-11 | Rzeszów | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-07-10 | Łódź | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-07-10 | Warszawa | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-07-10 | Lubin | od 1790 do 2100 PLN - zapisz się! | ||
| 2012-07-10 | Szczecin | od 1790 do 2100 PLN - zapisz się! |
Node ID: 51810
Charakterystyka kursu
This course has been created for End Users, Sales Consultants. Business Intelligence Developer or Business Analysts
who wants to learn how to Build Ad-Hoc queries, Create Advanced Reports, Schedule Reports, Share reports and analyses with other users,View reports and Create Discoverer Portlets.
Zagadnienia omawiane na kursie
Building Ad Hoc Queries
Selecting a Report Template and the Objects to Display
Customizing the Worksheet Layout
Aggregating Results for Data Points
Editing the Query Output: Pivoting
Sorting Tables and Crosstabs
Formatting Data
Managing Queries
Workbook Properties
Sharing a Workbook
General Query Management Options
Default Sheet Options
Default Format Options
Default Advanced Options
Using the URL Parameters
Creating Advanced Reports Using Plus Relational
Conditional Format
New Stoplight Format
Conditional Formatting
Managing Conditions
Calculations in a Condition
Advanced Calculations and Summary Functions with Discoverer Plus Relational
Totals and Subtotals
Percentages
Calculations
Using Analytic Functions Using Calculations in Conditions
Passing a Parameter to a Calculation
Presenting Data with Graphs in Discoverer Plus Relational
Graph Wizard to Edit Graphs
Tips for Using Graphs
Analyzing Data Using Drills in Discoverer Plus Relational
Types of Drilling
Using Filtered Drill
Drill to a Related Item
Drill to a Link
Scheduling and Distributing Reports Using Discoverer Plus Relational
Scheduling Reports
Scheduling a Workbook
Scheduling Manager
Sharing Scheduled Workbooks
Exporting Query Results
Printing Worksheets
Understanding the OLAP Data Model
Oracle BI Discoverer Data Model Options
Dimensional Data Model with Relational Data Types
Multidimensional Data Types and Models
Measure Types
Dimensional Views
Hierarchies
Levels and Attributes
Analytic Workspaces
Getting Started with Discoverer Plus OLAP
Examining the Common Schema AW Data Model : Dimensions and Measures
Workbook and Worksheet
Conditions
Saved Selections
Calculations
Prebuilt Calculations
Viewing and Using the Graph
Building Advanced Reports Using Discoverer Plus OLAP
Reports Based on Ranking and Exception Criteria
Examining a Ranking Condition
Static and Dynamic Condition Parameters
Stoplight Format
Time-Series Calculations
Forecast Reports
Distributing Business Intelligence through Discoverer Viewer and Discoverer Portlets
Distributing Discoverer Plus Reports
Sharing Discoverer Plus OLAP Content
Specifying Access Rights to Shared Content
Opening Discoverer Plus OLAP Reports
Modifying the Layout and Format of Worksheet Items
Analyzing Data with Graphs
Linking and Unlinking a Worksheet Layout
Examining Discoverer and Oracle Application Server PortalAdding Discoverer Content to a Portal Page
