Oracle Analytics Server (OAS): Analytics Classic Course

Oracle Analytics Server (OAS): Analytics Classic Course, available at $44.99, has an average rating of 4.73, with 103 lectures, 1 quizzes, based on 11 reviews, and has 22 subscribers.

You will learn about Learn the basics of Oracle Analytics Server, including how to install and set it up Explore more advanced features like data modeling, creating RPDs, and building detailed reports and dashboards See how Oracle Analytics Server can be used in real-world situations to help your organization make better decisions based on data Work through exercises and labs to apply what you've learned and build your confidence Understand how to migrate between different environments using BAR files and follow best practices to ensure everything runs smoothly This course is ideal for individuals who are This course is ideal for anyone who wants to learn a straightforward and powerful Analytics tool It is particularly useful for This course is ideal for anyone who wants to learn a straightforward and powerful Analytics tool.

Enroll now: Oracle Analytics Server (OAS): Analytics Classic Course

Summary

Title: Oracle Analytics Server (OAS): Analytics Classic Course

Price: $44.99

Average Rating: 4.73

Number of Lectures: 103

Number of Quizzes: 1

Number of Published Lectures: 103

Number of Published Quizzes: 1

Number of Curriculum Items: 104

Number of Published Curriculum Objects: 104

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

Learn the basics of Oracle Analytics Server, including how to install and set it up
Explore more advanced features like data modeling, creating RPDs, and building detailed reports and dashboards
See how Oracle Analytics Server can be used in real-world situations to help your organization make better decisions based on data
Work through exercises and labs to apply what you've learned and build your confidence
Understand how to migrate between different environments using BAR files and follow best practices to ensure everything runs smoothly

Who Should Attend

This course is ideal for anyone who wants to learn a straightforward and powerful Analytics tool

Target Audiences

This course is ideal for anyone who wants to learn a straightforward and powerful Analytics tool

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

Course Curriculum

Chapter 1: Introduction to Oracle Analytics Server

Lecture 1: Introduction and Course Topics

Chapter 2: Complete Steps to Install and Configure Oracle Analytics Server OAS 6.4

Lecture 1: Installation Note

Lecture 2: Installation of a supported Java Development

Lecture 3: Set JAVA_HOME Environment Parameter

Lecture 4: Installation of Fusion Middleware Infrastructure

Lecture 5: Installation of the OAS binaries

Lecture 6: RCU (Repository Creation Utility)

Lecture 7: Configuration of OAS into Weblogic Domain

Lecture 8: Installing Oracle BI Administration Tool and open RPD on online and offline mode

Chapter 3: Preparing the Data Model: Database Tables

Lecture 1: Creating Users and Tables

Lecture 2: Exploring the Data Model

Chapter 4: Creating Oracle BI Repository (RPD)

Lecture 1: Oracle BI Repository RPD online and offline mode

Lecture 2: Creating New Database and Connection Pool

Lecture 3: Create A New Business Model and Mapping

Lecture 4: Merge detailed dimensions into a single dimension

Lecture 5: Create Alias in Physical Layer

Lecture 6: How to create Measures

Lecture 7: Rename Measures Dimensions and logical names

Lecture 8: Merge detailed dimensions into a single dimension

Lecture 9: Upload RPD if you work in offline mode

Lecture 10: Level based Hierarchy

Lecture 11: How to create Logical Dimension Time Hierarchy

Lecture 12: Resolve the sorting issue with the Month names

Lecture 13: Skipped and Ragged Hierarchies

Chapter 5: Analysis Overview

Lecture 1: Logging Into Oracle Analytics Server Products

Lecture 2: Login to Oracle Analytics

Lecture 3: Oracle Analytics Administration

Lecture 4: Create An analysis steps

Lecture 5: Description of the Create Analysis Sections

Chapter 6: Views or Graphs

Lecture 1: Title and Table

Lecture 2: Pivot Table

Lecture 3: Pie Chart

Lecture 4: Bar Chart

Lecture 5: Bar Chart Horizontal

Lecture 6: Bar Chart Stacked

Lecture 7: Area Chart

Lecture 8: Line Chart

Lecture 9: Line-Bar

Lecture 10: Performance Tile

Lecture 11: Tree Map

Lecture 12: Heat Matrix

Lecture 13: View Selectors

Lecture 14: Selection Steps

Lecture 15: Gauge

Lecture 16: Narrative

Lecture 17: Combine Results

Chapter 7: Analytics Tips

Lecture 1: Create analyses that combine subject areas using common dimensions

Lecture 2: Show Percentage of Row or Column in Pivot Table

Lecture 3: Internal Filter

Lecture 4: Master Detail Linking

Lecture 5: Sequence Number

Lecture 6: Case Statement in Column Formula

Lecture 7: Case Statement in Oracle Administration

Lecture 8: TimeStampDiff Function

Lecture 9: Creating a Hierarchy for Country

Lecture 10: Modify Data Types of Columns in the RPD Physical Layer

Lecture 11: Creating Performance Tiles by using Internal filter

Chapter 8: Dashboards Managing Objects

Lecture 1: Dashboards in Oracle Analytics

Lecture 2: Creation Finance Dashboard and Adding Content to Dashboard Pages

Lecture 3: Creation Internet Sales Dashboard and Adding Content to Dashboard Pages

Lecture 4: Inline and Dashboard Prompts

Lecture 5: How to Remove NULL from RPD Showing in Dashboard Prompts

Lecture 6: Creating Inline Filters

Lecture 7: The Scope of a Dashboard Prompt

Lecture 8: Create a Dashboard Prompt Using a SQL Statement

Lecture 9: Create a Dashboard Prompt

Lecture 10: Save the inline filter as a named filter

Lecture 11: Creating Named Filters

Lecture 12: Divide the Analysis into Two Separate Analyses

Lecture 13: Rreport Links Levels

Lecture 14: Create Home page and Landing pages

Lecture 15: Format with HTML Tags

Chapter 9: Advanced Topics

Lecture 1: Managing Security for OAS – Creating Users and Groups

Lecture 2: Managing Security for OAS – Creating Application Roles

Lecture 3: Managing Security for OAS – Report and Dashboard Access

Lecture 4: Managing Security for OAS – Assign users to Roles or Dashboard directly without

Lecture 5: Practical example for Users and Groups and Application Roles

Lecture 6: Protect filter and Convert the filter to SQL statements

Lecture 7: Analysis XML and Subject Area

Lecture 8: Configure the Oracle Analytics Server Logout URL to Redirect Back To Oracle Anal

Lecture 9: Presentation Variables – Column Prompt

Lecture 10: Presentation Variables – Variable Prompt

Lecture 11: Named Conditions and Inline Conditions

Chapter 10: Portal Path and Row Level Security

Lecture 1: Dynamic Portal Path or Home page

Lecture 2: Row-Level Security

Chapter 11: Oracle Analytics Server Migrations Between Different Environments

Lecture 1: Migrations Between Different Environments Using BAR Files

Lecture 2: Export and Import Security data

Lecture 3: Import Application Roles Only

Lecture 4: Migrate Content to Other Catalogs

Instructors

Mohammed Abdelkarim
Business Intelligence Team Lead

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 5 votes
5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu