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.
Students begin by using the Oracle BI Administration Tool to construct repositories. 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. They also learn how to validate their work by creating and running analyses, and verifying query results using the query log.
Students will use the more complex business requirements, such as logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data.
Topics Covered In This Course
Oracle Business Intelligence Enterprise Edition Overview
- Presentation Catalog
- Signing In/Out
- Navigation
- Setting Preferences
- Interacting with Other Products
- Integration with Publisher
- Integration with Microsoft Office
Creating Analyses
- What Are Analyses?
- How Are Analyses Processed?
- Embedding an Analysis in a Dashboard
- Understanding the Double Column Feature
- Creating New Analyses
- Specifying the Criteria for Analyses Editing the Formula for a Column
Adding Views for Display in Dashboards
- Available Views
- Editing Graph Views
- Modifying Values and Performing Write Back
- Interactions in Views
- Drilling in Views
- Sorting Data in Views Common Sort Functionality
- Linking Views in Master-Detail
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
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
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
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
- 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
Adding Calculations to a Fact
- Creating new calculation measures based on existing logical columns
- Creating new calculation measures based on physical columns
- Creating new calculation measures using the Calculation Wizard
- Creating measures using functions
Working with Logical Dimensions
- Creating logical dimension hierarchies
- Creating level-based measures
- Creating share measures
- Creating dimension-specific aggregation rules
- Creating presentation hierarchies
- Creating parent-child hierarchies
- Using calculated members
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
Modeling Time Series Data
- Using time comparisons in business analysis
- Using Oracle BI time series functions to model time series data
Modeling Many-to-Many Relationships
- Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
What You Can Expect
At the end of this course, students will be able to:
- Create BI queries
- Create KPIs
- Create multiple query views
- Create BI Interactive Dashboards
- Create Scorecards
- Use filters
- Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository
- Build a dimensional business model to address business intelligence requirements
- Build and execute analyses to test and verify a dimensional business model analyses
- Use the Oracle BI Administration Tool to administer Oracle BI Server
Who Should Take This Course
Business Users, Developers, Business Analysts, and OBIEE Administrators
Recommended Prerequisites
Students should know basic SQL and have some exposure to Data Warehouse concepts, Database modeling, and Dimensional modeling.
Training Style
Instructor led with 50% lecture and 50% lab.
Related Courses
| Code |
Course Title |
Duration |
Level |
|
OWPDP |
Oracle Physical Data Warehouse Design and Implementation |
4 Days |
I |
Details |
OBIEE |
Oracle BI Enterprise Edition (OBIEE) 11g: Reports and Dashboards |
4 Days |
I |
Details |
DWHFUN |
Data Warehousing Fundamentals |
3 Days |
I |
Details |
OBIEER |
Oracle BI Enterprise Edition 11g: Reports, Dashboards and Repositories |
5 Days |
I |
Details |
ORDWA |
Oracle Database 11g: Administer a Data Warehouse |
5 Days |
II |
Details |
DWMODEL |
Dimensional Modeling for Data Warehouse Projects |
5 Days |
II |
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.
