ABOUT OBIEE TRAINING

Oracle Business Intelligence Enterprise Edition (Oracle BIEE) is a comprehensive set of enterprise business intelligence tools and infrastructure, including a scalable and efficient query and analysis server, an ad-hoc query and analysis tool, interactive dashboards, proactive intelligence and alerts, real-time predictive intelligence, and an enterprise reporting engine.Oracle Business Intelligence online training is designed for every learner to bring greater business visibility and insight to a wide variety of users.

OBIEE training provides a full range of business intelligence capabilities that allow you to:
  • Collect up-to-date data from your organization
  • Present the data in easy-to-understand formats (such as tables and graphs)
  • Deliver data in a timely fashion to the employees in your organization
  • These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.

OBIEE online training provides a solid foundation on OBIEE 12 CR step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Participants will learn to design the Repository, Creating Answers/Analysis Requests, and Interactive Dashboard, Delivers, OBIEE 12CR/ Fusion Middle ware Security and OBIEE-BI Publisher integration.

Oracle Business Intelligence course is designed for those professionals who are looking for Great career as Consultant in BI Technology.The OBIEE training includes all real time industry use cases spanning across multiple domains.

OBIEE – COURSE CONTENT

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