Oracle Analytics Cloud Corporate Training | Oracle Analytics Repository Corporate Training Agenda

Oracle Analytics Repository corporate training agenda

The Metadata Repository (RPD) course provides insightful and practical data modeling training and equips learners with techniques and best practices to connect to source data and create a semantic model for use with Oracle Analytics. The course goes on to discuss the various options for deploying the RPD and how to manage the RPD in a multi-user environment. It is suitable for both professionals with no / basic understanding of OAC, and technical users with a good understanding / experience with OAC.

Speak with our Oracle Analytics training experts ->

The Oracle Analytics Metadata Repository (RPD) course provides insightful and practical data modeling training and equips learners with techniques and best practices to connect to source data and create a semantic model for use with Oracle Analytics.

Pythian has been an Oracle premier partner for decades

Pythian has cultivated a relationship with Oracle built on deep technical excellence and a commitment to customer success, establishing ourselves as a premier partner in the Oracle ecosystem. Our proven history working with the world's most complex Oracle environments, backed by a team of industry-leading Oracle ACEs, guarantees that your Oracle applications and data systems deliver maximum value and performance.

How is our Oracle Analytics Repository corporate training delivered?

The course will be divided into lessons and labs. During lessons, the instructor will present a series of slides to explain the topic. During labs, delegates will be provided with exercises going over the functionality the instructor has just covered in the lessons. The delegates will be asked to complete the labs in the allocated time. The instructor will be available to answer any questions and provide assistance. Each delegate will be provided with a live Oracle Analytics instance to complete the labs.

Day 1

Introduction
- What is the Metadata Repository?
- Overview of features and key
  processes
- Customer scenario
  - What are we building?
  - Why are we building it?
Metadata Repository basics
- Physical layer
  - Import metadata
  - Aliases
  - Physical joins
- Business model and mapping layer
  - Business models
  - Logical tables and columns
  - Logical table sources
  - Logical joins
  - Physical vs. logical calculations
  - Level-based hierarchies
- Presentation layer
  - Subject areas
  - Presentation columns
Advanced features
- Ragged and skip-level hierarchies
- Parent-child hierarchies
- Horizontal and vertical federation

Day 2

Metadata Repository variables
- Repository vs. session variables
- Initialization blocks
- Row-level security
Modeling transactional (3NF) data
sources
- Repository vs. session variables
- Initialization blocks
- Row-level security
Software development lifecycle
- Online vs. offline development
- Merging and patching Metadata
  Repositories
- Multi-user development
- Version control and release
  management
Lab session
- Creating a basic repository
- Creating an advanced repository
- Server variables
- Modeling over 3NF sources
- Repository merging and patching

What We Do

Oracle Analytics Repository corporate training agenda

Pythian has been an Oracle premier partner for decades

How is our Oracle Analytics Repository corporate training delivered?

Day 1

Day 2

Empower your business with Oracle Analytics Cloud training and get more from Oracle investments