What you will learn:

In this course, students study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn the reasons why data warehousing is a compelling decision-support solution in today's business climate. During the course, students examine Oracle warehouse technology, and identify the technology available from Oracle Partners for designing, implementing, and running a data warehouse.

What you will learn:

This course introduces students to the querying and analytical capabilities of Oracle Business Intelligence Discoverer Plus (OracleBI Discoverer Plus.)
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 analyses 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 OracleBI Discoverer Plus and Discoverer Viewer user interfaces
• Create ad hoc queries and advanced, interactive reports based on relational or multidimensional data

Share reports and analyses with other users

OracleBI Discoverer Administrator is a component used by Discoverer managers (business or data administrators) to create, maintain, and administer data in the End User Layer, and to define how users interact with that data. All the administrative tasks for the EUL objects (such as folders, business areas, summaries, and so on) can be performed using Discoverer Administrator.
As the Discoverer Manager, students learn how to create and customize the End User Layer, how to create business areas and folders, and to define analytical facilities for end users. Students also learn how to control the user access to the End User Layer. Students learn how to use materialized views and automated summary management.

• Implement and administer Discoverer
• Design, create, and maintain the End User Layer
• Design effective business areas
• Control user access to the End User Layer, and business areas
• Customize the End User Layer
• Optimize query performance by using summaries

Required Prerequisites:
Familiarity with Microsoft Windows Applications
Familiarity with Web browsers
OracleBI Discoverer Plus 10g: Analyze Relational and OLAP Data
Oracle Database 10g: SQL Fundamentals
Suggested Prerequisites:
Oracle Database 10g: PL/SQL Fundamentals