Escal Global Solutions offers the best of the best in improving the skill sets of every individual with varying competencies through the very basics to the advanced scope of customization. The harmonious mix of theory from experts and hands on practice provides complete exposure from basics to advanced topics for all trainees who could be Jr. Developers, intermediate Developers or Advanced Developers. These courses are helpful in infusing knowledge with confidence among trainees thereby making them better professionals to establish strong career in today’s competitive Industry. Escal Global ensures one on one interaction with trainees. These courses can also be taken as live virtual classes with 24/7 lab facility.
OBIEE Trainer's Profile:
OBIEE Trainer's Profile:
OBIEE Trainer has more than 10 years of Experience in Business Intelligence and Datawarehousing. He has been training in BI for beginners, experienced consultants and end clients. He has worked in various industries like Finance, Sales, Service, Marketing, Procurement etc.. He is one of the few Consultants who worked in Siebel Analytics, OBIEE 10G and 11G.
DAY 1
Pre-Requisites & Introduction to OBIEE
Conventional OLTP vs OLAP
Why a warehouse
Introducing to Warehouse concepts -Current trends of Warehouse
Dimensions & Facts
Start Schemas vs Snow Flake Schemas
Aggregate table
Introduction to Data Modeling
Why OBIEE- OBIEE Overview
Advantage of Using OBIEE
OBIEE Architecture
Conventional OLTP vs OLAP
Why a warehouse
Introducing to Warehouse concepts -Current trends of Warehouse
Dimensions & Facts
Start Schemas vs Snow Flake Schemas
Aggregate table
Introduction to Data Modeling
Why OBIEE- OBIEE Overview
Advantage of Using OBIEE
OBIEE Architecture
DAY 2
Introduction to Repository
Introduction to BI Architecture
Walkthrough Repository Tool Basics
Working within Physical layer
Importing the Tables, Views
Connection Pools - Various Data Sources
Modeling the Physical Layer
PK-FK Relationship
Modeling Aliases and Opaque Views
Introduction to BMM Layer
Business Model Layer Objects
Building Business Model Layer
Testing and Validating a Repository
Q & A SESSION
Introduction to BI Architecture
Walkthrough Repository Tool Basics
Working within Physical layer
Importing the Tables, Views
Connection Pools - Various Data Sources
Modeling the Physical Layer
PK-FK Relationship
Modeling Aliases and Opaque Views
Introduction to BMM Layer
Business Model Layer Objects
Building Business Model Layer
Testing and Validating a Repository
Q & A SESSION
DAY 3
Adding Multiple sources to dimensions
Adding Logical Columns to Facts and Dimensions
Creating basic calculations to Facts
Creating Dimension Hierarchies
Understanding LEVEL BASED MEASURES
Creating Time Series Calculations
Creating Dimensions
Creating Presentation Models
Modeling Extension Tables
Modeling Aggregate tables
Cache Management
Basic Caching
Advanced Caching
Best Practices
Q&A Session
Adding Logical Columns to Facts and Dimensions
Creating basic calculations to Facts
Creating Dimension Hierarchies
Understanding LEVEL BASED MEASURES
Creating Time Series Calculations
Creating Dimensions
Creating Presentation Models
Modeling Extension Tables
Modeling Aggregate tables
Cache Management
Basic Caching
Advanced Caching
Best Practices
Q&A Session
DAY 4
BMM & Presentation Layer
Introduction to Aggregate Persistence wizard
Types of Variables
Configure Session variables (System/Non System)
Configure Repository Variables
Configure Static and Dynamic Variables
Add Multiple Sources to Dimension
Add Multiple Sources to Fact
Implicit Fact Implementation and Usages
Introductions to Filters
Expression Builders
Setting up LTS filters
DEMO, Q & A
Introduction to Aggregate Persistence wizard
Types of Variables
Configure Session variables (System/Non System)
Configure Repository Variables
Configure Static and Dynamic Variables
Add Multiple Sources to Dimension
Add Multiple Sources to Fact
Implicit Fact Implementation and Usages
Introductions to Filters
Expression Builders
Setting up LTS filters
DEMO, Q & A
DAY 5
Dashboards and Answers Overview
Creating Table Views
Creating Totals and Sub Totals
Filters & Prompts
Title Views and icons
Working with Compound View
Adding Charts
Adding Views Selectors
Adding Column Selectors
Formatting & Conditional Formatting
Navigation between reports
Adding Narrative View
Add Shared Filters and Saved Filters
Understanding Combined Requests
Working with No results Views
Creating Table Views
Creating Totals and Sub Totals
Filters & Prompts
Title Views and icons
Working with Compound View
Adding Charts
Adding Views Selectors
Adding Column Selectors
Formatting & Conditional Formatting
Navigation between reports
Adding Narrative View
Add Shared Filters and Saved Filters
Understanding Combined Requests
Working with No results Views
DAY 6
Advanced/Enriched UI in 11g
Oracle Answers & Interactive Dashboards
Working on ANSWERS and its FEATURESUsing Different Types of Prompts(Dashboard & Report)
Using Presentation Variables
Filters and Prompts in OBIEE Answers
Using Column Filters / Prompt Filters / Global Filters
Using Combined Filter/Group Filter/ Filter Based on other Request
Configuring Interactive Dashboards & Prompts
Configuring Guided Navigation Links
Interactive Dashboard Design Objects & Principles
Q & A
DEMO
Oracle Answers & Interactive Dashboards
Working on ANSWERS and its FEATURESUsing Different Types of Prompts(Dashboard & Report)
Using Presentation Variables
Filters and Prompts in OBIEE Answers
Using Column Filters / Prompt Filters / Global Filters
Using Combined Filter/Group Filter/ Filter Based on other Request
Configuring Interactive Dashboards & Prompts
Configuring Guided Navigation Links
Interactive Dashboard Design Objects & Principles
Q & A
DEMO
DAY 7
Administration & Security
Administration on Dashboards and reports
Authentication & Authorization
Object & Data Level Security
Webcatalog Level Security
Creating Users, Groups & Webgroups
Understanding Usage Tracking
Working on Creating Projects
Implementing MULTI USER DEVELOPMENT
Working on 3 WAY MERGE PROCESS
Introduction to Delivers
Delivers Configuration
Creating IBOTs and Scheduling
Configuring SA Systems
Q & A
Administration on Dashboards and reports
Authentication & Authorization
Object & Data Level Security
Webcatalog Level Security
Creating Users, Groups & Webgroups
Understanding Usage Tracking
Working on Creating Projects
Implementing MULTI USER DEVELOPMENT
Working on 3 WAY MERGE PROCESS
Introduction to Delivers
Delivers Configuration
Creating IBOTs and Scheduling
Configuring SA Systems
Q & A
DAY 8
BI APPS Intro
Overview of BI Publisher
Overview of OBIEE pre-defined applications
Architecture or Components of BI Apps Platform
Understanding one of the BI Schemas
Steps for implementing the Vanila or Out of the Box Modules
Understanding of the RPD with respect to the Out of the Box
Possible Challenges
Q&A
Demo
Overview of BI Publisher
Overview of OBIEE pre-defined applications
Architecture or Components of BI Apps Platform
Understanding one of the BI Schemas
Steps for implementing the Vanila or Out of the Box Modules
Understanding of the RPD with respect to the Out of the Box
Possible Challenges
Q&A
Demo
DAY 9
OBIEE Apps Continues
Understanding BI Apps Sales & Finance Schema
Various Modules of OBIEE Apps
Understanding Leading OBIEE Apps Implementations
Best Practices
Common Implementation Best Practices
Interview related Q&A
Introduction to 11g
Understanding BI Apps Sales & Finance Schema
Various Modules of OBIEE Apps
Understanding Leading OBIEE Apps Implementations
Best Practices
Common Implementation Best Practices
Interview related Q&A
Introduction to 11g
DAY 10
Hierarchical Columns
Scorecards
Column and Dashboard Prompts
Security Changes in 11g
Challenges encountering in Real time with 11g
Understanding of weblogic Admin Console
Understanding of weblogic Enterprise Manager
Scorecards
Column and Dashboard Prompts
Security Changes in 11g
Challenges encountering in Real time with 11g
Understanding of weblogic Admin Console
Understanding of weblogic Enterprise Manager
DAY 11
ETL with Informatica
Overview of Informatica Architecture
Understanding of ETL Process
Understanding Informatica Client Tools
Installation of Informatica - How To?
Understanding BI Apps Folder structures
Understanding Oracle Out of Box Mappings
Working with Designer
Importing Sources
Importing Targets
Understanding Transformations
Understanding SDE Mappings
Understanding SIL Mappings
Overview of Informatica Architecture
Understanding of ETL Process
Understanding Informatica Client Tools
Installation of Informatica - How To?
Understanding BI Apps Folder structures
Understanding Oracle Out of Box Mappings
Working with Designer
Importing Sources
Importing Targets
Understanding Transformations
Understanding SDE Mappings
Understanding SIL Mappings
DAY 12
Informatica Transformations
Understanding Transformations:
Creating Transformations
Source Qualifier transformation
Expression transformation
Aggregator transformation
Filter transformation
Lookup transformation
Update Strategy transformation
Sequence Generator Transformation
Using Variable Ports
Mapping Parameters and Variables
Working with Workflow Manager
Creating Sessions
Creating Tasks
Creating Worklets
Creating Workflows
Understanding Transformations:
Creating Transformations
Source Qualifier transformation
Expression transformation
Aggregator transformation
Filter transformation
Lookup transformation
Update Strategy transformation
Sequence Generator Transformation
Using Variable Ports
Mapping Parameters and Variables
Working with Workflow Manager
Creating Sessions
Creating Tasks
Creating Worklets
Creating Workflows
DAY 13
Understanding DAC
Overview of DAC (Arichitecture and Concepts)
Understanding DAC USER INTERFACE
Understanding DAC VIEWS
Configuration on DESIGN VIEW / Setup View / Execute view
Understanding DAC PROPERTIES
Understanding PHYSICAL DATA SOURCES
Understanding DAC OBJECTS
Understanding about TASK GROUPS / SUBJECT AREAS / EXECUTION PLANS
Overview of DAC (Arichitecture and Concepts)
Understanding DAC USER INTERFACE
Understanding DAC VIEWS
Configuration on DESIGN VIEW / Setup View / Execute view
Understanding DAC PROPERTIES
Understanding PHYSICAL DATA SOURCES
Understanding DAC OBJECTS
Understanding about TASK GROUPS / SUBJECT AREAS / EXECUTION PLANS
DAY 14
Working with DAC
Understanding DAC OBJECT HIRERACHY TASKS / BUILD IMAGE
Understanding how to Import TABLES and Coloums in DAC
Understanding RESETTING REFRESH DATES
Performing an out of box ETL loads
Exploring the change capture process
Siebel sources
Non siebel sources
Performing Full load
Performing Incremental load
Customizing out of box solution
• Best practices for customizing out of box informatica metadata
• Best practices for customizing out of box DAC metadata
• Walk through example.
Q & A
DEMO
Understanding DAC OBJECT HIRERACHY TASKS / BUILD IMAGE
Understanding how to Import TABLES and Coloums in DAC
Understanding RESETTING REFRESH DATES
Performing an out of box ETL loads
Exploring the change capture process
Siebel sources
Non siebel sources
Performing Full load
Performing Incremental load
Customizing out of box solution
• Best practices for customizing out of box informatica metadata
• Best practices for customizing out of box DAC metadata
• Walk through example.
Q & A
DEMO
No comments:
Post a Comment