Srihitha Technologies

Best Software Training Institute in Ameerpet , Hyderabad

Srihitha Technologies - Best Software Training Institute in Ameerpet , Hyderabad

OBIEE 11g Online Training in Ameerpet

OBIEE 11g Online Training in Ameerpet

Google+

Srihitha Technologies provides OBIEE 11g Online Training in Ameerpet by real time Experts. For more information about OBIEE 11g online training in Ameerpet call 9885144200 / 9394799566.

The OBIEE Plus integrates the components of the toolset to include a service-oriented architecture, data access services, an analytic and calculation infrastructure, metadata management services, a semantic business model, a security model and user preferences, and administration tools.

OBIEE is a comprehensive suite of enterprise BI products that delivers a full range of analysis and reporting capabilities along with a unified, highly scalable and modern architecture .Provides user with accurate and consistent insight to the information. Users can access the information through, web-based interactive dashboards, workspaces, search bars, enterprise resource planning (ERP) and customer relationship management (CRM) applications, mobile devices, and Microsoft Office applications.

PART I :  Overview

  • General Datawarehousing concepts
  • Dimensional modeling basics
  • Oracle Business Intelligence Application Overview
  • Describing the Oracle Business Intelligence Applications Architecture and components
  • BI Server
  • BI Answers
  • Interactive Dashboards
  • Delivers

PART II : Admin Tool and RPD Modeling

  • Creating Repository Using Administrative Tool
  • Repository Basics
  • Building Physical Layer of Repository
  • Building Physical Model and BMM Layer of a Repository
  • Building the Presentation Layer of a Repository
  • Testing & Validation of a Repository
  • Calculations & Measures
  • Creating Dimension Hierarchies
  • Organizing Presentation Layer
  • Working with Initialization Blocks and Variables
  • Adding Multiple Sources
  • Executing Direct Database Requests
  • Working with Aggregates
  • Creating Time Series Measures

PART III : Dashboard and Analysis

  • Creating Interactive Dashboards using Answers
  • Creating query and chart
  • Working with Filters
  • Working with Pivot Table
  • Building Views and Charts in Requests
  • Creating Interactive Dashboard
  • Configuring Interactive Dashboards and prompts
  • Configuring Guided Navigation Links
  • Using Partitions and Fragments
  • KPI & Scorecarding
  • Oracle BI for MS-Office

PART IV : Scheduling and Delivering

  • Sending Alerts Using Delivers
  • Configure Scheduler Schema
  • Scheduler Configuration
  • Creating Sample Request and Adding to Interactive Dashboard
  • Creating and Delivering a Simple iBot
  • Creating and Delivering a Conditional iBot

PART V : Security Features and Upgrade

  • Authentication & Authorization
  • Object & Data Level Security
  • Webcatalog Level Security
  • Creating Users, Groups & Webgroups
  • Upgrading RPD/WEBCAT from a earlier release

OBIEE Online Training in Ameerpet

OBIEE Online Training in Ameerpet

Google+

Srihitha Technologies provides OBIEE Online Training in Ameerpet by real time Experts. For more information about OBIEE online training in Ameerpet call 9885144200 / 9394799566.

Oracle Business Intelligence Foundation Suite is a complete, open, and architecturally unified business intelligence system for the enterprise that delivers abilities for reporting, ad hoc query and analysis, online analytical processing (OLAP), dashboards, and scorecards. All enterprise data sources, as well as metrics, calculations, definitions, and hierarchies are managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information is consumed.

Users can access and interact with information in multiple ways, including web-based interactive dashboards, collaboration workspaces, search bars, enterprise resource planning (ERP) and customer relationship management (CRM) applications, mobile devices, and Microsoft Office applications.

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