Oracle OBIEE
Course Features
Course Details
Introduction to DWH concepts
OLTP Vs OLAP
Data warehouse Architecture
Data warehouse Vs Data Mart
ETL
Masures, Fact, Dimensions
Schema
Star Schema and Snowflake Schema
Dimension Hierarchy
Aggregates
Aggregation Strategy, Compression Ratio
Indexing Strategy
Slowly Changing Dimension
Type 1
Type 2
Type 3
Performance Tuning
Oracle Business Intelligence – Repository
Repository Basics
Oracle BI architecture components
Repository structure, features, and functions
Using the OracleBI 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 and select 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
Testing a repository using Oracle BI Answers
Inspecting the query log
Adding Multiple Logical Table Sources
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 Dimension Hierarchies and Level-Based Measures
Creating dimension hierarchies
Creating level-based measures
Using Aggregates
Purpose of aggregate tables in dimensional modeling
Modeling aggregate tables to improve query performance
Testing aggregate navigation
Using Partitions and Fragments
Purpose for segmenting data into partitions and fragments
Modeling Time Series Data
Using time comparisons in business analysis
Using Oracle BI time series functions to model time series data
Creating Repositories Using Multidimensional Data Sources
Adding a multidimensional data source an Oracle BI repository
Displaying data from multidimensional sources in Oracle BI Answers requests and Oracle BI
Interactive Dashboards
Oracle Business Intelligence – Repository Part 2
Working with Oracle Business Intelligence Answers
Introduction to Oracle BI Answers
Working with requests in Oracle BI Answers
Using advanced formatting
Filtering Requests in Oracle Business Intelligence Answers
Introduction to filters in Answers
Adding filter prompts to requests
Using saved requests as filters
Oracle Business Intelligence Answers: Advanced Features
Combining request criteria using set operations
Executing direct database requests
Building Views and Charts in Requests
Introduction to Answers views and charts
Performing common view tasks
Showing Results with Gauge Views
Introduction to Gauge views
Working with Gauge views
Showing Results with Pivot Tables
Introduction to pivot tables
Formatting pivot tables
Setting aggregation rules and building formulas
Creating Oracle Business Intelligence Interactive Dashboards
Introduction to Interactive Dashboards and pages
Dashboard Editor UI elements
Composing dashboard elements
Configuring Oracle Business Intelligence Interactive Dashboards
Types of dashboard content
Embedding content in Interactive Dashboards
Using bookmark links to distribute and save Interactive Dashboards
Dynamic Filter in Dashboard
Using Prompts
Scope of the Prompt
Presentation Variable and Uses
Request Variable
Combine Request
Direct Database Request
Customizing the Oracle Business Intelligence User Interface
Making configuration changes using the instanceconfig file
Configuring Guided Navigation Links
Building guided navigation with static links
Building guided navigation with conditional links and sections
Administering the Oracle Business Intelligence Presentation Catalog
Maintaining the Oracle BI Presentation Catalog
Managing security
Understanding security inheritance
Describing the Presentation Catalog structure
Permission types
Setting permissions using the Manage Catalog screen
Using Oracle Business Intelligence Delivers
Introduction to Oracle BI Delivers
Configuring delivery devices
Adding delivery profiles
Building alerts
Introduction to Oracle BI Scheduler
Using BI Deliver
Configuration of Scheduler Service
Creating & scheduling iBots
Using Repository Variables
Session variables
Repository variables
Initialization blocks
Using the Variable Manager
Using dynamic repository variables as filters
Security
Creating users and groups
Setting permissions for users and groups
Authenticating using a external database
Authenticating using database authentication
Setting query limits and timing restrictions
Setting filters to personalize information
Cache Management
Restricting tables as non-cacheable
Using Cache Manager
Inspecting cache reports
Purging cache entries
Modifying cache parameters and options
Seeding the cache
OBIEE trainer Profile & Placement
More than 10 Years of experience in OBIEE® Technologies
Has worked on multiple realtime OBIEE projects
Working in a top MNC company in Bangalore
Trained 2000+ Students so far
Strong Theoretical & Practical Knowledge
certified Professionals
This course does not have any sections.