Oracle Business Intelligence Training | Get Detailed Knowledge of OBIEE 11g

Oracle Business Intelligence Course Description

Global Business Intelligence and Analytics Market to Reach $16.9 Billion in 2016 with Oracle being the market leader in the relational database with a 48.35% market share as of 2016.

Whether you believe it or not, BI Applications is giving life for of Data Warehousing and Business Intelligence in future. Just as the mid sized and large companies throughout the world have adopted large ERP, CRM, Billing, and HR applications, so too will the world adopt BI Applications.

This Oracle Business Intelligence Enterprise Edition Training from Pincorps is meant to provide a detailed knowledge of the OBIEE 11g.  You will be trained in the various Business Intelligence scenarios, the BI Life cycle, concepts of OLAP, working with charts, and graphs. You will be able to generate templates and reports.

Oracle Business Intelligence Training Learning Outcomes

  • Learn about the OBIEE and its application
  • Installation and configuration of OBIEE
  • Developing business model using OBIEE
  • Learn the concepts of BI and data warehousing
  • Work with graphs and charts
  • Use interactive dashboards
  • Administrating the OBIEE server
  • In-depth understanding of OBIEE 11g Architecture

Oracle Business Intelligence Training - Suggested Audience

This Oracle BI training is aimed at large set professionals who want to build their career in Reporting & Analytics. Suggested attendees based on our past programs are:
  • Software Engineers 
  • Mainframe professionals
  • Business Intelligence Professionals
  • Project Managers
  • Database analysts

Oracle Business Intelligence Training Duration

  • Open-House F2F (Public): 2/3 days
  • In-House F2F (Private): 2/3 days, for commercials please send us an email with group size to hello@pincorps.com

Oracle Business Intelligence Training - Prerequisites

No as such requirements for taking up this training

Oracle Business Intelligence training course outline includes:

1. Data Modeling Concepts
  • What are data models and why you need them? 
  • The scope, reach and benefits of data modeling, the business requirement intrinsic in data modeling & various case studies.
  • The data modeling implications and the impact of data modeling on business intelligence.

2. Business Intelligence Concepts
  • Introduction to Business Intelligence
  • The architecture of data flow, stack description of BI technology, need for reporting in business. 
  • Distinction between OLTP and OLAP
  • The BI platform in BI technology stack
  • The product and dimension hierarchy, multidimensional and relational analytical processing.
  • Types of Reports.
  • Multidimensional modelling.

3. Understanding OLAP
  • Online Analytical Processing
  • The important concepts & terminology.
  • Significance of OLAP in business intelligence life cycle.
  • Understanding various data schemas like star, snow flake and constellation, aggregate and calculated measures.

4. Oracle Business Intelligence Suite
  • Introduction to Oracle Business Intelligence Enterprise Edition
  • Overview of the OBIEE 11g product.
  • The Architecture of OBIEE, key features and components.

5. Oracle BI Repository
  • Understanding what is Oracle Business Intelligence Repository.
  • Installation of OBIEE on Windows system, directory structure installation, services.

6. BI Repository Business Model
  • Understanding how to build a Business Model and Mapping Layer in BI Repository.
  • Creating the Presentation Layer.

7. Business Model Continued
  • Working with the Enterprise Manager, testing and validating the Repository, cache disabling.

8. Working with Repository
  • Working with the Repository, creating Test Report, adding calculations, deploying OBIEE analysis, coming up with landing page UI and its features.

9. BI Presentation Catalog
  • Learning about the Oracle BI Presentation Catalog.
  • Accessing and managing objects.
  • Report archiving and exporting.
  • Data grouping and limiting in analyses, data formatting, conditional formatting.

10. Dashboard Creation
  • The OBIEE dashboard setup, basics of dashboard and dashboard pages, deploying Dashboard Builder for building Dashboards, editing, sharing, and saving Dashboard analysis.

11. OBIEE Security & Management
  • Securing the Oracle Business Intelligence Suite with Enterprise Manager.
  • Creating alerts, managing grouping and maintenance.

12. OBIEE Project - Report Formatting
  • Data – Revenue
  • Topics – This is an Oracle Business Intelligence project that is associated with creating complex dashboards and performing formatting of the report. You will gain hands-on experience in filtering and sorting of the report data depending on the business requirements. This project will also help you understand how to convert the data into graphs for easy visualization and analysis. As part of the project you will gain experience in calculating the subtotal and grand total in a business scenario while finding the revenue generated.
Keny White

Professor

Keny White is Professor of the Department of Computer Science at Boston University, where he has been since 2004. He also currently serves as Chief Scientist of Guavus, Inc. During 2003-2004 he was a Visiting Associate Professor at the Laboratoire d'Infomatique de Paris VI (LIP6). He received a B.S. from Cornell University in 1992, and an M.S. from the State University of New York at Buffalo.

Bachelor

After working as a software developer and contractor for over 8 years for a whole bunch of companies including ABX, Proit, SACC and AT&T in the US, He decided to work full-time as a private software trainer. He received his Ph.D. in Computer Science from the University of Rochester in 2001. "What I teach varies from beginner to advanced and from what I have seen, anybody can learn and grow from my courses".

Reviews

Average Rating

5
1 rating

Detailed Rating

5 stars
1
4 stars
0
3 stars
0
2 stars
0
1 star
0

    This is great

    I really love the course editor in LearnPress. It is never easier when creating courses, lessons, quizzes with this one. It's the most useful LMS WordPress plugin I have ever used. Thank a lot! Testing quiz is funny, I like the sorting choice question type most.