OBIEE Trainig – Best OBIEE Training in Chennai

OBIEE Training – Best OBIEE Training in Chennai 

 

Bound techs solutions offer world class OBIEE training (Online & classroom training in Chennai). Bound tech solutions providing best OBIEE training with “real – time projects”. We have a crew with highly professionalized OBIEE trainers, those are working in top MNC’s . During OBIEE training you will learn with real- time “corporate projects” .So that you can get hands on experience in OBIEE. Apart from training, our trainers whose working in corporate will share guidelines to get placements. So we are the best OBIEE online training and class room training institute in Chennai.

 

Training with Real Time Projects – World Class Tutorship
Placement Assistance – Online & Class Room Training

oracle business intelligence training

What is OBIEE

 

Oracle Business Intelligence Enterprise Edition  (OBIEE) is an comprehensive business intelligence (BI) and analytics platform developed by oracle corporation. OBIEE  supports the highest workloads and most complex deployments because of its modern technological  foundation. OBIEE Interactive Dashboards provides fully an interactive collection of dashboards and reports with a rich variety of visualizations

 

OBIEE allows user to create flash reports, report templates, and ad-hoc reporting for end users. It allows integration with major data sources and can also be integrated with third party vendors like Microsoft PowerPoint presentations and word documents.

 

The functionality of OBIEE including  Interactive Dashboards , Ad hoc Analysis and Interactive Reporting, Mobile Analytics, Enterprise Reporting, Proactive Detection and Alerts, Actionable Intelligence, Microsoft Office Integration, Spatial Visualizations and Analytics, Scorecard and Strategy Management, Server based query, reporting, and analysis .

OBIEE Training Module

(OBIEE online training & Class room training in Chennai)

 

INTRODUCTION TO DWH CONCEPTS

 

Day – 1

  • 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 Modeling
  • Fact Less fact table
  • Junk Dimension
  • Data Ware House Tools
  • Confirm Dimension

 

Oracle SQL

 

Day 2

  • 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
  • Some Basic SQL Commands
  • How to create tables and columns

 

ORACLE BUSINESS INTELLIGENCE – REPOSITORY

 

Day 3

  • Repository Basics
  • Oracle BI architecture components
  • Repository structure, features, and functions
  • Using the Oracle BI Administration Tool
  • Creating a repository

 

Day 4

  • 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

 

Day 5

  • 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

 

Day 6

  • 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

 

Day 7

  • Turning on logging
  • Testing a repository using Oracle BI Answers
  • Inspecting the query log

 

Day 8

  • Adding Multiple Logical Table Sources
  • Adding multiple logical table sources to a logical table
  • Specifying logical content

 

 Day 9

  • 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

 

Day 10

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

 

Day 11

  • Purpose of aggregate tables in dimensional modeling
  • Modeling aggregate tables to improve query performance
  • Testing aggregate navigation

 

Day 12

  • Using Partitions and Fragments
  • Purpose for segmenting data into partitions and fragments

 

Day 13

  • 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

 

Day 14

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

 

Day 15

  • Building Views
  • Multiple use of Alias Table
  • Modelling Bridge Table

 

Day 16

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

 

Day 17

  • About EM
  • About Console
  • Path Location
  • Log Files
  • Configuration Files

 

Oracle BI Answer Side (Catalog)

 

Day 18

  • Catalog Manager Options
  • Migrations

 

Day 19

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

 

Day 20

  • Formatting
  • 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

 

Day 21

  • Types of View

 

Day 22

  • Oracle Business Intelligence Answers: Advanced Features
  • Combining request criteria using set operations
  • Executing direct database requests

 

Day 23

  • 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

 

Day 24

  • 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

 

Day 25

  • Using Prompts
  • Scope of the Prompt
  • Presentation Variable and Uses
  • Request Variable

 

Day 26

  • Combine Request
  • Direct Database Request

 

Day 27

  • 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

 

Day 28

  • 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

 

Day 29

  • Introduction to Oracle BI Scheduler
  • Using BI Deliver
  • Configuration of Scheduler Service
  • Creating & scheduling iBots

 

Day 30

  • Using Repository Variables
  • Session variables
  • Repository variables
  • Initialization blocks
  • Using dynamic repository variables as filters

 

Day 31

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

 

Day 32

  • Creating selection steps
  • Creating groups
  • Creating calculated items
  • Including advanced SQL clauses in your analysis
  • Providing Real Time Scenarios on RPD and Answer Side

 

Day 33

  • Interview Perspectives 1

 

OBIEE Training (Online Training)

 

Bound tech solutions Chennai, provide SAS online training for student’s from other states and country via skype, Google Hangouts,Citrix etc… Online training is more convenient for oversees students and working people. Online training more flexible with us. We are the best SAS online training Institute.

 

OBIEE training in Chennai (Classroom Training)

 

We also conduct classroom training with our highly configured world class training rooms. You can easily reach our center form Chrompet, Tambaram and Sanitorium. We are the best  Institute for OBIEE  training in Chennai