Training

Primavera P6 Training

BI Publisher for Primavera P6

Primavera P6 R8.x BI Publisher Fundamentals – for Oracle 11g

Duration: 3 Days

Prerequisites: Primavera P6 Project Management Experience. Experience working with data files and other report writers would be desirable.

Course Description: This course covers the fundamentals of designing and creating reports using BI Publisher for Primavera P6 R8.x.  This course is a hands-on class with approximately 25 student exercises which will allow the students to explore and use power features in BI Publisher. At the end of the class, students will be able to design, create and publish BI Publisher reports from scratch.

Requirements: BI Publisher for Oracle 11g, Primavera P6 EPPM P6R8 (need admin rights), SQL Developer, Email Server setup within BIP, WORD with BIP add-on.

Open Class Dates


Location


Dates


Availability

  On-line   Sep 16-18 (8-4 Central Time)   Available
  On-line   Nov 11-13 (8-4 Central Time)   Available

Costs and Registration

The class costs $1,950 per person. Access to a live system is included. To register, simply click here to download and complete the registration form or contact us by phone or email.

Course Contents

Chapter 1 – Introduction

  • Introduction to BIP
  • Login
  • Navigating BIP
  • Introduction to Administration Menu
  • Introduction to Data Model Editor
  • Introduction to Reports Layout Editor
  • Introduction to Report Jobs

Chapter 2 – Introduction to Data Model Editor

  • Data Models Overview
  • Properties
  • Datasets
  • Query Builder
  • List of Values
  • Parameters
  • XML Sample Data
  • Downloading then Uploading XML Data into Data Model

Chapter 3 – Introduction to Report Layout Editor

  • Overview
  • Creating a Report
  • Report Editor
  • Layout Editor
  • Adding Grids
  • Introduction to Text Item, Labels and Data Fields
  • Introduction to Data Tables
  • Introduction to Charts
  • Defaults
  • Parameters

Chapter 4 – Report File Management

  • Overview
  • Catalogs
  • Copy
  • Rename
  • Download
  • Upload
  • Other

Chapter 5 – Introduction to P6 Tables/Synonyms

  • Extended Tables
  • P6 Synonyms (P6Project, P6Activities, P6ActivityCodeAssignment, P6ActivitySpread, etc.)
  • Review Fields/Columns

Chapter 6 – Introduction to SQL

  • Introduction SQL Developer
  • SQL Overview
  • Basics – SELECT, FROM
  • WHERE and JOIN types
  • SUM, GROUP BY, ORDER BY, calculations
  • Other functions (TO_CHAR, NVL)
  • Accumulating Values
  • Nested JOINS
  • Review – and more examples

Chapter 7 –More on the Data Model Editor

  • Building Datasets with SQL
  • Event Triggers
  • Flexfields
  • Bursting
  • Other sources of Data (XML, EXCEL, Web Services, etc.)
  • Review – and more examples

Chapter 8 –More on the Report Layout Editor

  • Changing Data Model
  • Formulas
  • More on Data Tables
  • More on Charts
  • Pivot Table
  • List
  • Repeating Section
  • Gauge
  • Image
  • Review – and more examples

Chapter 9 –Report Jobs

  • Overview
  • General
  • Output
  • Schedule Jobs
  • Notification

Chapter 10 –Building Reports with MS WORD

  • Introduction – Another option for building reports in RTF format
  • Overview – not an in-depth discussion

Chapter 11 –Publishing Data from P6

  • Overview
  • Administrator/Application Settings
  • Administrator/Global Scheduled Services
  • Projects/Publishing Parameters
  • Running Reports from P6

Customer Testimonials

Don’t just take our word for it. Read what former attendees to Ten Six training courses have to say about their experiences. Click here to read them

Learn More

To learn more about this class, please contact Ten Six Consulting (703) 910-2600 or email us at [email protected]

To download this page please click here Oracle Business Intelligence Publisher Training

CONTACT US

(703) 910-2600

captcha

NEWS

  • Deltek Insight 2014

    This years Deltek Insight conference will be held in Orlando Florida on November 12-14 (Wednesday-Friday). This annual event, hosted at the Gaylord Palms Resort & Convention Center, will offer attendees..

    READ MORE...
  • Primavera P6 R8.4

    After the spate of recent conferences and events, the Oracle Primavera folks have been discussing their roadmap for Primavera P6. While it’s not uncommon for product roadmaps to span multiple years, they also seem to..

    READ MORE...