Introduction
• Introduction to BIP, Login and Navigating BIP
• BIP Administration Menu
• Data Model & Reports Layout Editor
• Report Jobs
• P6 Administrator/Application Settings
• P6 Administrator/Global Scheduled Services
• P6 Projects/Publishing Parameters
• Running BIP Reports from P6
Introduction to SQL
• Introduction to Databases
• Introduction to SQL Developer
• SQL Overview, SQL Basics – SELECT, FROM,
WHERE and JOIN types
• SUM, GROUP BY, ORDER BY, calculations
• Other functions (TO_CHAR, NVL)
• Accumulating Values, Nested JOINS
Introduction to Px Tables/Synonyms
• Px Schema/ Extended Tables Overview
• Px Synonyms: P6Project, P6Activities,
P6ActivityCodeAssignment, P6ActivitySpread,
P6ProjectCodeType, P6ProjectCode,
P6ProjectCodeAssignments, etc.
• Fields/Columns, Linking Px Tables
BI Publisher Navigation
• Catalogs
• Copy/Paste
• Rename
• Cut/Paste
• Delete
• Download Files
• Upload Files
Introduction to Data Model Editor
• Overview
• Properties
• Datasets
• Query Builder
• List of Values
• Parameters
• XML Sample Data
Introduction to Report Layout Editor
• Overview, Creating a Report
• Report Editor, Layout Editor
• Adding Layout Grids
• Text Item and Data Fields
• Data Tables, Repeating Section
• Report Defaults, Report Parameters
Advanced Data Model Editor
• Element by Expressions, Multiple Data Sets
• Joining Data Sets, Nested SQL Joins
• Activity Codes, Project Codes and UDF’s
Advanced Report Layout Editor
• Changing Data Model
• Formulas
• Charts
• Pivot Table
Intro to Template Builder (Word Add-on)
• Exporting Templates, Loading XML Data
• Adding Objects to Layout (Data Elements, Data Tables, Charts)
• Object Properties
• Uploading Templates to BIP