Course Overview
About Course
This 40‑hour OBIEE training offers a complete path to mastering Oracle’s enterprise-grade business intelligence platform. Starting with foundational BI and OBIEE architecture, learners progress to hands-on repository modeling: defining physical, logical, and presentation layers, aggregates, variables, hierarchies, and partitioning strategies.
The course emphasizes practical competency in OBIEE Answers for ad-hoc reporting and formatting, BI Publisher for formal templated reporting, and dashboards enriched with selectors, prompts, and navigation features. Users also gain experience with Visual Analyzer for agile self-service analytics.
Security and governance are central—training covers role-based access control, row-level filters, caching policies, and query limits. Performance modules teach tuning repositories, managing cache, and monitoring server sessions. Hands-on administration labs cover lifecycle migration, patching, server configuration, and backup using Enterprise Manager.
Participants undertake a capstone project developing an end-to-end OBIEE implementation—from data modeling to secure dashboards and performance tuning. Mock certification exercises prepare them for OBIEE Developer and Admin roles. With a strong balance of labs, tool exposure, expert guidance, and certification prep, graduates emerge ready to architect, deploy, and administer OBIEE solutions, delivering impactful analytics within enterprise environments.
Course Syllabus
Module 1: OBIEE Overview & Data Warehouse Fundamentals (4 hrs)
- Learn OBIEE architecture—the BI Server, Presentation layer, Web catalog, and BI Publisher.
- Cover OLAP vs. OLTP, dimensional modeling, star/snowflake schemas, essential BI concepts .
Module 2: Installation & Environment Setup (4 hrs)
- Install OBIEE 12c or 11g, set up WebLogic, configure ODBC/JDBC, initialize BI Server and Presentation Services
Module 3: Repository (RPD) Development – Physical Layer (6 hrs)
- Use Administration Tool to import metadata, configure connection pools, define tables, keys, joins, and aliases
Module 4: Repository – Business & Presentation Layers (6 hrs)
- Create logical objects: fact tables, aggregates, hierarchies, measures; configure presentation layer: logical tables, columns, foldering
Module 5: Repository Optimization & Variables (4 hrs)
- Build aggregate tables, partitions; set up session/repository variables and initialization blocks
Module 6: OBIEE Answers & Analysis (4 hrs)
- Build analyses: ad-hoc reports, prompts, filters, pivot tables, charts, conditional formatting, caching strategies
Module 7: Dashboards, BI Publisher & Visual Analyzer (4 hrs)
- Design interactive dashboards with selectors, navigation; create BI Publisher templates and use Visual Analyzer for self-service insights
Module 8: Security & Access Control (4 hrs)
- Implement user/group security, object-level and row-level access, query limits, and caching control .
Module 9: Performance Tuning & Administration (4 hrs)
- Monitor BI Server sessions, tune repository (VLDB settings), aggregation, cache management; use Administration tools and usage tracking
Module 10: OBIEE 12c New Features & Upgrades (4 hrs)
- Explore key features in 12c: Visual Analyzer enhancements, master-detail linking, KPI and scorecards
Module 11: Environment Management & Lifecycle Migration (4 hrs)
- Manage multi-user development, repository merging and patching, backup, restore, and lifecycle migration with Enterprise Manager
Module 12: Capstone Project & Certification Prep (2 hrs)
- Build an end-to-end OBIEE solution: model, analyze, dashboard, secure, tune. Prepare for Oracle OBIEE certification with mock exams
-
Key Features
Hands-on labs (60‑70%): real-world BI workflows—RPD modeling, analytics, dashboards, BI Publisher, security, tuning.
Live expert-led sessions: introduces best practices, Q&A, peer code reviews.
Comprehensive tool coverage: Admin Tool, Answers, Dashboards, BI Publisher, Visual Analyzer, OBIEE Administration.
Performance & governance focus: repository optimization, session caching, security models, lifecycle management.
Certification alignment: mock exams, exam skills for OBIEE Developer/Administrator roles.
Support & resources: session recordings, sample RPDs, report templates, community forum.
Our Upcoming Batches
At Topskill.ai, we understand that today’s professionals navigate demanding schedules.
To support your continuous learning, we offer fully flexible session timings across all our trainings.
Below is the schedule for our Training. If these time slots don’t align with your availability, simply let us know—we’ll be happy to design a customized timetable that works for you.
Training Timetable
| Batches Online/Offline | Batch Start Date | Session Days | Time Slot (IST) | Fees |
|---|---|---|---|---|
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 7:00 AM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 11:00 AM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 5:00 PM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 7:00 PM (Class 1-1.30 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 7:00 AM (Class 3 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 10:00 AM (Class 3 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 11:00 AM (Class 3 Hrs) | View Fees |
For any adjustments or bespoke scheduling requests, reach out to our admissions team at
support@topskill.ai or call +91-8431222743.
We’re committed to ensuring your training fits seamlessly into your professional life.
Note: Clicking “View Fees” will direct you to detailed fee structures, instalment options, and available discounts.
Don’t see a batch that fits your schedule? Click here to Request a Batch to design a bespoke training timetable.
Corporate Training
“Looking to give your employees the experience of the latest trending technologies? We’re here to make it happen!”
