Oracle - Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data
Seminar
In Dresden
Beschreibung
-
Kursart
Seminar
-
Ort
Dresden
-
Dauer
2 Tage
-
Beginn
auf Anfrage
Oracle - Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data: This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus 11g (Oracle BI Discoverer Plus 11g.) Students will learn how to use Discoverer Plus to query, report, and analyze corporate data. They will learn how to use Discoverer Plus Relational to.. Gerichtet an: This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus 11g (Oracle BI Discoverer Plus 11g.) Students will learn how to use Discoverer Plus to query, report, and analyze corporate data. They will learn how to use Discoverer Plus Relational to perform ad hoc analysis against relational data sources, and how to use Discoverer Plus OLAP to perform analysis on OLAP data that resides in a multidimensional data source. ...
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
Erforderliche Vorkenntnisse: Familiarity with Web browsers Empfohlene Vorkenntnisse: Basic knowledge of SQL
Meinungen
Erfolge dieses Bildungszentrums
Sämtlich Kurse sind auf dem neuesten Stand
Die Durchschnittsbewertung liegt über 3,7
Mehr als 50 Meinungen in den letzten 12 Monaten
Dieses Bildungszentrum ist seit 15 Mitglied auf Emagister
Themen
- Access
- Datenbank
- OLAP
- Business Intelligence
- DB
- Oracle Datenbanken
- Business
Inhalte
Oracle - Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data: This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus 11g (Oracle BI Discoverer Plus 11g.)
Students will learn how to use Discoverer Plus to query, report, and analyze corporate data. They will learn how to use Discoverer Plus Relational to perform ad hoc analysis against relational data sources, and how to use Discoverer Plus OLAP to perform analysis on OLAP data that resides in a multidimensional data source.
Learn To:
- Use the new Discoverer Plus Relational and Discoverer Plus OLAP user interfaces
- Create ad hoc queries and advanced, interactive reports based on relational or multidimensional data
- Share reports and analyses with other users
Teilnehmerkreis:
- Businessanalytiker
- Vertriebsberater
- Endbenutzer
- Use Oracle BI Discoverer Plus Relational to access a relational data source
- Use Oracle BI Discoverer Plus OLAP to access a multidimensional data source
- Create ad hoc queries and advanced reports based on relational or multidimensional data
- Create exception or stoplight formatting
- Use graphs to present data
- Analyze data using drilling and pivoting
- Generate parameterized reports
- Create calculations and conditions
- Schedule reports
- Share reports with other users through Discoverer Viewer and Oracle Portal
ZIELGRUPPE
This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus 11g (Oracle BI Discoverer Plus 11g.)
Students will learn how to use Discoverer Plus to query, report, and analyze corporate data. They will learn how to use Discoverer Plus Relational to perform ad hoc analysis against relational data sources, and how to use Discoverer Plus OLAP to perform analysis on OLAP data that resides in a multidimensional data source.
Learn To:
- Use the new Discoverer Plus Relational and Discoverer Plus OLAP user interfaces
- Create ad hoc queries and advanced, interactive reports based on relational or multidimensional data
- Share reports and analyses with other users
Teilnehmerkreis:
- Businessanalytiker
- Vertriebsberater
- Endbenutzer
- Use Oracle BI Discoverer Plus Relational to access a relational data source
- Use Oracle BI Discoverer Plus OLAP to access a multidimensional data source
- Create ad hoc queries and advanced reports based on relational or multidimensional data
- Create exception or stoplight formatting
- Use graphs to present data
- Analyze data using drilling and pivoting
- Generate parameterized reports
- Create calculations and conditions
- Schedule reports
- Share reports with other users through Discoverer Viewer and Oracle Portal
KURSINHALT
Sachgebiete:
Introducing Oracle BI Discoverer 11g
- Challenges faced in managing BI applications
- Evolving role of Business Intelligence
- Addressing BI Requirements- Portfolio Approach
- Oracle Fusion Middleware 11g- An Overview
- Fusion Middleware BI Solution
- Components of Oracle BI Discoverer 11g
- Data Warehouse Versus Transactional System
- Using Discoverer with a Data Warehouse or a Transactional Database
- End Users
- Getting helpful Information
- Key Terminology
- Creating Reports
- Editing the query output by Sorting, Pivoting, Adding and Deleting items
- Customizing Display properties of reports
- Managing Workbooks and Worksheets
- Adding New Worksheets
- Viewing and Modifying Worksheet Properties
- Setting Query Management, Query Execution, and Query Governor Options
- Using Discoverer URL Parameters
- Using Conditional Formatting
- Using Predefined Conditions
- Creating and Managing Conditions
- Creating A Parameterized Report
- Creating Parameters
- Passing Parameters to a Condition
- Using Cascading Parameters
- Creating Totals, Subtotals, and Percentages
- Creating Simple and Complex Calculations
- Using Analytic Function Template in Calculations
- Using Calculations in Conditions
- Passing a Parameter Value to a Condition
- Viewing Graphs to Display Worksheet Data
- Editing Graphs
- Using the Toolbar Options to Edit Graphs
- Identifying Different Types of Drilling
- Drilling up Or Drilling down along a predefined hierarchy
- Drilling to a Related Item
- Drilling to Detail
- Drilling to a Link
- Scheduling Reports- An Overview
- Scheduling A Workbook in Discoverer Plus Relational
- Managing Scheduled Workbooks
- Sharing Scheduled Workbooks
- Exporting the Query Results to Various Formats- MS Excel, HTML, PDF, Web Query for MS Excel, and so on.
- Printing Query Results
- Describing the Differences between Relational and Multidimensional Data Models
- Describing the Primary data types associated with the OLAP Data models :
- - Dimensions
- - Measures
- - Cubes
- - Hierarchies
- - Analytic Workspace, and so on.
- Creating a workbook, and a worksheet using Discoverer Plus OLAP
- Creating and Editing OLAP Queries
- Creating and Using Saved Selections
- Creating and Using Calculations
- Modifying the Layout and Format of Crosstabs and Graphs
- Adding new worksheets
- Creating reports based on ranking and exception criteria
- Adding visual cues (stoplights) to the report that highlight specific data ranges
- Creating reports using time-series calculations
- Creating and using calculated (custom) members in a report
- Understanding distribution options for Discoverer Plus reports
- Using Discoverer Viewer to access Discoverer Plus reports (both Relational and OLAP reports)
- Describing how to publish Discoverer Plus reports on Oracle Portal pages
- Oracle BI Discoverer Administrator 11g: Develop an EUL
VORRAUSSETZUNG
Erforderliche Vorkenntnisse:
- Familiarity with Web browsers
- Basic knowledge of SQL
Oracle - Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data