OBI study plan
OBI · Give each week a clear focus.
8 weeks · About 7 hours per week
Oracle BI Architecture and Components & Data Modeling and the BI Server Repository
Diagram the end-to-end Oracle BI request path from client to database, labeling the Presentation Server, BI Server, physical layer, and data sources
Distinguish the three repository layers and state which object types live in each
Identify the administrative tools used to edit and deploy a repository and describe what each one does
Enumerate the main components of an Oracle BI installation and explain the role of each in query processing
Your checkpoint
A one-page labeled architecture diagram plus a layer-to-object-type mapping table covering all three repository layers
Data Modeling and the BI Server Repository
Build physical layer objects by importing table metadata and defining joins between them
Construct a business model with logical tables, logical columns, and at least one logical table source
Define a dimensional hierarchy with levels and connect it to the business model
Resolve a fan-trap or chasm-trap scenario by adding a bridge or alias strategy and document the fix
Your checkpoint
A working three-layer repository that answers at least five test queries correctly against a sample schema
Data Modeling and the BI Server Repository & Building and Administering the Presentation Layer
Create measures with correct aggregation rules and verify each default aggregation against a hand-computed total
Add calculated logical columns and confirm they roll up correctly across a hierarchy
Expose the business model through a presentation layer with user-friendly names and folders
Write and test at least three level-based measures or time-series calculations
Your checkpoint
A presentation catalog with organized folders and five validated measures whose results match manual SQL checks
Building and Administering the Presentation Layer & Creating Analyses and Dashboards
Configure column formatting, sort order, and drill behavior in the presentation layer
Build an analysis with at least two views, including a pivot table and a chart
Add filters, prompts, and a dashboard page that combines multiple analyses
Apply a dashboard prompt so that a single selection filters every analysis on the page
Your checkpoint
A published two-page dashboard driven by shared prompts, with screenshots of each page saved for later review
Creating Analyses and Dashboards & Security and User Management
Create a KPI-style analysis using conditional formatting and a gauge or bullet view
Define users, groups, and application roles, and assign catalog permissions to each
Implement row-level security by applying a data filter to a group and verify results as a restricted user
Test object-level and column-level access so that restricted users see only permitted data and columns
Your checkpoint
A security test log showing query results for three user accounts, each with different data and object access
Security and User Management & Performance Tuning and Caching
Explain how authentication providers and initialization blocks supply identities and session variables
Set up a dynamic repository variable and use it inside a filter
Enable and verify query caching, then measure response time with the cache warm and cold
Identify the main levers for improving a slow query, including aggregate tables and index strategy
Your checkpoint
A caching benchmark table comparing warm-cache and cold-cache response times for three representative queries
Performance Tuning and Caching & Integration and Administration Tasks
Read a query log entry and trace a logical request down to the generated physical SQL
Tune one deliberately slow analysis using an aggregate table or summary object and record the before-and-after timings
Describe the standard procedure for migrating a repository and catalog between environments
List the routine administration tasks for usage tracking, log management, and backup
Your checkpoint
A before-and-after tuning report for one slow analysis, including the generated SQL and timing evidence
Oracle BI Architecture and Components & Data Modeling and the BI Server Repository & Building and Administering the Presentation Layer & Creating Analyses and Dashboards & Security and User Management & Performance Tuning and Caching & Integration and Administration Tasks
Assemble a complete practice environment covering repository, presentation layer, dashboard, and security
Review every domain against the exam weighting and list weak areas with remediation steps
Complete a timed practice set and analyze every incorrect answer by domain
Re-verify the two weakest domains with hands-on exercises
Your checkpoint
A domain-by-domain readiness scorecard with a remediation note for each area scoring below target
Milestones
Week 2: Repository builds and answers five test queries correctly across all three layers
Week 4: Dashboard is published and driven by a single shared prompt; all views render correctly
Week 6: Row-level security verified with three user accounts; caching benchmark complete
Week 8: Readiness scorecard shows every domain at or above the target threshold