1. Class room training for OBIEE will be given for student who located in Chennai, India.
2. OBIEE certification training will be given with assurance of getting minimum 90%
3. OBIEE Online training will be given for USA students in evening timings.
4. OBIEE training tutorials will be provided at the time of training.
 |
| OBIEE TRAINING |
5. Contact me at +91-9994883085, Skype - kashif7222, Email ID - coogle7222@gmail.com
Kindly find below syllabus for OBIEE 11g Training:
Repository
Development
ü
Repository
Basics
1. Architecture
Of OBIEE
2. Data Sources
3. Repository – Admin Tool
4. Physical Layer and its Objects
5. Business Model and Mapping layer and its Objects
6. Measures
7. Presentation Layer and its Objects
8. Repository Modes
9. Repository Directory
10. Publishing Repository
ü
Building
Physical Layer
1. Database
and Physical Layer Objects.
2. Connection Pool
3. Schema folder
4. Physical table and columns
5. Alias
6. Keys and Joins
7. Implementation steps
8. Data source
9. Importing data source
10. Consistency check and saving of RPD
ü
Building
Business Model and Mapping Layer
1. BMM
Layer objects
2. Logical Tables
3. Logical table source (LTS)
4. Measures
5. Columns Mappings
6. Implementation steps
ü
Presentation
Layer
1. Presentation
Layer Objects
2. Subject areas
3. Presentation tables and Columns
4. Nesting Presentation tables
5. Implementation Steps
ü
Testing
& Validating Repository
1. Validating
Repository
2. Consistency Check
3. Checking Logs
4. Logging levels
5. Publishing repository
6. Available Queries
ü
Logical
Table Source (LTS)
1. LTS
– Single and Multiple LTS
2. Implementation Steps
3. Import Additional Tables
4. Creating Aliases
5. Defining Keys and Joins
6. Types of methods of importing
7. Logical Columns
8. Adding columns from BMM layer to Presentation Layer
ü
Fact
Calculations in BMM Layer
1. Business
Problem and solution
2. Calculation Measures using Existing logical columns
3. Calculation measures using physical columns
4. Building Formula
5. Implementation steps
6. Expression Builders
ü
Logical
Dimensions
1. Logical
Dimension and its types
2. Level Based Measures
3. Share Measure
4. Implementation steps of Level-Based Logical Dimension
5. Parent level object
6. Child level object
7. Drill Path
8. Parent child Hierarchy
9. Implementation steps of Parent Child Level Logical dimension
10. Share Measures
11. Structure types
12. Verifying and importing to Presentation layer
ü
Aggregates
1. Aggregate
Tables
2. Aggregate Navigation
3. Steps to implement aggregate navigation
4. Aggregate Persistence wizard
ü
Variables
1. Variable
manager
2. Variable types
3. Repository Variables
4. Session variables
5. Initialization Blocks
6. Implementation steps
ü
Modeling
time series
1. Time
functions
2. Time series functions
3. Ago
4. ToDate
5. Period Rolling
6. Implementation steps
ü
Security
1. Oracle
Bi Security
2. Security Realms
3. Users & groups
4. Application Roles
5. Application Policies
6. Types of Security
ü
Cache
Management
1. Oracle
BI server Query Cache
2. Cache Manager
3. Purging Cache Entries – Manually & Automatically
4. Event polling Tables
ü
Usage
Tracking
1. Oracle
BI Usage Tracking Methods
2. Implementation steps of Usage Tracking
ü
MUDE
(Multi User Development Environment)
1. Overview of MUDE process
2. Steps to implement MUDE
ü
Administration
Tool Utilities
1. Wizards
and utilities
2. Manage sessions
3. Replacing Columns or tables
4. Documentation
5. Update physical Layer
6. Event table
7. Removing unused physical objects
ü
Write
back in analyses
1. Write back analyses
2. Steps to configure write back
ü
Partitions
& Fragments
1. Partition
2. Partitioning by value
3. Partitioning by Fact
4. Partitioning by level
5. Fragmentation
6. Fragmentation Content
7. Implementation steps
Create Analyses and
Dashboards
ü
Introduction
to Oracle Business Intelligence
1. Business
Intelligence
2. Oracle BI Architecture
3. Data sources
4. Sample Analysis Process
5. Login & Home page
ü
Oracle
Business Intelligence Analyses
1. Subject
areas
2. Tables & columns
3. Hierarchies
4. Creating and editing analysis
5. Subject areas and catalog panes
6. Steps to create analyses
7. Sort orders
8. Formatting the analysis
9. Customization
10. Display analyses results
ü
Administration
1. Administering
Objects in Presentation Catalog
2. Access and actions
3. Catalog security
4. Default BI Roles
5. Presentation catalog folder and object permissions
6. Object permissions
7. Manage Privileges
8. Users and roles
ü
Limiting
and grouping Data analyses
1. Data
Limitation in analyses
2. Filters
3. Grouping filters
4. Dynamic filters
5. Saved analysis filters
6. Drills
7. Analysis Prompts
8. Multiple column filters
9. Creating groups
10. Implementation steps of groups
11. Creating Calculated items
12. Implementation of calculated items
13. Selection Steps
14. Conditions in Selection steps
15. Implementation steps
ü
Advance
Features of Analyses
1. Setting
Analysis Properties
2. Operators
3. Combining Results of multiple analysis
4. Steps to implement Combining results
5. Direct database analysis
6. Steps to implement Direct database analysis
ü
Views and
Graphs in Analyses
1. Types
of views
2. Compound Layout pane
3. Bins
4. Table view and its properties
5. Link master-Detail views
6. Graph views and its properties
7. Formatting graph view
8. Narrative view
9. Ticker view
10. View selector
11. Column selector
12. Graphs by position and conditions
ü
Gauge and
Map View
1. Gauge
views – Types and properties
2. Implementation steps of gauge views
3. Map Views and its components
ü
Key
performance Indicators
1. KPI
– Key performance Indicators
2. Basic concepts and characteristics
3. Steps to create KPI’s
4. KPI Watch list
ü
Pivot
table
1. Pivot
table view
2. Analyzing and displaying data using pivot table
3. Steps to create pivot table
4. Sorting – Row Sort, Measure Sort
5. Aggregation Rules
6. Formatting – Section ,table and overall properties
7. Duplicating Measures
8. Hidden Measures
9. Summation
10. Pivot table properties
ü
Dashboards
1. Creating
and editing Dashboards
2. Dashboard pages
3. Adding reports to dashboard pages
4. Dashboard Properties
5. Dashboard report links
6. Sections
7. Columns
8. Conditions
9. Personal customization
10. Shared customization
11. Links to dashboard pages
12. Briefing Book
ü
Configuring
Dashboards
1. Dashboard
Objects
2. Alert section
3. Action Link
4. Action Link menu
5. Link or Image
6. Embedded Content
7. Folder
ü
Dashboard
Prompts
1. About
Dashboard Prompts
2. Scope of the dashboard prompts
3. Column prompts
4. Creating Second page of the prompt
5. Applying prompts with default values.
6. Prompt Selections
7. Specific values
8. Conditions
9. Applying prompts with default values
ü
Dashboard
Prompt Variables
1. Types
of variable use in Prompt
2. Request variable and prompts
3. Presentation variable and prompts
4. Steps to implement variable in prompts
ü
Delivers
1. About
delivers
2. Deliver devices
3. Deliver profiles
4. Creating delivery device and Delivery profile
5. Alerts
6. Configuring and steps to implement Agent
7. Using agents to deliver content
8. Using conditions to deliver content
Briefing book
1. About
Briefing book
2. Edit Briefing book options
3. Downloading briefing book
Phone - +91-9994883085
Skype - kashif7222
Email - coogle7222@gmail.com
Comments
Post a Comment