TrainersGlobe - OBIEE Trainings, Certification, Interview, Job Support
OBIEE Training Course
Prism IT Corp 2017 H1B Sponsorship
  • Demos
  • Job Trend / Job Market for OBIEE
  • Direct Client Requirements for OBIEE
  • OBIEE Course Content
    • Note : We Provide Customized Course Content Based On Your Requirement.

      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