Oracle Analytics Cloud and Analytics Server

The semantic model is the centre of this course. Visualisations are easy to produce and easy to redo; a badly designed logical layer produces wrong numbers that nobody notices for months. Delegates spend proportionally more time in the Semantic Modeler than anywhere else, building physical, logical and presentation layers against a case study warehouse.

Both interfaces are taught. Classic Answers and dashboards remain in heavy use across existing estates, while Data Visualization workbooks are where new development happens. A consultant who knows only one cannot support a real migration, since most organisations run both side by side for a considerable period.

Migration from OBIEE and Oracle Analytics Server runs as a thread through the course rather than sitting in a single module. Delegates work with RPD conversion, catalog migration and the practical differences that surface once content lands in the cloud.

Self-paced course

₹15,000

or start with ₹5,000 and pay the balance within 3 months

Pay in full ₹15,000

○ Lessons, videos and quizzes from ₹5,000
🔒 Lab recordings at ₹15,000
🔒 Certification exam at full payment
○ Optional real lab: ₹5,000 per month (after full payment)

Valid 12 months from your first payment. Refund policy

Responsible	XertApp
Last Update	10/28/2026
Completion Time	15 hours 56 minutes
Members	1

Career Courses Oracle Courses Data & Analytics

Module 1 — Platform overview and provisioning (empty)

12Lessons · 1 hr 35 min
- 1.1 Video: Oracle Analytics Cloud, Analytics Server and Fusion Analytics
  
  New
- 1.1 Oracle Analytics Cloud, Analytics Server and Fusion Analytics
  
  New
- 1.2 Video: Editions: Professional and Enterprise
  
  New
- 1.2 Editions: Professional and Enterprise
  
  New
- 1.3 Video: Provisioning an OAC instance
  
  New
- 1.3 Provisioning an OAC instance
  
  New
- 1.4 Video: Sizing, scaling and vanity URLs
  
  New
- 1.4 Sizing, scaling and vanity URLs
  
  New
- 1.5 Video: Installing Oracle Analytics Server
  
  New
- 1.5 Installing Oracle Analytics Server
  
  New
- 1.L Lab: Planning and provisioning an analytics instance
  
  Lab New
- Module 1 Quiz: Platform and Provisioning
  
  New 10 xp
Module 2 — Security and identity (empty)

12Lessons · 1 hr 31 min
- 2.1 Video: Identity domains and user provisioning
  
  New
- 2.1 Identity domains and user provisioning
  
  New
- 2.2 Video: Application roles
  
  New
- 2.2 Application roles
  
  New
- 2.3 Video: Custom application roles and privileges
  
  New
- 2.3 Custom application roles and privileges
  
  New
- 2.4 Video: Object-level and data-level security
  
  New
- 2.4 Object-level and data-level security
  
  New
- 2.5 Video: Row-level security in the semantic model
  
  New
- 2.5 Row-level security in the semantic model
  
  New
- 2.L Lab: Roles, permissions and row-level security
  
  Lab New
- Module 2 Quiz: Security and Identity
  
  New 10 xp
Module 3 — Data connectivity (empty)

12Lessons · 1 hr 31 min
- 3.1 Video: Connecting to Autonomous Database
  
  New
- 3.1 Connecting to Autonomous Database
  
  New
- 3.2 Video: Databases, files, REST and other sources
  
  New
- 3.2 Databases, files, REST and other sources
  
  New
- 3.3 Video: Remote Data Gateway for on-premises sources
  
  New
- 3.3 Remote Data Gateway for on-premises sources
  
  New
- 3.4 Video: Function shipping and query pushdown
  
  New
- 3.4 Function shipping and query pushdown
  
  New
- 3.5 Video: Connection pooling and credentials
  
  New
- 3.5 Connection pooling and credentials
  
  New
- 3.L Lab: Connecting cloud and on-premises sources
  
  Lab New
- Module 3 Quiz: Data Connectivity
  
  New 10 xp
Module 4 — Data modelling fundamentals (empty)

12Lessons · 1 hr 31 min
- 4.1 Video: Transactional versus analytical design
  
  New
- 4.1 Transactional versus analytical design
  
  New
- 4.2 Video: Facts, dimensions and grain
  
  New
- 4.2 Facts, dimensions and grain
  
  New
- 4.3 Video: Star and snowflake schemas
  
  New
- 4.3 Star and snowflake schemas
  
  New
- 4.4 Video: Hierarchies, levels and drill paths
  
  New
- 4.4 Hierarchies, levels and drill paths
  
  New
- 4.5 Video: Slowly changing dimensions
  
  New
- 4.5 Slowly changing dimensions
  
  New
- 4.L Lab: Designing a sales star schema
  
  Lab New
- Module 4 Quiz: Data Modelling
  
  New 10 xp
Module 5 — Semantic Modeler (empty)

12Lessons · 1 hr 31 min
- 5.1 Video: Physical, logical and presentation layers
  
  New
- 5.1 Physical, logical and presentation layers
  
  New
- 5.2 Video: Logical table sources and fragmentation
  
  New
- 5.2 Logical table sources and fragmentation
  
  New
- 5.3 Video: Aggregation rules and calculated measures
  
  New
- 5.3 Aggregation rules and calculated measures
  
  New
- 5.4 Video: Time series functions
  
  New
- 5.4 Time series functions
  
  New
- 5.5 Video: Validation, version control and deployment
  
  New
- 5.5 Validation, version control and deployment
  
  New
- 5.L Lab: Building the sales semantic model
  
  Lab New
- Module 5 Quiz: Semantic Modeler
  
  New 10 xp
Module 6 — Data preparation and visualisation (empty)

12Lessons · 1 hr 31 min
- 6.1 Video: Datasets and data profiling
  
  New
- 6.1 Datasets and data profiling
  
  New
- 6.2 Video: Data flows and scheduling
  
  New
- 6.2 Data flows and scheduling
  
  New
- 6.3 Video: Workbooks and visualisation types
  
  New
- 6.3 Workbooks and visualisation types
  
  New
- 6.4 Video: Filters, parameters, actions and maps
  
  New
- 6.4 Filters, parameters, actions and maps
  
  New
- 6.5 Video: Auto Insights, storyboards and sharing
  
  New
- 6.5 Auto Insights, storyboards and sharing
  
  New
- 6.L Lab: Preparing data and building a workbook
  
  Lab New
- Module 6 Quiz: Data Preparation and Visualisation
  
  New 10 xp
Module 7 — Classic analyses, dashboards and BI Publisher (empty)

12Lessons · 1 hr 31 min
- 7.1 Video: Analyses and views
  
  New
- 7.1 Analyses and views
  
  New
- 7.2 Video: Dashboards and prompts
  
  New
- 7.2 Dashboards and prompts
  
  New
- 7.3 Video: Catalog, permissions and agents
  
  New
- 7.3 Catalog, permissions and agents
  
  New
- 7.4 Video: BI Publisher data models and layouts
  
  New
- 7.4 BI Publisher data models and layouts
  
  New
- 7.5 Video: Choosing the right content type
  
  New
- 7.5 Choosing the right content type
  
  New
- 7.L Lab: A dashboard, an agent and a statement
  
  Lab New
- Module 7 Quiz: Classic Reporting and BI Publisher
  
  New 10 xp
Module 8 — Advanced analytics and machine learning (empty)

12Lessons · 1 hr 31 min
- 8.1 Video: Expressions and advanced calculations
  
  New
- 8.1 Expressions and advanced calculations
  
  New
- 8.2 Video: Trend, forecast, cluster and outlier
  
  New
- 8.2 Trend, forecast, cluster and outlier
  
  New
- 8.3 Video: Training and applying ML models
  
  New
- 8.3 Training and applying ML models
  
  New
- 8.4 Video: Explain, language AI and augmented analytics
  
  New
- 8.4 Explain, language AI and augmented analytics
  
  New
- 8.5 Video: Embedding analytics in applications
  
  New
- 8.5 Embedding analytics in applications
  
  New
- 8.L Lab: Forecasting, churn prediction and Explain
  
  Lab New
- Module 8 Quiz: Advanced Analytics
  
  New 10 xp
Module 9 — Migration from OBIEE and OAS (empty)

12Lessons · 1 hr 31 min
- 9.1 Video: Assessing an OBIEE estate
  
  New
- 9.1 Assessing an OBIEE estate
  
  New
- 9.2 Video: Repository and model migration
  
  New
- 9.2 Repository and model migration
  
  New
- 9.3 Video: Catalog migration and validation
  
  New
- 9.3 Catalog migration and validation
  
  New
- 9.4 Video: Choosing OAS or OAC and running in parallel
  
  New
- 9.4 Choosing OAS or OAC and running in parallel
  
  New
- 9.5 Video: What does not migrate cleanly
  
  New
- 9.5 What does not migrate cleanly
  
  New
- 9.L Lab: Migrating an OBIEE estate
  
  Lab New
- Module 9 Quiz: Migration
  
  New 10 xp
Module 10 — Performance, operations and exam readiness (empty)

12Lessons · 1 hr 31 min
- 10.1 Video: Query performance and caching
  
  New
- 10.1 Query performance and caching
  
  New
- 10.2 Video: Aggregate awareness and summary tables
  
  New
- 10.2 Aggregate awareness and summary tables
  
  New
- 10.3 Video: Logs, diagnostics and usage tracking
  
  New
- 10.3 Logs, diagnostics and usage tracking
  
  New
- 10.4 Video: Snapshots, backup and lifecycle
  
  New
- 10.4 Snapshots, backup and lifecycle
  
  New
- 10.5 Video: Preparing for the analytics exam
  
  New
- 10.5 Preparing for the analytics exam
  
  New
- 10.L Lab: Cache, usage tracking and exam practice
  
  Lab New
- Module 10 Quiz: Performance and Operations
  
  New 10 xp
Final Certification (empty)

1Lessons · 40 min
- Certification Exam: Oracle Analytics Cloud and Analytics Server
  
  New

Who should attend

Aimed at practitioners building or migrating analytics platforms on Oracle technology.

OBIEE developers and administrators facing a replacement decision
BI developers moving to Oracle Analytics Cloud
Data analysts and report writers taking on modelling responsibility
Data warehouse teams building semantic layers
Fusion Cloud consultants extending into analytics
Architects scoping an analytics migration

Assumed knowledge: competent SQL and familiarity with relational database concepts. Prior OBIEE or data warehousing experience is helpful but not required. No programming background is needed, though comfort with expressions and formulas assists the modelling modules.

Delivery

Duration
40 hours, delivered as weekday evenings or weekend sessions.

Format
Live instructor-led online, with recordings available to delegates for the duration of the programme. On-site corporate delivery available on request.

Lab environment
Each delegate receives a dedicated Oracle Analytics Cloud instance for the duration of the course and for four weeks afterwards.

Included
Course notes, lab guides, exercise solutions and a certificate of completion.

How to enroll

Enrol and pay online on this page. The full fee is ₹15,000 (US$170). You can start with ₹5,000 (US$60) and pay the balance in instalments within 3 months. Pay by card, UPI or net banking, or by PayPal in US dollars. Go to payment. For corporate, on-site or one-to-one training, contact contact@appsolworld.com or call +91 92051 38405.