OBIEE Online Training

Introduction

OBIEE – Oracle Business Intelligence Enterprise Edition is a business intelligence platform for company that gives capabilities for reporting, online analytic control (OLAP), ad hoc query and analysis, dashboards, and scorecards. OBIEE is a comprehensive package of business bi-products that gives a complete array of analysis and reporting features along with a single, modern and highly scalable structure. It provides users with understanding that is constant and precise to the information. Consumers can access the data through, web-based interactive dashboards, workspaces, enterprise resource planning (ERP) and mobile devices, customer relationship management (CRM) applications, and aMicrosoft Office applications.

Course Summary

Course Name OBIEE Training
Course Contents Introduction to OBIEE, Business Model, Presentation layer and Mapping etc.
Course Duration 30 Hours with Flexible timings
Course Delivery Instructor Led-Live Online Training
Course Eligibility Any Graduate
Ideal For Freshers, aspirants seeking to learn the OBIEE administration
Next Batch Please visit the schedule section

Course Objectives

  • Learn how to Setup OBIEE
  • Basic concepts of Data Warehousing and Business Intelligence
  • How to manage Oracle BI Server using Oracle BI Administration Tool
  • How to manage Objects in Presentation Services Catalogue
  • Know the differences between OLAP BI and OLTP
  • Deep understanding of OBIEE Architecture components

Prerequisites:  

Basic knowledge of SQL or Oracle my sql.

Course Curriculum

Module 1: Introduction to OBIEE

Topics: Introduction, Significance of OBIEE

Module 2:  Repository Basics

Topics: Importing a Schema, Creating ODBC Data Source, Creating Physical Joins

Module 3:  Business Model, Presentation layer and Mapping

Topics: Logical Tables, Columns and Joins, Business Model Objects and Delete Unnecessary objects, Dimension Hierarchies, Snow Flake Schema vs. Concept Star Schema, Presentation Layer

Module 4: Repository Testing and validation

Topics: Run Consistency Check, Query Logging, Query using BI Answers, Use query Log to verify Queries

Module 5:  Adding Calculations to a Fact Table

Topics: Create a New Measure, Calculation Measures, Initialization Block

Module 6:  Query, Reporting and Presentation

Topics: ODBC DSN, Direct Database request, Query and using Filters, Subtotals and Formatting results, Creating a Chart, Pivot Tables, Column Selector, View Selector

Module 7:  Dashboards

Topics: Interactive Dashboards, Dashboard prompts, OBIEE Security Doc OBIEE 11g installation Doc

Download Material

 

Testimonials

Write a Review

No review posted.