Oracle Analytics Server (OAS): Analytics Classic Course

If you are looking for a simple Analytics tool to present your data then come to the right place.

Learn how to make the most of Oracle Analytics Server with this easy-to-follow course, “Oracle Analytics Server: Analytics Classic.” Whether you’re new to Oracle or have some experience, this course will guide you through everything you need to know to use Oracle Analytics Server effectively.

In this course, you will:

• Get Started: Learn the basics of Oracle Analytics Server, including how to install and set it up.

• Go Deeper: Explore more advanced features like data modeling, creating RPDs, and building detailed reports and dashboards.

• Practical Skills: See how Oracle Analytics Server can be used in real-world situations to help your organization make better decisions based on data.

• Hands-On Practice: Work through exercises and labs to apply what you’ve learned and build your confidence.

• Smooth Transitions: Understand how to migrate between different environments using BAR files and follow best practices to ensure everything runs smoothly.

By the end of this course, you’ll have the skills you need to use Oracle Analytics Server in your day-to-day work, helping you to analyze data, create reports, and make informed decisions.

This course is perfect whether you’re looking to learn from scratch or want to build on what you already know. Join today and start your journey to becoming an Oracle Analytics Server professional.

Training Agenda:

• Introduction to Oracle Analytics Classic

• Creating Users and Tables

• Exploring the Data Model

• Oracle BI Repository RPD online and offline mode

• Creating New Database and Connection Pool

• Create A New Business Model and Mapping

• Merge detailed dimensions into a single dimension

• Create Alias in Physical Layer

• How to create Measures

• Rename Measures Dimensions and logical names

• Merge detailed dimensions into a single dimension

• Upload RPD if you work in offline mode

• Level based Hierarchy

• How to create Logical Dimension Time Hierarchy

• Resolve the sorting issue with the Month names

• Skipped and Ragged Hierarchies

• Login to Oracle Analytics

• Oracle Analytics Administration

• Create An analysis steps

• Description of the Create Analysis Sections

• Title and Table

• Pivot Table

• Pie Chart

• Bar Chart

• Bar Chart Horizontal

• Bar Chart Stacked

• Area Chart

• Line Chart

• Line-Bar

• Performance Tile

• Tree Map

• Heat Matrix

• View Selectors

• Selection Steps

• Gauge

• Narrative

• Combine Results

• Create analyses that combine subject areas using common dimensions

• Show Percentage of Row or Column in Pivot Table

• Internal Filter

• Master Detail Linking

• Sequence Number

• Case Statement in Column Formula

• Case Statement in Oracle Administration

• TimeStampDiff Function

• Creating a Hierarchy for Country

• Modify Data Types of Columns in the RPD Physical Layer

• Creating Performance Tiles by using Internal filter

• Dashboards in Oracle Analytics

• Creation Finance Dashboard and Adding Content to Dashboard Pages

• Creation Internet Sales Dashboard and Adding Content to Dashboard Pages

• Inline and Dashboard Prompts

• How to Remove NULL from RPD Showing in Dashboard Prompts

• Creating Inline Filters

• The Scope of a Dashboard Prompt

• Create a Dashboard Prompt Using a SQL Statement

• Create a Dashboard Prompt

• Save the inline filter as a named filter

• Creating Named Filters

• Divide the Analysis into Two Separate Analyses

• Report Links Levels

• Create Home page and Landing pages

• Format with HTML Tags

• Managing Security for OAS – Creating Users and Groups

• Managing Security for OAS – Creating Application Roles

• Managing Security for OAS – Report and Dashboard Access

• Managing Security for OAS – Assign users to Roles or Dashboard directly without Group

• Practical example for Users and Groups and Application Roles

• Protect filter and Convert the filter to SQL statements

• Analysis XML and Subject Area

• Configure the Oracle Analytics Server Logout URL to Redirect Back To Oracle Analytics URL

• Presentation Variables  Column Prompt

• Variable Prompt

• Named Conditions and Inline Conditions

• Dynamic Portal Path or Home page

• Row-Level Security

• Server Migrations

• Advanced Topics