Oracle BI Publisher 12c: Fundamentals

COURSE TOPICS

Module 1 : BI Publisher 12c R1: Fundamentals Introduction

• BI Publisher 12c R1: Fundamentals Introduction

Module 2 : Introduction to Oracle BI Publisher 12c

• Introduction to Oracle BI Publisher 12c
• Skill Check: Introduction to Oracle BI Publisher

Module 3 : BI Publisher: Technology and Architecture

• BI Publisher: Technology and Architecture
• Skill Check: BI Publisher: Technology and Architecture

Module 4 : Getting Started with BI Publisher

• Getting Started with BI Publisher
• Practice 4-1: Signing In to Bl Publisher and Setting Preferences
• Practice 4-2: Creating and Modifying JDBC Connections
• Practice 4-3: Exploring the Catalog and Viewing a Predefined Report
• Practice 4-4: Creating a Private Folder
• Practice 4-5: Managing Favorites
• Practice 4-6: Creating a Simple Report Based on a Predefined Data Model
• Practice 4-7: Creating a Simple Report Based on a Spreadsheet
• Practice 4-8: Creating a Simple Report Based on BIEE Subject Area
• Skill Check: Getting Started with BI Publisher

Module 5 : Using Data Model Editor

• Using Data Model Editor
• Create a Report from Data Model Editor
• Practice 5-1: Opening the Data Model Editor and Creating a Private Connection
• Practice 5-2: Defining a SQL Query Data Set
• Practice 5-3: Viewing the Output and Saving Sample Data for the Data Model
• Practice 5-4: Editing the Data Model to Add a Parameter and an LOV
• Practice 5-5: Creating a Report Based on the NewDMSQL Data Model
• Skill Check: Using Data Model Editor

Module 6 : Working with Layout Editor

• Working with Layout Editor
• Work with Charts
• Practice 6-1: Adding a Chart to a Predefined Layout
• Practice 6-2: Editing the Table
• Practice 6-3: Adding Repeating Sections
• Practice 6-4: Creating a Layout with a Gauge and a Pivot Table
• Practice 6-5: Creating a Boilerplate
• Skill Check: Working with Layout Editor

Module 7 : Using Template Builder to Create RTF Templates

• Using Template Builder to Create RTF Templates
• OBI Publisher Charts
• Practice 7-1: Exploring Template Builder and Creating an RTF Template from a Sample File
• Practice 7-2: Working with a Chart and a Pivot Table in an RTF Template
• Practice 7-3: Designing an RTF Template for a Bl Publisher Report in Connected Mode
• Practice 7-4: Building an RTF Template by Using an Existing Data Model
• Practice 7-5: Reviewing a Report with Page-Level Calculations
• Skill Check: Using Template Builder to Create RTF Templates

Module 8 : BI Publisher Server: Administration and Security

• BI Publisher Server: Administration and Security
• Practice 8-1: Defining a File Data Source
• Practice 8-2: Reviewing Permissions Assigned to Default BI Publisher Users
• Practice 8-3: Configuring the Email Server as a Delivery Option
• Skill Check: Bl Publisher Server: Administration and Security

Module 9 : Scheduling and Bursting Reports

• Scheduling and Bursting Reports
• Practice 9-1: Examining BI Publisher Scheduler and Scheduling a Report
• Practice 9-2: Reviewing and Editing a Scheduled Job
• Practice 9-3: Adding Schedule Triggers to a Report Job
• Practice 9-4: Creating a Report for Bursting and Scheduling the Report to Burst to File Location
• Skill Check: Scheduling and Bursting Reports

Module 10 : Integrating BI Publisher with Oracle BI Enterprise

• Integrating BI Publisher with Oracle BI Enterprise Edition
• Practice 10-1: Viewing Presentation Catalog Integration Details
• Practice 10-2: Creating a Data Model and Report Based on an Oracle BI Server SQL Data Set
• Practice 10-3: Creating an Oracle BI Analysis
• Practice 10-4: Creating a Data Model and Report Based on an Oracle BI Analysis
• Practice 10-5: Adding a BI Publisher Report to an Oracle BI EE Dashboard
• Skill Check: Integrating Bl Publisher with Oracle BI Enterprise Edition

Module 11 : Creating Data Models and BI Publisher Reports Based on Other Data Sources

• Creating Data Models and BI Publisher Reports Based on Other Data Sources
• Practice 11-1: Creating a BI Publisher Report Based on an XML File
• Practice 11-2: Creating a BI Publisher Report Based on a CSV file
• Skill Check: Creating Data Models and Bl Publisher Reports Based on Other Data Sources