Follow Us:

OBIEE Training in Chennai


Course Duration

40 Hours
Sign in with Facebook Sign in with Facebook

About OBIEE

  • OBIEE Stands for Oracle Business Intelligence Enterprise Edition.
  • Business Intelligence is a application of retaining , analyzing , assembling and providing access to data to help enterprise uses make better business decision.
  • It is a tool used for querying the analysis, and developing the reports for decision support system.
  • Course Contents

    OBIEE
      Repository Basics
    • - Exploring Oracle BI architecture components
    • - Exploring a repository’s structure, features, and functions
    • - Using the Oracle BI Administration Tool
    • - Creating a repository
    • - Loading a repository into Oracle BI Server memory
    •   Building the Physical Layer of a Repository
    • - Importing data sources
    • - Setting up connection pool properties
    • - Defining keys and joins
    • - Examining physical layer object properties
    • - Creating alias tables
    • Building the Business Model and Mapping Layer of a Repository
    • - Building a business model
    • - 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 objects
    • - Creating Presentation layer objects
    • - Modifying Presentation layer objects
    • - Examining Presentation layer object properties
    • Testing and Validating a Repository
    • - Checking repository consistency
    • - Turning on logging
    • - Defining a repository in the initialization file
    • - Executing analyses to test a repository
    • - Inspecting the query log
    • Managing Logical Table Sources
    • - Adding multiple logical table sources to a logical table
    • - Specifying logical content
    • Adding Calculations to a Fact
    • - 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 measures using functions
    • Working with Logical Dimensions
    • - Creating logical dimension hierarchies
    • - Creating level-based measures
    • - Creating share measures
    • - Creating dimension-specific aggregation rules
    • - Creating presentation hierarchies
    • - Creating parent-child hierarchies
    • - Using calculated members
    • Using Aggregates
    • - Modeling aggregate tables to improve query performance
    • - Setting the number of elements in a hierarchy
    • - Testing aggregate navigation
    • - Using the Aggregate Persistence Wizard
    • Using Repository Variables
    • - Creating session variables
    • - Creating repository variables
    • - Creating initialization blocks
    • - Using the Variable Manager
    • - Using dynamic repository variables as filters
    • Modeling Time Series Data
    • - Using time comparisons in business analysis
    • - Using Oracle BI time series functions to model time series data
    • Setting an Implicit Fact Column
    • - Adding fact columns automatically to dimension-only queries
    • - Ensuring the expected results for dimension-only queries
    • - Selecting a predetermined fact table source
    • - Specifying a default join path between dimension tables
    • Security
    • - Exploring Oracle BI default security settings
    • - Creating users and groups
    • - Creating application roles
    • - Setting up object permissions
    • - Setting row-level security (data filters)
    • - Setting query limits and timing restrictions
    • Cache Management
    • - Restricting tables as non-cacheable
    • - Using Cache Manager
    • - Inspecting cache reports
    • - Purging cache entries
    • - Modifying cache parameters and options
    • - Seeding the cache
    • Enabling Usage Tracking
    • - Setting up the sample usage tracking repository
    • - 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
    • Multiuser Development
    • - Setting up a multiuser development environment
    • - Developing a repository using multiple developers
    • - Tracking development project history
    • Working with Oracle Business Intelligence Analyses
    • - Introduction to Oracle BI Analysis Editor
    • - Oracle BI column types
    • - Working with analyses in Oracle BI
    • - Using advanced formatting
    • Administering the Presentation Catalog
    • - Oracle BI and catalog security overview
    • - Managing security using roles
    • - Understanding security inheritance
    • - Setting object permissions
    • - Setting system privileges
    • - Archiving catalog items
    • Limiting and Grouping Data in Analyses
    • - Introduction to filters and selections
    • - Creating, editing, and grouping filters
    • - Adding prompts to analyses
    • - Dynamic filtering
    • - Using saved analyses as filters
    • - Creating groups
    • - Creating calculated items
    • - Creating selection steps
    • Oracle Business Intelligence Analyses: Advanced Features
    • - Setting analysis properties
    • - Combining analysis criteria by using set operations
    • - Executing direct database analyses
    • - Editing logical SQL generated by an analysis
    • - Creating a link to a saved analysis
    • - Creating an Excel Web Query file
    • Working with Views and Graphs in Analyses
    • - Introduction to views, graphs, and editors
    • - Working with views in Compound Layouts
    • - Creating and editing graphs
    • - Linking master-detail views
    • - Performing common view tasks
    • Showing Results With Pivot Tables
    • - Creating, arranging, and formatting a pivot table
    • - Using hierarchical columns
    • - Sorting in pivot tables
    • - Setting aggregation and using totals
    • - Showing an item’s relative value
    • - Building calculations and displaying running sums
    • Creating Oracle Business Intelligence Dashboards
    • - Creating and editing dashboards
    • - Using the Dashboard Builder
    • - Exploring dashboard object properties and options
    • - Publishing dashboard pages
    • - Creating personal customizations and using other page options
    • Configuring Oracle Business Intelligence Dashboards
    • - Exploring types of dashboard content
    • - Embedding content in dashboards
    • Creating Dashboard Prompts and Variables
    • - Understanding variables
    • - Adding a named dashboard prompt to a dashboard
    • - Adding a hidden named dashboard prompt to a dashboard
    • - Creating additional prompt page and setting page preferences
    • - Adding variable prompts to a dashboard
    • Using Oracle Business Intelligence Delivers
    • - Configuring delivery devices and adding delivery profiles
    • - Adding an Alert Section to a dashboard
    • - Configuring an Agent
    • - Using Analysis and KPI conditions to deliver content with Agents
    • - Subscribing to an Agent
    Register Now

    You will Learn How To :


    Course Benefits :

    Register Now

    Please use the form below to make your career excellent.