About this course:

This Oracle BI 12c: Build Repositories course is designed to enable the candidates to develop and validate the 3 layers of an Oracle BI repository. The professional trainers of Oracle University will teach you the techniques and methods to use the Oracle Business Intelligence Administration Tool to develop a simple repository.

Learn To:

· How to design and develop logical business models.

· How to build the repository.

· Develop logical and physical joins, calculation measures, and simple measures.

· Utilize the query log to validate query results.

· Administrate the Oracle Business Intelligence Server cache.

· Import schemas.

· Show business models to users in the Oracle Business Intelligence user interface.

· Establish multiple user development environments.

· Create and run analyses by validating your work.

· Deployment of Oracle Business Intelligence Server security.

Benefits to You

By appearing in this course you will get the knowledge and understanding of initial repository too complex business model requirements, like: multiple logical table sources, logical dimension hierarchies, time-series data, partitions, and aggregate tables. This course also helps you to enhance your expertise and ability to use Administration Tool wizards and utilities to enhance, maintain, and manage repositories. Additionally, you will also learn to more advanced topics, including patch merge, bridge tables, implicit fact columns, managing service instances, and usage tracking.

Course Objective:

· Establish security to verify users and allocate appropriate privileges and permissions

· Establish multiple user development environments

· Model fragments and partitions to enhance application usability and performance

· Allow usage tracking to monitor database usage and queries and enhance query efficiency

· Utilize variables to modify metadata content dynamically and streamline administrative tasks

· Execute a patch merge in development to a production scenario

· Assist historical time comparison analyses by utilizing time series functions

· Develop and run analyses to validate and test a repository

· Build level-based measures and logical dimension hierarchies

· Enhance and maintain query performance by applying cache management techniques

· Use BAR files to shift Oracle BI between environments

· Establish query logging for debugging and testing

· Develop calculated and simple measures for a fact table

· Enhance, manage, control, and maintain repositories by using the Administration Tool wizards and utilities

· Review the model and aggregate tables increase the speed of query processing

· Develop the Presentation layers of a repository, and Business Model and Mapping 

Audience:

· Application Developers

· BI Developer

· Data Warehouse Administrator and Developer

· Data Modelers

· Technical Consultant

· Business Analysts

· Reports Developer

Prerequisite:

· This course required no prerequisites to appear in this course.