Scripting School Provides Ant Online Training , AngularJS Online Training, Backbone js Online Training , Node.Js Online Training , JavaScript Online Training, LUA Online Training, Groovy Scripts Online Training , Groovy on Grails Online Training , HTML5 Online Training , Maven Online Training , Perl Script Online Training , PowerShell Online Training , Python Online Training , PHP Online Training , Ruby Script Online Training , Ruby on Rails Online Training , R Scripts Online Training , TCL Script Online Training , Unix Shell Script Online Training , VBScript Online Training ,Hadoop Online Training, Advanced Java Online Training, Core Java Online Training, Hibernate Online Training, J2EE Online Training, Spring Online Training, .NET Online Training, Microsoft BI Online Training, Microsoft SSAS Online Training, Microsoft SSIS Online Training, Microsoft SSRS Online Training, SharePoint BI Online Training, SharePoint Online Training, Windows Server 2008 Admin Online Training, Cognos Online Training, Datastage Online Training, Informatica Online Training, OBIA Online Training, OBIEE Online Training, Teradata Online Training, Advanced Perl Online Training, Android Online Training, Drupal Online Training, Joomla Online Training, PHP Online Training, Python Online Training, Salesforce Online Training, SAS Clinical Online Training, SEO Online Training, Veritas Volume Manager Online Training, Web Designing Online Training.

OBIEE Online Training

1). Data warehousing overview

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

2). Dimensional Modelling Overview

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

3). Introduction to Business Intelligence

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

4). 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

5). Building Physical Layer of a Repository

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

6). Building business Model mapping layer

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

7). Building presentation layer

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

8). Testing and validating Repository

  • Checking repository consistency
  • Checking Global Consistency
  • Inspecting Oracle Answers inspecting SQL
  • Inspecting log files

9). Adding multiple sources to dimension

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

10). Adding calculations to fact

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

11). Creating dimensional hierarchies and level based measures

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

12). Using aggregation

  • Importing Aggregated Tables into Repository
  • Modeling aggregate tables to speed processing

13). Using partition or fragments

  •  Identifying reasons to segment data
  •  Techniques to model partitions
  •  Value based partitioning

14). Using variables

  • Presentation Variables
  • Repository variables
  • Session variables

15). Multiuser Environment (MUD)

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

16). Modeling time series data

  • Types of SCDS
  • Using of time series functions

17). Modeling extension tables

  • Purposes of extension tables
  • Modeling extension tables for fact and dimensions

18). 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

19). Cache management

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

20). Working with Oracle BI Answers

  • Adding Column Filter Prompts in Answers
  • Building Business Requests using Answers
  •  Adding filters to Business requests
  • Views and charts in requests

21). 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

22). Administering OBI Presentation Catalog

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

23). Using Oracle BI Delivers

  • Configuring delivery devices
  • Add delivery profiles
  • Build Oracle alerts
  • Create ibots
  • Configuring Oracle scheduler database
  • Configuring of Event poll tables

24). Overview of Advanced Topics

  • BI Applications/ Pre-Built RPO
  • ETL Integration using DAC
  • BI Publisher
OBIEE Online Training institute in Hyderabad