OBIEE Online Training

OBIEE Online Training

Oracle business intelligence suite enterprise edition and may be a comprehensive suite of enterprise Bi product that delivers a full vary of research and news capabilities. OBIEE Online Training  includes a unified extremely scalable , fashionable design, oracle Bi engineering and provides intelligence and paralytics from information spanning enterprise sources and applications – empowering the biggest communities with complete and relevant insight. Oracle Bi engineering and additionally bundles key oracle Titan news product for integrated news with Titan money applications.

We 123 Trainings have the most effective, extremely skilled & good professionals in market and additionally certified in their subjects and have gained experience with years of expertise in package coaching field. Our online coaching involves period of time examples from package trade and company organizations to find out ideas and to grasp the applying of identical for higher understanding. Our team are systematically researches to seek out all the most popular technologies, that helps in online coaching & create the scholars easier to find out the courses online.

We provide matched online work through skype And net conference with Associate in Nursing skilled able to provide you with work at your time and convenience. We tend to area unit aiming to supply on-line work for school youngsters across the planet
123 Trainings is the Best OBIEE Online Training Institute In Hyderabad, India.

Data warehousing overview

Basics of Data Warehousing
What is OLTP and OLAP?
Difference between OLTP and OLAP
Advantages of OLAP
What is Data Marts and ODS?

Dimensional Modeling Overview

Introduction to Dimensional Modeling
What are Facts and Dimensions?
Star schema and Snowflake schema

Introduction to Business Intelligence

What is Business Intelligence
Where BI tools are Used
Why the Oracle Business Intelligence
Advantages
Architecture, Components
Clients – Answers, Delivers, Dashboards and Web administration,
Servers- Oracle BI server, Presentation, Scheduler server

Server Architecture

Repository Basics

What is Meta data?
Creating a Repository using BI Administration Tool
Physical, Business Model and Mapping, and presentation layers
Properties of repository objects

Building Physical Layer of a Repository

Objects of Physical Layer
DSN for a data sources
Build physical layer

Building business Model mapping layer

Objects of BMM layer
Building Business model (creating logical tables, columns, joins)
Creating simple measures

Building presentation layer

Objects of presentation layer
Properties of the presentation layer
Build presentation layer

Testing and validating Repository

Checking repository consistency
Checking Global Consistency
Inspecting Oracle Answers inspecting SQL
Inspecting log files(Nqquery.log,NQSserver.log)

Adding multiple sources to dimension

De-normalizing tables structures in database design
Adding multiple sources to existing logical tables source
Adding second table sources

Adding calculations to fact

Calculation measures on the basis of physical and logical columns
Using Calculation wizard

Creating dimensional hierarchies and level based measures

Creating dimensional hierarchies
Use level based measures
Create Rank and Share measures

Using aggregation

Importing Aggregated Tables into Repository
Modeling aggregate tables to speed processing

Using variables

Presentation Variables
Repository variables
Session variables
Initialization Blocks

Multiuser Environment (MUD)

Overview on Multiuser Environment (MUD)
How to create projects in MUD
Checkout and checkin of projects

Modeling time series data

Types of SCDS
Using of time series functions

Modeling extension tables

Purposes of extension tables
Modeling extension tables for fact and dimensions

Oracle BI Security

Security at object and data level
Creating users and User groups
Assigning permissions to users
Setting Query limits and timing restrictions
Authenticating using an external database

Cache management

Purge cache and event handling tables
Making the table cacheable
Setting of cache in NQSCONFIG.INI file

Oracle BI Presentation services

Working with Oracle BI Answers

Building Busines Requests usiing Answers
Adding filters to Business requests
Adding Column Filter Prompts in Answers
Views and charts in requests

Creating Oracle Intelligence Dashboards

Creating dashboard pages using report requests
Creating dashboard prompts
Configuring guided navigation links
Adding content to dashboard
Conditional links and conditional section

Administering OBI Presentation Catalog

Using catalog management to maintain web catalog
Creating catalog groups, issuing privileges etc

We also provide other Data Warehousing Classes like Abinitio