Oracle Business Intelligence Publisher 11g (Oracle BIP 11g)
4.2 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
121 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Business Intelligence Publisher 11g (Oracle BIP 11g) to your Wishlist.

Add to Wishlist

Oracle Business Intelligence Publisher 11g (Oracle BIP 11g)

Working with Oracle BI Publisher 11g from simple install to building complex reports
4.2 (21 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
121 students enrolled
Last updated 3/2017
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 11 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • •Install Oracle database software, Oracle Business Intelligence Publisher Enterprise Edition
  • •Launch and Log in to the BI Publisher
  • •Set Preferences
  • •Define Data Sources
  • •Create a Data Model
  • •Create a Report using Report Editor
  • •Use Layout Editor
  • •Schedule Reports (Create Report Jobs)
View Curriculum
Requirements
  • You should be able to use a PC at a beginner level
  • You should have basic relational database knowledge;
  • You should be able to follow step by step instructions for installing complex software and be able start and stop the software.
Description

In this Business Intelligence course, you will learn how to get started with Oracle BI Publisher 11.1.1.6.0 and later versions, such as how to install all the required software, create simple reports and more complex reports for distribution. You will also learn how to install Template Builder for MS Word and how to troubleshoot installation issues.

You will learn about creating a data model and creating and scheduling reports outside of Oracle Business Intelligence Enterprise Edition (OBIEE) when Oracle BI Publisher is delivered as a stand-alone application.

The course will also cover:

Installing required software 

Creating a Data Model

Creating Reports and Scheduling Reports/jobs

Install Template Builder successfully

Create an RTF template in the Offline mode

Create an RTF template in the Online mode

The course teaches both the basics and implementation of core Oracle Business Intelligence practices you need to work successfully with this software.

Who is the target audience?
  • This course is ideal for individuals who want to learn Oracle Business Intelligence Publisher 11g or higher
  • Oracle Business intelligence developer who want to go beyond the basics of OBIP
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
03:01:28
+
Getting Started with Oracle BI Publisher Enterprise
11 Lectures 52:26

This lesson covers how to get started with Oracle BI Publisher 11.1.1.6.0 and later versions to create simple reports and complex reports. You will learn how to create a data model, and a report layout using the online Layout Editor. In addition, you will learn how to schedule reports.

Preview 03:30

This lesson shows you the required software and system requirements in order to successful download and install the software.

System and Software Requirements
01:18

This lesson shows you all the required software you will need to download from Oracle.com and also which version of the software to download

Download Required Software
04:14

In this lesson you will be shown step by step how to install the Oracle Database 12c software required for this course.

Preview 05:02

This lesson walks you through the process of installing Open Database Connectivity (ODBC) - instant client software in order to connect to the Oracle database using different applications.

Installation of ODBC - Instant Client
08:17

This lesson shows you how to install the Repository Creation Utility(RCU) step by step required for creating repository tables in the Oracle database used in this course.

Install Repository Creation Utility - RCU
04:32

This lesson will show you step by step how to install the Oracle Business Intelligence Publisher 11g software which you will be using through out this course. At the conclusion of the installation steps process you will a working software required for all succeeding lessons.

Installation of Oracle BI Publisher 11g
06:38

This part shows you how to start the software after an initial installation and going forward whenever you intend to use the software.

Preview 06:10

This part shows you the right way to STOP the software.(following start and stop instructions shown in these lessons is important in order to avoid corrupting configuration files)

Stopping BI Publisher on Windows
03:12

This lesson demonstrates how to get started with Oracle BI Publisher 11.1.1.6.0 and later versions

Getting Started with Oracle BI Publisher
04:16

This topic will cover logging in to the BI Publisher and navigating through the Home page, using the catalog objects, managing the favorites, and viewing the user account settings. 

Oracle BI Publisher User Interface
05:17
+
General Navigation and Preferences
6 Lectures 33:27

You will learn how to create a new folder in the catalog. You will use this folder to store/save all the objects that you create in this lesson.

Preview 01:49

This lesson will show you how to upload a predefined object or a resource to the catalog. 
This topic will show how to upload a predefined data model to the catalog. A downloadable file had been provided; you will first need to unzip the file before you can upload it to BI Publisher.

Uploading a Resource to the Catalog
02:15

In this lesson you will be shown how to set your account preferences for using the My Account option for your login for your user credentials.

Setting My Account Preferences
05:31

 In this lesson, you will learn how to configure a JDBC connection to Oracle Database sample schema. (OE Schema). [Through JDBC connections Oracle BI Publisher supports various types of Data Sources such as Oracle Database]

Preview 05:08

Creating a new data model or selecting an existing/predefined data model is the first step in creating a BI Publisher report. In this lesson you will learn how to create a Data Model based on SQL query using the JDBC connection that you defined in lecture 15.

Creating a Data Model - Part I
09:02

In this lesson you will learn how to add parameters to the data model. 

Creating a Data Model - Part II
09:42
+
Creating Reports
8 Lectures 40:13

In this lesson you will create a New Report with the existing Data Model Salary Report Parameters, and choose to create the report by using the Report Editor Option.

Creating a New Report
03:31

In this lesson you will be creating a new layout using the Layout Editor, and use it to view the reports.[Creating a New Report involves selecting the source of the data for the report, selecting the data columns to be displayed in the report, and then adding a meaningful layout for this data, defining the properties for the report parameters, and scheduling the report.]

Creating a Report Using Report Editor - Part I
04:11

In this lesson you will edit parameters and view them in the Report Viewer.

Creating a Report Using Report Editor - Part II
08:16

This part will show you how to use the Viewer menu in order to view the report in Interactive view within a browser window.

Preview 04:32

This lesson will demonstrate to you the different ways in which you can create a Report Job and how you can schedule a Report Job.

Preview 06:14

This lesson will show you how to view and manage the scheduled jobs and job history.
You will also be able to edit a scheduled job and run it or resubmit and run again.

Managing Report Jobs
05:38

In order to deliver reports to multiple users, it may be necessary to connect to an email server. This lesson will show you how to use BI Publisher to connect to an email server in order to send scheduled jobs to your colleagues.

Connecting to an Email Server
02:07

This lesson will show you how to insert a Gauge Chart and/or a Pivot Table to your report.

Inserting a Gauge Chart or a Pivot Table
05:44
+
Complex formatting and Processing reports using RTF templates
11 Lectures 47:39

In this lesson you will learn how to download the Template Builder add-in, and install it. [Please note that if your MS Word is 2013 or greater do not download the template builder as demonstrated in this lesson, but rather follow instructions as provided in lesson 27]

This lesson lesson has all the required templates uploaded to the site for your download.

26. Installing Template Builder
05:17

This lesson troubleshoots installation issues you may experience if you are using Microsoft Word 2013 or later. You are shown how to download alternative Oracle BI Publisher Desktop tools which will work with later versions of MS Word in order for the Template Builder add-in to install correctly.

27. If Template Builder fails to Install
03:23

This lesson demonstrates to you how to build and upload your RTF templates in a disconnected mode which is sometimes called Offline mode.

Preview 09:13

This lesson is a continuation of lesson 28 "Building an RTF Template in Offline Mode- Part I"

29. Building an RTF Template in Offline Mode - Part II
04:34

This lesson is a continuation of lesson 29 "Building an RTF Template in Offline Mode- Part II"

30. Building an RTF Template in Offline Mode - Part III
02:14

This lesson is a first part of two and it demonstrates how to design an RTF template while logged into BI Publisher. You can build and upload your template via a direct connection with the BI Publisher Server, called Online mode.

Preview 08:19

This lesson is a second part of two and is a continuation of lesson 3. It continues the demonstration of how to design an RTF template while logged into BI Publisher. You can build and upload your template via a direct connection with the BI Publisher Server, called Online mode.

32. Building an RTF Template in Online Mode - Part II
03:07

This lessonc covers adding a pivot table to an existing RTF template. You will open an existing RTF template to preview a chart, and add a pivot table to the template. 

33. Working with a Pivot Table in an Existing RTF Template
05:06

This is a very short lesson and demonstrates how to use the Validate Template utilities available in Template Builder.

34. Using Template Builder Utilities - Validate Template
02:01

This is a very short lesson and demonstrates how to use Field Browser utilities available in Template Builder.

35. Using Template Builder Utilities - Field Browser
03:00

This is a very short lesson and demonstrates how to use Check Accessbility utilities available in Template Builder.

36. Using Template Builder Utilities - Check Accessibility
01:25
+
Administering Oracle BI Publisher
1 Lecture 07:43

This lesson shows you step by step how to administer BI publisher by demonstrating how to create data sources and then how to create roles using the Oracle Administration Console.

37. Administering BI Publisher
07:43
About the Instructor
Habergeons Technologies
3.7 Average rating
94 Reviews
514 Students
2 Courses
Business Intelligence Consultants

Hello

Habergeons Technologies specializes in oracle software and provides business intelligence solutions and application development mainly using Oracle products.

The instructor of this course is Ian: He is a Certified Oracle Business Intelligence Implementation specialist and has worked with Oracle software including Oracle Databases, ODI and OBIEE for over 9 years on versions 9i, 10g, 11g and 12c.

We look forward to assisting you attain your learning goals.

Thank you