Oracle Business Intelligence Enterprise Edition (OBIEE 11g)

Name: Oracle Business Intelligence Enterprise Edition (OBIEE 11g)
Rating: 3.6 (327 reviews)

OBIEE 11g

Created byIan Mwila

Last updated 3/2017

English

English [Auto],

What you'll learn

explain the background and history of Oracle Business Intelligence.
install the Oracle database, Oracle Business Intelligence and other required Software on your Windows machine.
Model, Build and Deploy complex repositories.
create analyses, dashboards, KPIs and scorecards.
understand and work security in OBIEE 11g

Course content

6 sections • 58 lectures • 8h 17m total length

Introduction and Background4:55
A Brief History of Oracle Business Intelligence3:40
Explore the history of Oracle Business Intelligence Enterprise Edition 11g, from Siebel Analytics and Oracle Discover to the OBIEE platform’s evolution through multiple release milestones and the Inquire Server heritage.
Data Warehouse Concepts7:22
In this lesson,you will be introduced to concepts of data warehousing and also the contributions made by William Inmon on the subject, and how influential those contributions have been to what we today consider as fundamental principles of data warehousing.
Data Warehouse Architectures5:27
At the conclusion of this lesson you'll gain understanding of the different types of data warehouse architectures available and why one enterprise architects may choose to go with one architecture over the other. You will also learn about basic data warehouse architectures contrasted with architectures with a staging area.
Logical Design in Data Warehouses5:33
Develop a logical design for data warehouses by modeling entities, attributes, and relationships, then define data content, system environment, transformations, and refresh frequency for scalable, user driven analysis.
Data Warehousing Schemas4:49
Explore data warehouse schemas such as star, snowflake, and constellation designs. Understand how dimension and fact tables drive performance, normalization, and flexibility.
Data Warehousing Objects9:37
Business Intelligence5:08
Explore business intelligence as a collection of applications and technologies that gather, store, analyze, and provide access to data to help enterprise users make better business decisions.
About Oracle Business Intelligence Enterprise Edition 11g6:23
Explore Oracle BI enterprise edition 11g as a platform for delivering business intelligence across diverse data sources, enabling dashboards, ad hoc reports, and end-user analytics.
An Introduction to Analyses, Dashboards, and Interactive Reporting5:41
Explore Oracle Business Intelligence Enterprise Edition's analysis and dashboards, enabling interactive reporting through tables, pivot tables, graphs, and maps accessible via web browser, mobile devices, or Microsoft Office.
Oracle Business Intelligence 11g Architecture7:31
Examine the OBIEE 11g architecture, detailing two main parts: Java components (publisher, security, SOA services) and system components (server, presentation services, scheduler, controller), plus Oracle Fusion Middleware integration.

Instant Client Download and Configuration9:42
Follow OBIEE 11g installation steps: set environment variables and install the lookback adapter with a static IP. Install the instant client, update PATH, and create an admin variable for labs.
Installation of Loopback Adapter7:23
Installation of Oracle Databases 11g8:44
Install Repository Creation Utility (RCU) 11g7:53
Install the repository creation utility (RCU) 11g for Oracle Business Intelligence Enterprise Edition, including download, run as administrator, database schema creation, and validation on a Windows machine.
Install Oracle Business Intelligence Enterprise Edition 11g10:00
Install Oracle BI enterprise edition 11g by downloading from Oracle, agreeing to licenses, setting up middleware, and installing and verifying enterprise manager, BI publisher, and real time decisions.
Post Installation Steps9:11

0_Module 3 Outline and Introduction8:41
Explore the Oracle BI Enterprise Edition 11g repository, its three layered metadata model—physical, business model and mapping, and presentation—and how it maps data sources to enable analysis, measures, and dashboards.
Building the Physical Layer of a Repository9:57
Create and configure a new obiee repository, import metadata from an oracle database, verify the connection, and build the physical layer with aliases, keys, and joins.
Building the Business Model and Mapping Layer of a Repository9:52
Building the Presentation Layer of a Repository9:26
Learn to build and validate the presentation layer of an OBIEE repository by creating a subject area, presentation tables, and columns, and dragging objects from the business model mapping layer.
Testing and Validating a Repository9:47
Check the repository and presentation layer for consistency, then save for queries. Run an analysis, verify results, and inspect the query log for Ezekial generated by Oracle server.
Managing Logical Table Sources8:58
Creating Calculation Measures7:51
Creating Logical Dimensions with Level-Based Hierarchies9:42
Level-based hierarchies enable calculations at specific aggregation levels and support multi-level data with one query and shared measures, guiding logical dimensions and levels across the business model and presentation layers.
Creating Level-Based Measures9:28
Using Aggregate Persistent Wizard9:55
Using Initialization Blocks and Variables7:17
Creating Time Series Measures6:22

Module 4 Outline and Introduction6:07
Beginning the Analytic Process9:08
Access OBIEE 11g to create an analysis: sign in, choose the primary subject area, build the analysis editor, filter for 2006, and add a graph showing dollars by year.
Creating Analyses10:24
Create analyses in OBIEE 11g by selecting subject areas, drilling down from calendar year to month, adding dollars and units, and exporting results to Excel or PowerPoint.
Formatting Analyses11:42
Using Formulas, Filters and Prompts17:03
Modifying Views and Adding Pivot Tables8:43
Modify OBIEE 11g views and analytics results beyond the default format, adjust chart axes, and add a pivot table to enhance data presentation and readability.
Working with Pivot Tables, Gauges, and Master-Detail Linking15:48
Create an analysis with pivot tables, apply calculations, format headings, and add a gauge view; then establish master-detail linking to sync regional and product data.
Building Dashboards8:42
Learn to build dashboards by combining analyses from multiple data sources, sharing via my dashboard and template pages, and designing multi-page layouts with objects and sections.
Working with Agents12:25
Published Reporting - BI Publisher20:12
Create highly formatted reports with Oracle Business Intelligence Publisher, building publisher reports on publisher data models and combining datasets from diverse sources for dashboards.
Using Scorecards, KPIs and KPI Watchlists20:45
Working With Briefing Books5:43
Learn to create and manage OBIEE briefing books by assembling dashboard pages, analyses, and published reports, updating content with agents, and exporting to PDF or HTML.

security15:36
Control access to subject areas and data items with raw level security. Connect security to directory services such as Microsoft Active Directory via Oracle platform security services.
Creating Users, Groups and Catalog Permissions19:44
Learn to create users and groups, assign catalog permissions, and configure security roles in Oracle BI Enterprise Edition 11g, including inheritance and access controls for analytics.
Row and Column Level Security13:20
Explore row and column level security in OBIEE 11g, including configuring user- and lower-level access, inheritance, explicit permissions, and the precedence of group versus user rights.

1. OBIEE On Oracle Linux Virtual Machine3:07
2. Download OBIEE SampleApp Files4:48
Identify and download OBIEE sample app files from Oracle for a Linux virtual box, use a download manager to unzip, install seven zip, and select a compatible version.
3. Other Required Downloads4:51
4. Installation of Other Required Downloads2:25
5. Installation of Oracle Database 12c5:02
Install the Oracle database 12c on Windows using the setup wizard, configure drive and Unicode options, and set administrator passwords. Complete database creation with the configuration assistant and unlock accounts.
6. Installation of Oracle BI Developer Client Tool3:07
Install the Oracle BI developer client tool for OBIEE 11g by following step-by-step instructions to run the installer, accept the default location, and create a desktop icon.
7. Installation of ODBC - Instant Client8:17
Install the Oracle instant client and configure environment variables, then run the installer, restart the computer, and copy and update files to point to the instant client and database listener.
8. How to Extract SampleApp OBIEE Downloads4:44
Follow steps to download, rename, and organize SampleApp OBIEE downloads, remove double extensions, and extract files with the seven zip file manager to prepare the Oracle Linux virtual box appliance.
9. Importing the Virtual Appliance2:33
Import the virtual appliance in Oracle VirtualBox by selecting the appliance file, configuring the host address, accepting terms, and waiting an hour for the import to complete before starting services.
9.2 Starting and Shutting down OBIEE in the VM9:03
9.3 Oracle ODBC Driver Configuration6:32
Configure the Oracle ODBC driver for remote connections, set up system DSN, test the connection, and configure the Oracle server with WebLogic using the virtual machine IP for online access.
10. Importing Dump files into Oracle Linux VirtualBox7:12
11. Connecting the Admin Tool to the Oracle Database in Linux7:23
Connect the Windows-based Oracle BI administration tool to the Linux Oracle database by starting services, creating a repository, configuring the connection pool and datasource, and updating tnsnames and instant client.
12. How to Deploy the RPD in Linux Environment7:16

Requirements

Students need to have intermediate knowledge of working with a PC and also willingness to follow instructions in the learning process
students need to understand that this is not a comprehensive course on OBIEE but rather an introductory to intermediate course meant for people new to Oracle Business Intelligence (although advanced topics are introduced and taught also)

Description

This course covers download and installation of Oracle Business Intelligence Enterprise Edition software including additional required software. After successful installation of the software you be shown how to work with the Oracle Business Intelligence (BI) Administration Tool (11.1.1.6) to build, modify, enhance, and manage an Oracle BI repository. You will learn how to import metadata from a data source, simplify and reorganize the imported metadata into a business model, and then structure the business model for presentation to users who request business intelligence information via analyses and interactive dashboards.

Then you will be shown how to create and modify analyses with different views, and add these analyses in interactive dashboards and alerts used to deliver the notifications by using your preferred method of communication. Additionally you will learn how to use variables, master-detail linking of views and adding various reports to briefing books and editing briefing books to update content.

Who this course is for:

beginners or people new to OBIEE and databases will find this course very helpful
people in the workforce can use this course as an on-the goal reference tool once they get stuck in their day to day activities
people with extensive experience working with OBIEE will not particularly find this course very useful

Oracle Business Intelligence Enterprise Edition (OBIEE 11g)

What you'll learn

Explore related topics

Course content

DATA WAREHOUSING AND OBIEE11 lectures • 1hr 6min

DOWNLOAD AND INSTALLATION6 lectures • 53min

BUILDING THE METADATA REPOSITORY12 lectures • 1hr 47min

CREATING ANALYSES AND DASHBOARDS12 lectures • 2hr 27min

INTRODUCTION TO SECURITY3 lectures • 49min

OBIEE In Oracle Linux Environment14 lectures • 1hr 16min

Requirements

Description

Who this course is for: