What you'll 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
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
