This Oracle BI Publisher 11g R1: Fundamentals training will support you to build a foundation of understanding how to best leverage this solution. Through Training, you’ll learn the ins and outs of how to use this solution.
Learn To:
- Create data models by using the Data Model Editor.
- Create Business Intelligence Publisher reports based on the data models.
- Create report layouts by the Layout Editor.
- Create reports based on OBI EE data sources.
- Publish the reports on OBI EE Dashboards.
- Schedule reports and burst these reports.
Course Objectives
-
Module 1: Introduction to Oracle BI Publisher 11g
- Lesson 1: Course Agenda
- Lesson 2: Overview of Oracle BI Foundation Suite
- Lesson 3: Overview of Oracle Fusion Middleware
- Lesson 4: Overview of Oracle BI EE
- Lesson 5: Functions of Reporting Systems including Challenges
- Lesson 6: Introducing BI Publisher Paradigm
- Lesson 7: BI Publisher as a Strategic Reporting Solution for All Applicationss
- Lesson Salient Features of BI Publisher
-
Module 2: BI Publisher Technology and Architecture
- Lesson 1: Functional Components
- Lesson 2: Layout Templates
- Lesson 3: Multitier Architecture
- Lesson 4: Enterprise Server Architecture and Performance and Scalability
- Lesson 5: Document Generation Process and Output Formats
- Lesson 6: Supported Data Sources
- Lesson 7: Bursting Overview
- Lesson 8: Internationalization and Language Support
-
Module 3: Getting Started with BI Publisher
-
Module 4: Using the Data Model Editor
- Lesson 1: Exploring the Schemas Used in the Course
- Lesson 2: Exploring the Data Model Editor UI and the Supported Data Sources
- Lesson 3: Creating a Private Data Source
- Lesson 4: Creating a Simple Data Model based on a SQL Query Data Set
- Lesson 5: Using Query Builder to Build a Query
- Lesson 6: Viewing Data and Saving Sample Data Sets
- Lesson 7: Adding Parameters and LOVs to the Query
- Lesson 8: Configuring Parameter Settings and Viewing Reports with Parameters
-
Module 5: Working with Layout Editor
- Lesson 1: Opening the Layout Editor and Navigating the Layout Editor UI
- Lesson 2: Creating a Layout by Using a Basic Template
- Lesson 3: Inserting a Layout Grid
- Lesson 4: Adding a Table, Formatting Columns, Defining Sorts and Groups, and Applying Conditional Formats
- Lesson 5: Inserting and Editing Charts, and Converting Charts to a Pivot Tables
- Lesson 6: Adding Repeating Sections, Text Items, and Images
- Lesson 7: Working with Lists, Gauges and Pivot Tables
- Lesson 8: Creating Boilerplates
-
Module 6: Using Template Builder to Create Templates
- Lesson 1: Using the BI Publisher Menu Bar
- Lesson 2: Creating an RTF Template from a Sample, Changing Field Properties, and Previewing Table Data
- Lesson 3: Adding a Chart to an RTF Template
- Lesson 4: Designing an RTF Template for a BI Publisher Report
- Lesson 5: Creating a BI Publisher Report by Using Template Builder in Online Mode
- Lesson 6: Exploring the Basic and Form Field Methods
- Lesson 7: Exploring Advanced RTF Template Techniques Including Conditional Formats, Watermarks, Page-Level Calculations, Running Totals, Grouping, and Sorting
-
Module 7: BI Publisher Server: Administration and Security
- Lesson 1: Describing the Administration Page
- Lesson 2: Creating the JDBC Connections
- Lesson 3: Setting, Viewing, and Updating Data Sources
- Lesson 4: Describing the Security Model for BI Publisher and Oracle Fusion Middleware
- Lesson 5: Describing Groups, Users, Roles, and Permissions
- Lesson 6: Describing Delivery Options Including Print, Fax, Email, WebDav, HTTP Server, FTP, and CUPS
- Lesson 7: Describing and Configuring BI Publisher Scheduler
- Lesson 8: Integrating with Oracle BI Presentation Services and Oracle Endeca Server
0.00 average based on 0 ratings