Obiee

• Course Name : OBIEE                                                                    24*7 Technical Support
  Duration         : 35 hours
  Faculty            : Realtime experience 
  
             5OBIEE trainings is a best online center in Hyderabad. We are providing very best online training on OBIEE.
  Highlights in our training:
  
  *  Very in depth course material with real time scenarios.*  We are providing class with highly qualified trainer.*  We will provide class and demo session at student flexible timings.*  In training case studies and real time scenarios covered.*  We will give 24*7 technical supports.*  Each topic coverage with real time solutions.*  We are providing normal track,weekend,fast track classes.*  We will give every recorded session for play later.*  We are giving placement support by multiple consultancies in INDIA, USA, Australia, UK etc.*  We are providing certification oriented trainings with 100% pass guarantee.*  We will give full support while attending the interviews and contact me any time after completion of the course.
  Course Content:
  
  INTRODUCTION
  
  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
  
  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

feel free to contact us