1h._SOW_-_OBI_Class.docx

Oracle Business Intelligence Training Code AR10

MATERIAL/EQUIPMENT/SUPPLY

PURCHASE REQUEST NUMBER: TBD

1.0 INTRODUCTION

The Naval Surface Warfare Center (NSWC), Corona Division, Readiness Assessment Department, Code AR10 requires Oracle Business Intelligence Enterprise Edition 11.1.1.9 (OBIEE) training for Engineering Analysts. This course must be off-site, hands-on, instructor-led private training for groups of 20 or less. Course must include printed training material and web-based hands-on use of OBIEE with realworld examples. Training facilities, training equipment, and computers for use during the course must be provided by the source; training must be provided within 15 miles of Norco, CA area. The OBIEE instance used for training must be hosted by the source.

Course must cover the key elements of the OBIEE suite, including how to create tables, charts, narratives, pivot tables, and many other content objects available in OBIEE Answers; how to create and use OBIEE Dashboards to display those objects effectively; tools to build interactive dashboards; perform ad hoc analysis; configure information deliveries and alerts; and produce BI Publisher online reporting.

2.0 BACKGROUND

NSWC Corona has recently deployed OBIEE 11.1.1.9 to support Engineering Analysts. OBIEE will be used for ad-hoc analysis, custom dashboards for customers, and producing automated reports in RTF format. This training is required for the Engineering Analysts to become proficient in BI Answers, BI Publisher, and alerts.

3.0 REQUIREMENT

5-day course to cover the following topics:

Oracle BI Answers Topics (3-days) :

-Oracle BI Answers Basics -Filters -Drilling and Navigation -Pivot Tables -Graphs -Compound Layouts -Additional Views -Advanced Topics and Techniques -New Features for Existing Functions -Master-Detail Linking -Hierarchies -Selection Steps -Dashboard Prompts -Dashboard Layout -Populating Dashboard Contents -Saved Customizations -Creating and Configuring Agents -Appendix A: Graph Types Available in Oracle BI Answers -Appendix B: Variables -Appendix C: Dashboard Best Practices

Oracle BI Publisher Topics (2-days) -Introduction to BI Publisher -Creating BI Publisher Data Models -Creating a Data Model from an OBIEE Subject Area -Copying and Modifying a Data Model

-Creating a BI Publisher Reports and Layouts

-Developing Custom Layouts with Form Fields

-Custom Calculations

-Report Formatting

-Running Totals and Context Specific Content

-Charts

-Parameters and Lists of Values

-Using BI Publisher Reports in Dashboards -Creating a New Dashboard Page

-BI Publisher Analysis Tools -Online Analyzer

-Advanced Exercises

BI Answers Objectives:

-Learn to create BI Answers queries -Learn to create multiple query Views -Learn to create BI Interactive Dashboards -Learn to configure, schedule, and deliver Alerts

BI Publisher Objectives:

-Create an Oracle BI Publisher data model using a variety of data sources -Create RTF templates from scratch without the use of the BI Publisher wizards -Extend the simple templates by adding custom calculations and conditional formatting -Create and use charts and pivot tables -Enhance basic data models with parameters and selection lists -Enhance templates with advanced layout options -Distribute reports to multiple recipients through multiple delivery channels -Use BI Publisher reports in BI Dashboards -Use the built-in BI Publisher analysis tools

Offer must also provide:

1. Training facilities for 20 students

2. Printed training material

3. OBIEE 11.1.1.9 instance to support the hands-on training

4. Individual computers for each student to access the OBIEE instance

4.0 REQUIRED DELIVERY DATE:

Class 1: to be scheduled 3 weeks after award Class 2 and Class 3: to take place prior to 30 September 2017 with 3 weeks lead time

5.0 TRAINING LOCATION:

Within 15-miles of NSWC Corona, 1999 Fourth Street, Norco, CA 92860