About this course:

This course is based upon OBI EE release 11.1.1.7. Professional trainers of Oracle University will provide you the knowledge and expertise to build and verify the 3 layers of an Oracle Business Intelligence repository. You will also learn how to use Oracle Business Intelligence Administration Tool to develop a simple repository to deal with the business requirements.

Learn To:

• Develop, maintain and manage an Oracle Business Intelligence repository by using the Oracle Business Intelligence Administration Tool.
• Create and perform analyses to verify and test a dimensional business model.
• Tackle business intelligence requirements by building a dimensional business model.
• Manage Oracle Business Intelligence Server by using the Oracle Business Intelligence Administration Tool.
•        
• Verify work by building and executing analyses and validating query outcomes by utilizing the query log.

Benefits to You

This course will help you to enhance your knowledge and skills to modify your business data into intelligence, this will enhance your day to day decision making. This new learning methodology will assist you to deliver relevant, accurate, and time-critical insights. Additionally, you have an ability that will support you to become more effective and efficient at developing repositories.

Build Logical Business Models

In this Oracle BI 11g R1: Build Repositories training you will also learn how to design and create logical business models, import schemas, and show business models to users in the Oracle Business Intelligence user interface. While developing the repository, you will understand how to build logical and physical joins, calculation measures, and simple measures.

Model Logical Dimension Hierarchies

Initially, you will learn how to build a simple repository and then you will get the knowledge to model more complex business needs. This incorporates multiple logical table sources, partitions, and time-series data, logical dimension hierarchies, and aggregate tables.

Implement Oracle BI Server Security

Oracle University trainers will also provide you an overview of implementing the Oracle Business Intelligence Server security and handling the Oracle Business Intelligence Server cache. You will study the techniques to establish multiple user development environments and utilization of Administration utilities and Tool wizards to handle, maintain and improve repositories.

Advanced Course Topics

In this course, you will study more advanced topics, such as bridge tables, multilingual environments, implicit fact columns, usage tracking, patch merge and write back. An appendix is incorporated, that covers design and the advantages of the Oracle Exalytics Business Intelligence Machine.

Course Objective:

• Build level-based measures and logical dimension hierarchies
• Support historical time comparison analyses by using time series functions
• Develop and perform analyses to validate and test a repository
• Develop the Business Model and Mapping, Physical, and Presentation layers of a repository
• Establish multiple user development environments
• Execute a patch merge in a different scenario
• Create calculated and simple measures for a fact table
• Utilize variables to transform metadata content dynamically and streamline management tasks
• Establish security to verify users and allocate appropriate privileges and permissions
• Enhance and maintain query performance by applying cache management techniques
• Review the model and its aggregate tables to improve query processing
• Establish query logging for debugging and testing
• Model fragments and partitions to enhance application usability and performance
• Explain the Summary Advisor and Exalytics machine tool used in the machine
• Enhance, maintain and manage repositories by using the Administration Tool utilities  
• Allow usage tracking to monitor database and queries usage and enhance query performance

Targeted Audience:

• Data Warehouse Analyst
• BI Developer
• Application Developers
• Data Modelers
• Business Analysts
• Technical Consultant
• Reports Developer
• Data Warehouse Administrator

Prerequisite:

• Understanding of Dimensional modeling
• Understanding of Basic SQL
• Understanding of Data warehouse design