OBIEE
40 hrs Theory Sessions
40 hrs of Practice Sessions
30 hrs of Hands-on Project
Introduction
OBIEE training by real-time experts with step-by-step instructions for creating Oracle BI reports and dashboards in business intelligence applications. At the end of the OBIEE Course, participants have hands-on BI skills in OBIEE and can use study materials provided by us to prepare for the OBIEE certification exam and job interviews.
Course Objective
In our training, you will learn about :
- Oracle Business Intelligence architecture
- How to build a physical layer, BMM layer, and Presentation layer.
- Working with multiple LTS
- System and Non-System Session Variables
- Multi-User Development Environment
- Creating KPIs, Scorecards, and Action links
Pre-requisites
- No, but a basic understanding of SQL would be an added advantage, which is provided as a Free Add-on along with the course.
Learning Outcomes
- OBIEE Concepts in-depth
- Verifiable OBIEE Course completion certificate
- OBIEE Career Guidance from the SME
Target Audience
- Anyone looking to start their career in Business Intelligence or Data Analysis domains.
- Project Managers and Technical Business Analysts
Course Curriculum
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
- Installing the BI Client software
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
- Printing the physical layer diagram
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
- Printing the business model and mapping layer diagram
Building the Presentation Layer of a Repository
- Exploring presentation layer objects
- Creating presentation layer objects
- Modifying presentation layer objects
- Examining presentation layer object properties
- Nesting presentation tables
- Controlling presentation layer object visibility
Testing and Validating a Repository
- Checking repository consistency
- Turning on logging
- Uploading the repository through Enterprise Manager
- Executing analyses to test the repository
- Inspecting the query log
Managing Logical Table Sources
- Adding multiple logical table sources to a logical table
- Specifying logical content
Adding Calculations to a Fact
- Creating new calculation measures based on 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
- Creating ragged and skipped-level hierarchies
Enabling Usage Tracking
- Creating the usage tracking tables
- Setting up the sample usage tracking repository
- Tracking and storing Oracle BI Server usage at the detailed query level
- Using usage tracking statistics to optimize query performance and aggregation strategies
Using Model Checker and Aggregates
- Using Model Check Manager
- Modelling aggregate tables to improve query performance
- Using the Aggregate Persistence Wizard
- Testing aggregate navigation
- Setting the number of elements in a hierarchy
Using Partitions and Fragments
- Exploring partition types
- Modelling partitions in an Oracle BI repository
Using Repository & Session Variables
- Creating session variables
- Creating repository variables
- Creating initialization blocks
- Using the Variable Manager
- Using dynamic repository variables as filters
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 & fact tables
Setting an Implicit Fact Column
- Ensuring the correct results for dimension-only queries
- Selecting a predetermined fact table source
- Specifying a default join path between dimension tables
Security
- Exploring Oracle BI default security settings
- Creating users and groups
- Creating application roles
- Setting up object permissions
- Setting row-level security (data filters)
- Setting query limits and timing restrictions
Cache Management
- Restricting tables as non-cacheable
- Using Cache Manager
- Inspecting cache reports
- Purging cache entries
- Modifying cache parameters and options
- Seeding the cache
Hands-on
OBIEE Training course aims to deliver quality training that covers solid fundamental knowledge on core concepts with a practical approach. Such exposure to the current industry use-cases and scenarios will help learners scale up their skills and perform real-time projects with the best practices.