Oracle Business Intelligence Enterprise Edition (OBIEE 11g)

Name: Oracle Business Intelligence Enterprise Edition (OBIEE 11g)
Rating: 3.5 (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
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
Data Warehousing Schemas4:49
Data Warehousing Objects9:37
Business Intelligence5:08
About Oracle Business Intelligence Enterprise Edition 11g6:23
An Introduction to Analyses, Dashboards, and Interactive Reporting5:41
Oracle Business Intelligence 11g Architecture7:31

Instant Client Download and Configuration9:42
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
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
Managing Logical Table Sources8:58
Creating Calculation Measures7:51
Creating Logical Dimensions with Level-Based Hierarchies9:42
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
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
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
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
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
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
9.2 Starting and Shutting down OBIEE in the VM9:03
9.3 Oracle ODBC Driver Configuration6:32
10. Importing Dump files into Oracle Linux VirtualBox7:12
11. Connecting the Admin Tool to the Oracle Database in Linux7:23
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: