(23C) Oracle Fusion Cloud HCM: Analytics Publisher

Module 1: Reporting and Analytics Overview

• Lesson Objectives
• Overview of Reporting and Analytics Toolsets
• Benefits of Reporting Within Oracle Fusion Cloud
• Separation of Duties by Job Roles
• Summary

Module 2: Analytics Publisher Overview

• Objectives
• Advantages of Using Analytics Publisher
• Analytics Publisher Logical Architecture
• Functional Components
• Bursting Overview
• Supported Output Formats
• Accessing Analytics Publisher
• Accessing Oracle Analytics Directly
• Accessing Oracle Analytics via OTBI
• Accessing Oracle Analytics via the Home Page
• Navigating Analytics Publisher
• Examining the Home Page
• Setting User Preferences
• Exploring the Catalog
• Understanding the Catalog Structure
• Reviewing Standard Reports
• Instructor Demonstration
• Summary
• Practices

Module 3: Creating Custom Reports

• Objectives
• Launching the Report Wizard
• Selecting the Data Source
• Report Creation Modes
• Saving Reports
• Viewing Reports
• Instructor Demonstration
• Summary
• Practices

Module 4: Report Layout Design

• Objectives
• Accessing Layout Tools
• Accessing Reports via BI Composer
• Accessing Reports via the Catalog
• Selecting Templates and Creating New Layouts
• Layout Editor Fundamentals
• Layout Editor Interface
• Common Layout Components
• Defining Groups and Sorts
• Enhancing Report Layouts
• Applying Conditional Formatting
• Conditional Formatting Examples
• Defining Table Filters
• Adding Charts and Data Fields
• Working with Text Items and Images
• Page Layout Features
• Instructor Demonstration
• Summary
• Practices

Module 5: Report Parameters and Properties

• Objectives
• Configuring Report Properties
• Configuring Layout Properties
• Defining and Managing Report Parameters
• Exploring the Data Source
• Instructor Demonstration
• Summary
• Practices

Module 6: Understanding and Creating Data Models

• Objectives
• Selecting a Data Model as a Report Data Source
• What Is a Data Model?
• Data Model Creation Process
• Components of a Data Model
• Supported Data Sources
• Building Data Models
• Creating a Data Model
• SQL Data Sources
• Building Models Using Database Tables
• Building Models Using Existing Subject Areas
• Defining Joins
• Managing Data Models
• Managing and Maintaining Data Models
• Instructor Demonstration
• Summary
• Practice

Module 7: Using the Template Builder

• Objectives
• Introduction to the Template Builder
• Downloading and Installing the Microsoft Word Add-In
• Template Builder Interface Overview
• Creating RTF Templates
• Uploading Templates to Style Templates
• Applying Templates to Existing Reports
• Instructor Demonstration
• Summary
• Practice

Module 8: Scheduling and Bursting Report Jobs

• Objectives
• Scheduling Reports
• Overview of Report Job Scheduling
• Configuring a Report Job
• Submitting and Managing Report Jobs
• Reviewing Report Job History
• Advanced Scheduling
• Scheduling Reports with Triggers
• Bursting Overview Within a Report Job
• Defining Bursting in the Data Model
• Enabling Reports for Bursting
• Instructor Demonstration
• Summary
• Practice

Module 9: Analytics Publisher Security

• Objectives
• Role-Based Access Control (RBAC)
• Roles, Privileges, Policies, and Profiles
• Reviewing Role-Based Access Examples
• Security Considerations for Reporting
• BI Duty Roles
• BI Roles
• Data Security
• Analytics Publisher Data Security
• Secured List Views
• Data Security Privileges
• Protected PII Tables and Associated Privileges
• Summary

Module 10: Information Resources and Support

• Oracle Help Center
• My Oracle Support
• Oracle Cloud Customer Connect
• Oracle University
• Oracle Partner Community
• OBIEE Help and Resources
• Analytics Publisher Help and Resources
• Oracle Technology Network