The Oracle Business Intelligence Enterprise Edition Implementation Boot Camp is a five-day class to educate and make participants aware of the Oracle BI EE suite of enterprise BI products and the skills required for its implementation. The boot camp will be a combination of lecture and hands-on exercises, where the participants will gain valuable skills in Oracle BI EE technology and implementation best practices.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

There are no current offerings for this boot camp on our schedule. To express your interest in attending this boot camp, please register your request.

Audience

• Administrator
• Application Developers
• Business Analysts
• Business Intelligence Developer
• Data Warehouse Administrator

Course Topics

• Introduction to Oracle EPM Systems and BI Describing Oracle’s overall EPM System Defining Business Intelligence and business challenges Understanding how OBIEE addresses those challenges Describing the Oracle BI products Defining components of Oracle BI, used to support business intelligence requirements
• OBI EE Architecture Identifying major components of an Oracle BI architecture Describing the function of each component Understanding the relationships among components
• Oracle BI Installation Basic installation architecture System requirements and supported platforms Installation pre-requisites Database connectivity/clients Installing Oracle BI Server Installing Oracle BI Presentation Server Installing Oracle BI Scheduler Verifying installation
• BI EE User Interface Understanding various components of Oracle BI user interface Understanding Oracle BI Answers, Dashboards and Delivers Using Oracle Answers to construct, modify, and save BI requests Navigating a Oracle BI Intelligence Dashboard
• Dashboards and Answers Development Creating an Intelligence Dashboard Using Intelligence Dashboard UI objects to construct an Intelligence Dashboard Configuring delivery devices Adding delivery profiles Building Analytics alerts Creating iBots Configuring the Analytics Scheduler
• Introduction to Dimensional Modeling Understanding various types of data structures Defining Data Warehouse Understanding the need of Data Warehouse
• Exploring Oracle BI Repository Exploring Oracle BI Metadata Objects Identifying the three layers of OBI Repository Exploring Administration Tool to view and modify the repository
• Building Basic Repository Identifying the objects in the Physical layer of a repository Defining a System Data Source Name (DSN) for a data source Building the Physical layer Identifying objects in the Logical layer in the repository Building the Logical layer of the Repository Identifying the objects in the Presentation layer of the repository Building the presentation layer of the repository
• Testing and Deploying Repository Describing techniques for testing a repository Executing steps to validate and test a repository
• Complex Repository Modeling Implementing new calculation measures Creating new calculation measures based on existing logical columns Creating new calculation measures based on physical columns
• Using Multiple Sources Describing the use of time comparisons for business analysis Implementing time comparison measures Identifying reasons for segmenting data Describing techniques to model partitions Implementing a value-based partition
• Hierarchies and Level Based Measures Creating a dimensional hierarchy Using level-based measures Creating a rank measure Understanding the need for Aggregate tables Configuring aggregate navigation in the OBI repository
• Using Variables Describing session variables Describing repository variables Describing initialization blocks Implementing a dynamic repository variable
• Using Non-Dimensional Data Prototype using a spreadsheet Modeling a non-dimensional data source
• Implementation Methodology and Best Practices Oracle BI project life cycle and implementation methodology Best Practices
• Oracle BI Security Defining authentication and authorization Describing the different levels at which security is enforced Configuring security using Security Manager Configuring query governing controls
• Cache Management Understanding the importance of cache in OBI Configuring caching Managing cache files Developing caching strategies
• Performance Tuning Understanding the request and data flow in Oracle BI Identifying critical points hindering performance Identifying performance bottlenecks Learn best practices for high performing BI
• MS Office Integration Understanding MS Office plug in for Oracle BI Identifying the required components to enable office integration Installing and configuring MS office server and client for Oracle BI
• Case Study A complete walk through of a real life Oracle BI implementation cycle Understanding of requirements analysis and solution design Experience on building the solution as per designed components Building Dashboards as per user requirements Deploying a dashboard for users

Prerequsites

• Foundational product knowledge of Oracle BI EE

Objectives

• Understand OBIEE implementation architecture design decisions
• Design and develop dashboard scenarios
• Design and develop reports
• Install Oracle BI EE
• Establish Connectivity between the BI Server and data sources of relational and non-relational types
• Define the Physical, Business and Presentation layers of for an OBIEE implementation
• Integrate OBIEE with MS Office