Blog Entry

CRM at Alliance 2022 - Data Management and Visualization

Data, data everywhere, and not a drop to drink!!! We’re surrounded by a wealth of data and the way we parse and present it to make data easily understandable and actionable is the theme of these following presentations. Learn best practice methods to make the most of presenting data. Find out...

Blog Entry

TRAG R&A- Did you know how to find an existing similar query before creating a new one from scratch?

​ Do you know how to find an existing similar query before creating a new one from scratch? The SQL text of PS query is not stored as it is in system but that is generated when you click on the tab of View SQL in Query Manager. If you have access privilege in Query Manager, you can find all...

Blog Entry

The Role of a Chief Data Officer in Higher Education

Note that the below is a link to a free podcast offered by The Tambellini Group as part of our ongoing strategic partnership. For more information on this partnership and The Tambellni Group, please visit here . The Tambellini Group’s Katelyn Ilkani interviews San Cannon, Associate...

Blog Entry

Community Spotlight - Technical and Reporting

COMMUNITY SPOTLIGHT Technical and Reporting The Technical and Reporting Communities are maintained by the Technical & Reporting Advisory Group (TRAG). The TRAG provides advice and guidance on the technology underpinning the (Oracle) software applications used by the Higher...

Library Entry

The Student Touch Point Universe

This presentation will define a framework for integrating student data from admissions to graduation and everything in between. Once the framework levels are defined, we will technically discuss how to populate the framework. We will then technically discuss how the framework drives the...

Library Entry

A thrill of hope the PSQuery world rejoices – Advanced Topics in Query Manager

This session is designed for PSQuery writers familiar with the basics of PeopleSoft query manager reporting, but looking to get more out of the tool. The University of Texas at San Antonio has used PSQuery as its main reporting platform for almost 5 years since PeopleSoft implementation. Come...

SCHRUG_8126_190723_1110.pptx

Library Entry

3 Ways to "Flatten" Data for Reporting or Exporting

If you have ever needed to include information in a report or dataset that is multiple rows in the database but you need it output as a single row, this session is for you. A common financial aid request is to show all of the student’s awards, but keep the output as a single row per student. I...

BGSU MidHEUG Flat Data.pdf

Library Entry

PeopleSoft Query Tips and Tricks

Once just an ad-hoc reporting and investigation tool, PeopleSoft Query is the foundation of critical PeopleSoft infrastructure including Approval Workflow Engine, Keyword search, Pivot Grid component search, Pivot Grids, and BI Publisher Reports. In this session you will learn tips and tricks to...

Blog Entry

August Spotlight - Technical and Reporting

ADVISORY GROUP SPOTLIGHT Technical & Reporting (TRAG) Our Mission: Our aim is to support institutions in understanding and managing the heterogeneous systems landscape with a mixture of on-premise and ‘cloud’ applications, and the various integration, reporting strategy and governance...

Library Entry

Multitier Aggregation Reporting with Custom Dashboards - Using Advising Data as a Framework

The Strategic Advising Dashboard has different tiers of aggregation that summarize the student data at varying levels. The first view is a summarized count across six groups of metrics. The second view is a detailed table with student-level data providing additional information for the user. The...

Multitiered aggregation with advising data.pptx