Oracle Analytics Server (OAS): Classic Analytics Essentials

Lesson 1 • Navigating the OAS Interface

Introduces the Classic Home page, catalogue, and global header. Students gain confidence moving between key interface areas used throughout the course.

Lesson 2 • OAS Platform Overview and Architecture

Covers OAS components, tiers, and deployment topology. Grounds students in how the platform is structured before any hands-on configuration.

Lesson 3 • Data Sources and Connectivity Basics

Explains how OAS connects to relational, OLAP, and file-based sources. Establishes the data connectivity concepts required for later subject area work.

Lesson 1 • Applying Filters and Prompts

Covers inline filters, saved filters, and column prompts to control data scope. Students learn to make analyses dynamic and reusable.

Lesson 2 • Saving and Managing Analyses

Covers catalogue organisation, naming conventions, and sharing analyses. Prepares students to maintain a clean, collaborative content library.

Lesson 3 • Sorting, Aggregation, and Totals

Explains sort rules, aggregation overrides, and grand-total configuration. Ensures students can control how data is summarised and displayed.

Lesson 1 • Chart and Graph Configuration

Covers bar, line, pie, scatter, and combination charts with axis and legend controls. Students match chart types to data relationships and audience needs.

Lesson 2 • Title, Text, and Narrative Views

Explains how to add context with title, static text, and narrative views. Enables students to build self-explanatory, presentation-ready analyses.

Lesson 3 • Table and Pivot Table Views

Teaches tabular and cross-tab layouts, including row/column placement and formatting. Establishes the most common view types used in enterprise reporting.

Lesson 4 • Gauge, Funnel, and Map Views

Introduces specialised views for KPI monitoring and geographic analysis. Expands students' visualisation toolkit beyond standard charts.

Lesson 1 • Repository Variables in Formulas

Explains static, dynamic, and session variables and their use in column formulas. Students parameterise calculations for context-sensitive reporting.

Lesson 2 • Aggregation Functions and EVALUATE

Covers SUM, COUNT, RANK, PERCENTILE, and the EVALUATE passthrough function. Students extend OAS capabilities using native database functions.

Lesson 3 • Conditional Logic with CASE Statements

Covers searched and simple CASE expressions for classification and scoring. Enables students to encode business rules directly into analyses.

Lesson 4 • Date and Time Functions

Teaches TIMESTAMPADD, TIMESTAMPDIFF, and date-extraction functions. Students build time-aware metrics essential for trend and period analysis.

Lesson 1 • Column Visibility and Guided Navigation

Teaches conditional column display and guided navigation links tied to data values. Students build adaptive analyses that respond to context.

Lesson 2 • Selection Steps and Set Operations

Teaches selection steps for member-based filtering using keep, add, and remove operations. Enables precise dimensional slicing beyond standard column filters.

Lesson 3 • Conditional Formatting Rules

Explains threshold-based cell, row, and image formatting driven by measure values. Students configure visual alerts that surface exceptions without manual review.

Lesson 1 • Dashboard Prompts and Filters

Teaches dashboard-level prompts and how they interact with embedded analyses. Students create unified filter controls that drive multiple analyses simultaneously.

Lesson 2 • Dashboard Editor and Page Structure

Introduces the dashboard editor, page management, and column/section layout. Establishes the structural skills needed before adding content objects.

Lesson 3 • Dashboard Permissions and Publishing

Covers dashboard visibility, shared folder publishing, and permission assignment. Students deliver dashboards to the correct audience with appropriate access.

Lesson 4 • Navigation and Action Framework

Explains navigate actions, action links, and action link menus for guided analytics. Students build drill-through paths and contextual navigation flows.

Lesson 1 • Agent Content and Subscription Management

Teaches attaching analyses and reports to agents and managing user subscriptions. Students enable self-service alert subscription for end users.

Lesson 2 • Conditions and Threshold Monitoring

Covers condition objects that evaluate analysis results against defined thresholds. Students build data-driven triggers that fire agents only when business rules are met.

Lesson 3 • Agent Architecture and Scheduling

Introduces agent components, trigger types, and scheduling options. Establishes the operational model before students configure specific delivery scenarios.

Lesson 1 • Query Performance Diagnostics

Covers usage tracking, query logs, and execution plan analysis. Students identify slow queries and trace root causes before applying fixes.

Lesson 2 • Caching Strategies and Configuration

Explains the OAS query cache, seeding, and purging mechanisms. Students configure caching to reduce database load and improve response times.

Lesson 3 • System Maintenance and Monitoring

Covers Fusion Middleware Control, service restart procedures, and log management. Students maintain OAS availability and respond to operational issues.