OBIEE course for Intermediate trainees by BoundTech Solutions

OLTP Vs OLAP
Data warehouse Architecture
Data warehouse Vs Data Mart
ETL
Measures, Fact, Dimensions
Schema
Star Schema
Snowflake Schema
Dimension Hierarchy
Slowly Changing Dimension
Type 1
Type 2
Type 3
Data Modelling
Fact Less fact table
Junk Dimension
Data Ware House Tools
Confirm Dimension

Oracle SQL

How to create schema s
How to Import Data (Sample)
How to Export Date (Sample
How to Grant Permissions
How to add new connections in Database
How to create tables and columns
Some Basic SQL Commands

ORACLE BUSINESS INTELLIGENCE REPOSITORY
Repository Basics
Oracle BI architecture components
Repository structure, features, and functions
Using the OracleBI Administration Tool
Creating a repository

Building the Physical Layer of a Repository
Importing data sources, Tables and Columns
Setting up connection pool properties
Defining keys and joins
Examining physical layer object properties
Creating alias and select tables
Loading a repository into Oracle BI Server memory

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
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
Using Aggregates

Creating Dimension Hierarchies and Level-Based Measures
Creating dimension hierarchies
Creating level-based measures
Modeling Time Series Data
Using time comparisons in business analysis

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

Use of Joins Like Complex Join, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.
Initialization Blocks and Variables.
Repository Utilities
calculation by using calculation wizard

All Types of Functions in BMM Layer
Rename and Re-Arrange Wizard

Building Views
Multiple use of Alias Table
Modelling Bridge Table

Cache Management
Implicit Fact Column
Creating Hierarchy in Presentation Layer
Event Pooling
Usage Tracking

About EM
About Console
Path Location
Log Files
Configuration Files

Oracle BI Answer Side (Catalog)
Catalog Manager Options
Migrations

Introduction to Oracle BI Answers
Working with requests in Oracle BI Answers
How to access Subject Areas
Basic Reporting

Formating
Filters
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

Types of View

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
Creating and editing 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
Types of dashboard content

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 instance config 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
Permission types - Object Level Security/Data Level Security
Setting permissions using the Manage Catalog screen
Creating users and groups
Setting permissions for users and groups
Setting query limits and timing restrictions

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 dynamic repository variables as filters

Setting filters to personalize information
Cache Management
Inspecting cache reports
Purging cache entries
Modifying cache parameters and options
Seeding the cache

Creating selection steps
Creating groups
Creating calculated items
Including advanced SQL clauses in your analysis

Providing Real Time Scenarios on RPD and Answer Side.
Interview Perspectives

We are also handle
SAS Base
SAS Advanced
SAS Clinical
SAS BI