REPORTING AND ANALYTICS

Create ad hoc reports, drilling analytics, and BI Publisher data sources

What You Will Learn

  • Query Basics

  • Query Joins

  • Pivot Grid Basics

Certificate

Each course includes a blockchain-enabled digital certificate of achievement to prove your participation in our online course. Since this is a digital certificate, you print it, add it to your LinkedIn profile, or share it on social media!

WHO SHOULD ATTEND?

  • PeopleSoft Developers

  • Functional Analysts

  • PeopleSoft Power Users

Course curriculum

  • 1
    1. Introduction
    • © Copyright
    • 💡 Hints and Definitions
  • 2
    2. My First Query
    • Watch: Introduction
    • Watch: Query Manager
    • Query Manager Overview
    • Watch: Creating a Query
    • Watch: Selecting Records and Fields
    • Activity: Selecting Records and Fields
    • Watch: Activity: Email List
    • Activity: Email List
  • 3
    3. Filtering Data
    • Watch: Effective Dating
    • Activity: Effective Dated Criteria
    • Watch: Filtering Activities
    • Activity: Filtering with Constants
    • Activity: Using "In List" Criteria
    • Activity: Filtering with "Between" Conditions
  • 4
    4. Working with Multiple Tables
    • Watch: Related Joins
    • Activity: Related Record Joins
    • Watch: Related Joins Activity Solution
    • Watch: Hierarchy Joins
    • Activity: Hierarchy Joins
  • 5
    5. Pivot Grids
    • Watch: Pivot Grids
    • Pivot Grids
    • Activity: My First Pivot Grid
    • Activity: Pivot Grid View
    • Watch: Drilling Pivot Grids
    • Activity: Drilling Pivot Grids
    • Watch: Embedding Queries
  • 6
    6. Next Steps
    • Related Resources
    • Course Survey