OBIEE Online Training

 >>  OBIEE Online Training

OBIEE Online Training


 (4.9) | 450 Ratings


Introduction


OBIEE Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Introduction To OBIEE

  • 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
  • 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 and 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
  • Using level based measures
  • Creating 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

Multi-User Environment (MUD)

  • Overview on Multi-user Environment (MUD)
  • How to create projects in MUD
  • Checkout and check-in 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 cache able
  • Setting of cache in NQSCONFIG.INI file

Oracle BI Presentation Services

  • Working with Oracle BI Answers
  • Building Business Requests using 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 Catalogue

  • Using catalogue management to maintain web catalogue
  • Creating catalogue groups
  • Issuing privileges etc

Practice Test & Interview Questions

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Introduction To OBIEE

  • 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
  • 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 and 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
  • Using level based measures
  • Creating 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

Multi-User Environment (MUD)

  • Overview on Multi-user Environment (MUD)
  • How to create projects in MUD
  • Checkout and check-in 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 cache able
  • Setting of cache in NQSCONFIG.INI file

Oracle BI Presentation Services

  • Working with Oracle BI Answers
  • Building Business Requests using 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 Catalogue

  • Using catalogue management to maintain web catalogue
  • Creating catalogue groups
  • Issuing privileges etc

Practice Test & Interview Questions

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry