Tel: +1 (713) 570-9633
Email: info@corptechit.com
UI/Web Professional IT Training CenterBuilding World Class IT Professional Online TrainingOwn your future learning new skills online

UI/Web Professional IT Training Center

CorptechIT has fast become one of the most sought after disciplines by companies today

Read More

Building World Class IT Professional Online Training

For the skilled manpower in high end technology courses like SAP, SAP-MM, SAP-WM, SAP-SRM, SAP-PP, SAP-SD, SAP-FICO, SAP-APO, SAP-BW/BI,SAP HANA and ERP domains.

Read More

Own your future learning new skills online

CorptechIT is all the more effective as it is very flexible and convenient and can be undertaken at any time even by working professionals.

Read More

ORACLE OBIEE

CorptechIT provides Online Training by experienced IT professionals. Our faculties dedicated to complete your course as per the schedule given. We record the classes from your end to refer the classes once again whenever is required. Oracle OBIEE Online Training being a really important module, we have taken precise steps in teaching a full-fledged Oracle OBIEE Online Training course curriculum that covers all the concepts. Our customer support team and trainers will solve all your queries as and when required. Oracle OBIEE Online Training has got the right training that can fulfill a candidate’s training expectations. We see to that the value and quality of our Oracle OBIEE Online Training will not be compromised at all. We will market your resume in USA, UK, SINGAPORE, NEWZELAND, CANADA, AUSTRALIA, JAPAN, SWEDEN, SOUTH AFRICA. We clarify your questions during the training even after the course completion. After completion of training we will help you to assist you to get certified on Oracle OBIEE . We will give you 100% Satisfaction.

Oracle OBIEE Online Training Course Content

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

  • hecking 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
-->