Who should attend
- Software Engineers, Mainframe Professionals and Business Intelligence Professionals
- Project Managers and Database Analysts
- People who wants to build their career in Reporting and Analytics
What are the prerequisites for taking up the OBIEE online training?
There are no specific requirements for taking up this OBIEE certification training.
About the course
Intellipaat OBIEE certification training course lets you master the Oracle Business Intelligence and Analytics platform. We provide the best online classes to help you learn OBIEE architecture, installation, configuration, server, interactive dashboard and reporting through working on real-life industry projects.
About OBIEE Training Course
This OBIEE training from Intellipaat is meant to provide detailed knowledge of the OBIEE 12c. You will be trained in various Business Intelligence scenarios, BI life cycle, concepts of OLAP and working with charts and graphs. This OBIEE online training will help you generate templates and reports.
What will you learn in this OBIEE training course?
- OBIEE and its application
- Installation and configuration of OBIEE
- Developing a business model using OBIEE
- Concepts of BI and data warehousing
- Working with graphs and charts
- Using interactive dashboards
- Administrating the OBIEE server
- In-depth understanding of OBIEE architecture
Why should you take up the OBIEE training?
- Oracle is the market leader in the relational database with 48.35% market share – Gartner
- Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.
- An Oracle OBIEE Developer in the United States can earn $102,000 – indeed.com
OBIEE is an extensive Business Intelligence tool that is used across a wide range of industry verticals. This training will equip you with skills to develop business strategies, use interactive dashboards for data visualization, generate templates and reports and use ad hoc query analysis and scorecard. Upon the completion of the training and certification, you will be able to apply for jobs with a good pay scale.
OBIEE Course Content
- Data Modeling Concepts
Introduction to OBIEE,installation of OBIEE,What are data models and why you need them? The scope, reach and benefits of data modeling,data warehousing,sample OBIEE Report, the business requirement intrinsic in data modeling, various case studies, the data modeling implications and the impact of data modeling on business intelligence.
- Business Intelligence Concepts
Introduction to Business Intelligence, the architecture of data flow,OBIEE architecture, stack description of BI technology,BI Server,BI Scheduler,displaying report with data,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.
- Understanding OLAP
Online Analytical Processing,the OBIEE admin tools, RPD, the important concepts & terminology, significance of OLAP in business intelligence life cycle, understanding various data schemas like star,designing with Star Schema,creation of physical layer & simple RPD, enterprise information model, snow flake and constellation, aggregate and calculated measures.
- Oracle Business Intelligence Suite
Introduction to Oracle Business Intelligence Enterprise Edition, overview of the OBIEE product, the Architecture of OBIEE, key features and components,creating a simple report, business model, hierarchy, presentation and mapping.
- Oracle BI Repository
Understanding what is Oracle Business Intelligence Repository, installation of OBIEE on Windows system, directory structure installation, services,, analytics and interactive reporting, dashboard creation, multiple report creation, formula editing, column properties, altering
- BI Repository Business Model
Understanding how to build a Business Model and Mapping Layer in BI Repository, creating the Presentation Layer,formatting of data, conditional formatting, saving the report, creating and sharing folder. Topics – Data format, Conditional format, Removing filters,Like,Advanced ,Save the report , Shared folder and my folder, Creating new folder
- Business Model Continued
Working with the Enterprise Manager, testing and validating the Repository, cache disabling,dashboard prompt, filtering, editing of dashboard with action link.Water fall model.
- Working with Repository
Working with the Repository, creating Test Report, adding calculations, deploying OBIEE analysis, coming up with landing page UI and its features,repository variables, session and presentation variables.
- 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, master detail report, report creation with multiple subject areas, data mashup, visual analyzer, performance tile, BI functionality, waterfall model, graphs, pivot table, Pie chart, KPI watchList.
- Dashboard Creation
The OBIEE dashboard setup, basics of dashboard and dashboard pages, deploying Dashboard Builder for building Dashboards, editing, sharing, and saving Dashboard analysis,cache creation & clearing, ODBC functions in OBIEE, Logical Table Source, summary & detail report.
- OBIEE Security & Management
Securing the Oracle Business Intelligence Suite with Enterprise Manager, creating alerts, managing grouping and maintenance,administrating, the various types of security in OBIEE, object, task and folder level security, Report scheduling.
What projects I will be working on this OBIEE training?
Project : Report formatting using OBIEE
Industry : General
Problem Statement : How to find the revenue generated for a business
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.
- Filtering and sorting of Reports
- Deploying visualization & analysis techniques
- Designing an OBIEE dashboard.
This training course is designed to clear the Oracle Business Intelligence Foundation Essentials exam. The entire course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in top MNCs.
As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.
At the end of this training program, there will be a quiz that perfectly reflects the type of questions asked in the certification exam and helps you score better marks.
Intellipaat Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
Videos and materials
Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.
We are happy to help you find a suitable online alternative.