Oracle BI Enterprise Edition 11g: Reports, Dashboards and Repositories
Course: OBIEER
Duration: 5 Days
Level: I
Course Summary
This course will help students learn how to use Oracle Business Intelligence Enterprise Edition (OBIEE). It covers key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. Students will learn how to create tables, charts, narratives, and pivot tables. This course will also provide step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Administration Tool to construct a simple repository. They will import schemas, design and build logical business models, and expose business models to users in the Oracle BI user interface. In the process of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures.
« Hide The Details
Topics Covered In This Course
Oracle Business Intelligence Enterprise Edition Overview
- OBIEE Architecture
- Key Components
- Presentation Catalog
- Signing In/Out
- Navigation
- Setting Preferences
- Interacting with Other Products
- Integration with Publisher
- Integration with Microsoft Office
Creating Analyses
- What Are Analyses?
- Dashboard embedding
- Filtering Data
- Data Hierarchies
- Conditional Formatting
- Using Analysis Prompts
- Global Variables
- Unions and Interactions
- Reusable Calculations
Building and Using Dashboards
- Dashboard Overview
- Dashboard Builder
- Creating/Editing Dashboards
- Adding Oracle BI Publisher Reports to Dashboard Pages
- Changing the Properties of a Dashboard and its Pages
- Customizations
- Template Pages
- Working with Briefing Books
Adding Views for Display in Dashboards
- Available Views
- Editing Graph Views
- Modifying Values using Write Back
- Interactions in Views
- Drilling in Views
- Sorting Data in Views
- Linking Views in Master-Detail
Filtering and Selecting Data for Analyses
- Saving Objects as Inline or Named
- Filters and Selection Steps
- Creating or Editing Column Filters
- Working with Groups and Calculated Items
Actionable Intelligence
- Overview
- Action Types
- Navigation Actions
- Action Links
- Agents & Alerts
- Conditions
Other options
- Prompting in Dashboards and Analyses
- Formatting Analyses, Views, and Dashboard Pages
- Delivering Content
- Working with Conditions
- Working with Actions
KPIs and KPI Watchlists
- Overview
- Creating/Editing KPIs
- Generating an Analysis from a KPI
- Creating or Editing KPI Watchlists
Scorecarding
- Overview
- Editor
- Creating Scorecards
- Vision Statements
- Perspectives
- Initiatives
- Strategy Trees
- Strategy Maps
- Custom Views
- Adding Scorecard Objects to Dashboards
Repository Basics
- Exploring Oracle BI architecture components
- Exploring a repository's structure, features, and functions
- Using the Oracle BI Administration Tool
- Creating a repository
- Loading a repository into Oracle BI Server memory
Building the Physical Layer of a Repository
- Importing data sources
- Setting up connection pool properties
- Defining keys and joins
- Examining physical layer object properties
- Facts & Dimensions
- Data Hierarchies
- Derived Data
- Creating alias tables
Building the Business Model and Mapping Layer of a Repository
- Building a business model
- Building logical tables, columns, and sources
- Defining logical joins
- Building measures
- Examining business model object properties
Building the Presentation Layer of a Repository
- Exploring Presentation layer objects
- Creating Presentation layer objects
- Modifying Presentation layer objects
- Examining Presentation layer object properties
Using Aggregates
- Modeling aggregate tables to improve query performance
- Setting the number of elements in a hierarchy
- Testing aggregate navigation
- Using the Aggregate Persistence Wizard
Advanced RPD
- Time Series Calculations
- Horizontal & Vertical Federation
- Row-level Security
- Fragmentation
Using Repository Variables
- Creating session variables
- Creating repository variables
- Creating initialization blocks
- Using the Variable Manager
- Using dynamic repository variables as filters
What You Can Expect
At the end of this course, delegates will be able to:
- Understand OBIEE Architecture
- Create BI Answers queries
- Create KPIs
- Create multiple query Views
- Create BI Interactive Dashboards
- Create scorecards
- Use filters
- Perform RPD Modeling
- Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository
Who Should Take This Course
Business Users, Power Users, Business Analysts, and OBIEE Administrators
Recommended Prerequisites
Database Knowledge and some understanding of Oracle Business Intelligence Enterprise Edition (OBIEE).
Training Style
Instructor led with 50% lecture and 50% lab
« Hide The Details
Related Courses
| Code |
Course Title |
Duration |
Level |
|
OBIEE |
Oracle BI Enterprise Edition (OBIEE) 11g: Reports and Dashboards |
4 Days |
I |
Details |
OBIBC |
Oracle BI Enterprise Edition (OBIEE) 11g: Boot Camp |
5 Days |
I |
Details |
OBIBR |
Oracle BI Enterprise Edition (OBIEE) 11g: Building Repositories |
5 Days |
II |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.
|
