OBIEE Class Room / Online Training From Elegant IT Service.

OBIEE Class Room / Online Training From Elegant IT Service.

Introduction & Environment setup
• Data warehouse fundamentals.
• Installation of OBIEE software
• Setup and configure the OBIEE server components.
• Installing Custom Database and import data to be used.
• Siebel Analytics, OBIEE and BI Server Architecture.
Oracle Business Intelligence Enterprise Edition: Overview
• Define and describe business analytics and business intelligence
• Identify the analytical business challenge and the solution provided by Oracle BI products
• Define and describe data warehousing and data modeling
• Identify and describe the Oracle BI Enterprise Edition products used to support BI requirements
• Oracle BI Enterprise Edition Architecture
• Identify the major components that make up the Oracle BI Enterprise Edition architecture
• Describe the role of key components in the architecture
• Describe the relationships among the componentsOBIEE 10G AND 11G TRAIING CONTENT
Oracle BI Enterprise Edition Repository Basics
• Identify and describe the three layers of BI Repository and how they relate to one another
• Use the Oracle BI Administration Tool to explore repository objects
• Identify and describe repository features and functions
• Identify and describe repository features and functions
Metadata Data modeling for Repository
• Creating/enhancing the repository
• Repository structure, features, and functions Using the Oracle BI Administration Tool
• Loading a repository into Oracle BI Server memory
• Building the Physical Layer of a Repository
• Importing the relevant data sources
• Setting up connection pool properties
• Defining keys and joins
• Examining physical layer object properties
• Creating alias and select tables
• Building the Business Model and Mapping Layer of a Repository
• Building logical tables, columns, and sources
• Defining logical joins
• Building measures
• Examining business model object properties
• Building the Presentation Layer of a Repository
• Exploring Presentation layer objectsOBIEE 10G AND 11G TRAIING CONTENT
• Creating Presentation layer objects
• Modifying Presentation layer objects
• Examining Presentation layer object properties
• Testing and Validating a Repository
• Checking repository consistency
• Testing a repository using Oracle BI Answers
• Setting and inspecting the query logs
• Adding multiple logical table sources to a logical table
• Specifying logical content
• Adding Calculations to a Fact Table
• Creating new calculation measures based on existing logical columns
• Creating new calculation measures based on physical columns
• Creating new calculation measures using the Calculation Wizard
• Creating Dimension Hierarchies and Level-Based Measures
• Creating Rank and share measures
• Purpose of aggregate tables in dimensional modeling
• Modeling aggregate tables to improve query performance
• Using the Aggregate Persistence Wizard
• Using Partitions and Fragments, purpose for segmenting data into partitions and fragments
• Partition types and modeling partitions in an Oracle BI repository
• Types of variables and modeling different types of variables.
• Creating Repositories Using Multidimensional Data Sources
• Adding a multidimensional data source an Oracle BI repositoryOBIEE 10G AND 11G TRAIING CONTENT
• Displaying data from multidimensional sources in Oracle BI Answers requests and Oracle BI
Interactive Dashboards
• Security in creating users and groups
• Setting permissions for users and groups
• Cache Management,restricting tables as non-cacheable
• Inspecting cache reports
• Purging stale cache entries
• Seeding the cache
• Setting Up and Administering Usage Tracking
• Tracking and storing Oracle BI Server usage at the detailed query level
• Using usage tracking statistics to optimize query performance and aggregation strategies
• Analyzing usage results using Oracle BI Answers and other reporting tools
• Setting up a multi-user development environment
• Developing a repository using multiple developers
• Tracking development project history
• Techniques to optimize Oracle BI query performance
• Applying Oracle BI repository design principles
OBIEE Catalog manager
• Administering Oracle Business Intelligence Presentation Catalog
• Different modes in maintaining the OracleBI Presentation Catalog
• Maintaining security
• Understanding security inheritance
• Moving catalogs from one Environment to other.OBIEE 10G AND 11G TRAIING CONTENT
OBIEE Application Developer
Reporting Overview
• Configuring different types of tabular and graphical Reports
• Assigning Fonts and colors to Reports
• Using Calculations and variables for reports creations
• Configuring trend Analysis, Bucketing Reports
• Using presentation variables for the report creations
• Types of Filters, Configuring different types of filters
• Dashboard building and different types of dashboard objects
• Usage of Guided navigations, different types of Guided navigations
• Types of Prompts, different approaches in creating the prompts
• Integrating with Siebel Apps(Inline and Iframe )
• Best Practices for creating of Reports
• Setting Privilages,giving Authorizations and Permissions
• Delivers, Creation of Ibots and Types
• Scheduling the Reports
BI Publisher

Thanks&Regards
Elegant IT Services,
#352, 2nd Floor,Aswath Nagar
Varthur main road,Near Railway Fly Over
Maratha halli,Land mark : Chemmunar Jewellers,
Bangalore - 560037.Ph:-9886541264/87