Secure and Tune OAS Models
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Recommended experience
Recommended experience
What you'll learn
Governed RPD architecture ensures trusted analytics through a structured semantic model that delivers consistent, governed reporting.
Security governance requires continuous validation of object-level and row-level policies across every promotion stage to maintain compliance.
Performance bottlenecks are solved through query analysis, cache tuning, and aggregate persistence for reliable throughput.
Release discipline ensures production-grade BI through peer reviews, controlled promotions, and performance threshold validation.
Skills you'll gain
Details to know
June 2026
See how employees at top companies are mastering in-demand skills
There are 3 modules in this course
Are governance gaps costing your BI team more time than insight delivery? This Short Course was created to help Business Intelligence professionals accomplish governed RPD modeling, compliant security enforcement, and performance optimization in Oracle Analytics Server. By completing this course, you'll build production-ready semantic models, lock down role-based access across environments, and tune dashboards to hit enterprise throughput benchmarks — skills applicable the next day at work. By the end of this course, you will be able to: Create and validate a governed three-layer RPD model (Create); Analyze and enforce object- and row-level security policies across Dev, Test, and Prod (Analyze); Evaluate platform performance using query logs, cache seeding, and aggregate persistence (Evaluate). This course is unique because it follows the full OAS governance lifecycle using Oracle's native toolset. To be successful, you should have a background in OAS fundamentals and enterprise data modeling at a CB3 senior level.
You will design, configure, and validate a governed three-layer RPD model in Oracle Analytics Server, covering physical joins, logical calculations, and presentation hierarchies to standardize enterprise subject areas.
What's included
1 video2 readings2 assignments
1 video•Total 2 minutes
- When Semantic Layers Break: The Cost of Ungoverned RPD Architecture•2 minutes
2 readings•Total 21 minutes
- The Three-Layer RPD Model: Physical, Business Model, and Presentation Layers•15 minutes
- Constructing a Customer 360 RPD Model in the Oracle BI Administration Tool •6 minutes
2 assignments•Total 26 minutes
- Design Review: Validating a Three-Layer RPD Model for Enterprise Subject Areas•20 minutes
- Knowledge Check: Building a Governed Three-Layer RPD Model•6 minutes
You will analyze and enforce object-level and row-level security policies within the OAS RPD and catalog, validating compliant role matrix enforcement across Dev, Test, and Production environments.
What's included
1 video1 reading2 assignments
1 video•Total 8 minutes
- Object-Level and Row-Level Security in OAS: Policy Types, Role Matrices, and Catalog Controls•8 minutes
1 reading•Total 6 minutes
- Configuring Object-Level and Row-Level Security Policies in the RPD Editor and Catalog Manager•6 minutes
2 assignments•Total 21 minutes
- Security Policy Audit Report: Role Matrix Enforcement Across Three Environments•15 minutes
- Knowledge Check: Enforcing Object-Level and Row-Level Security•6 minutes
You will evaluate OAS platform performance by interpreting query logs, configuring query caching, and applying aggregate persistence to certify that dashboards and scheduled Publisher reports meet the 95th-percentile throughput threshold.
What's included
2 readings2 assignments
2 readings•Total 10 minutes
- When Dashboards Miss Their SLA: A Performance Triage Scenario•5 minutes
- Interpreting OAS Query Logs and Configuring Aggregate Persistence: A Step-by-Step Walkthrough•5 minutes
2 assignments•Total 21 minutes
- Course-Level Graded Assessment: Secure and Tune OAS Models•15 minutes
- Knowledge Check: Evaluating Platform Performance Through Query Analysis and Optimization•6 minutes
Instructor
Explore more from Leadership and Management
- Status: PreviewC
Coursera
Course
- Status: Preview
Course
- Status: Free TrialC
Coursera
Course
- Status: Preview
Course
Why people choose Coursera for their career
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.