Be prepared for change: SUDDS is being replaced with InformSU.

The university is in the process of implementing a new reporting capability and data warehousing solution, InformSU. Financial and Human Resource records moved in July, and SUDDS financial reports have migrated to InformSU.  HR reports are currently in development and development of student reports will begin after student data is migrated into the new Colleague environment on October 16th. Stay tuned for additional information as reports are developed and delivered.

What is InformSU?

InformSU is the home to institutional reports and data sources.  These reports fulfill many operational needs of the university, particularly in areas around Human Resource, Finance, and Student data.  To do this, they query three primary data sources:

  • ODS (Operational Data Store): Source of Colleague operational data
  • EDW (Enterprise Data Warehouse): Includes data from multiple sources (Colleague, TargetX, Raiser’s Edge)
  • Live Colleague: Most often used by Student Financial Services (Law and Non-Law) or the Office of the Registrar

ODS and EDW can be accessed via Report Builder, a tool intended to empower reporting units across campus with the ability to build their own ad hoc reports.

How do I access InformSU reports?

Access to InformSU reports follows university policies regarding information security. Different types of reports may require different levels of security approval, but in general two policies govern access.

  1. Your supervisor needs to communicate a work-related reason why you need to access the information and
  2. The data steward responsible for overseeing that request needs to approve the access request.

How these two steps happen varies by the category of information you are seeking.

Click the appropriate link below for more detailed directions on requesting access:

Financial Reports

Student Reports (not yet available)

HR Reports (not yet available)

Contact with your reporting needs and questions. horizontal rule

InformSU Financial Reports Training

A variety of self-service training is available for InformSU-Finance and related Chart of Accounts tools from the following links.

Report Builder

Report Builder is a tool Seattle University has selected for report development.  The reports generated can be reviewed and promoted to be shared on InformSU.  These reports will generally fall into one of two categories: Operational reports which will report off of the ODS (Operational Data Store) and analytical reports which will report off of the EDW (Enterprise Data Warehouse).

The below materials are intended to introduce users to Report Builder functionality.  Understanding Seattle University’s Colleague data and where to find important information may require that users work with colleagues or reach out for assistance.

Report Builder: Getting Started at Seattle University

Quick Guide: Report Builder: Installing Report Builder
Quick Guide: Report Builder: Accessing Lynda Training
Video: Report Builder: Connecting to SU Data

Excel Pivot Tables

Excel can be used to connect to external data sources such as the ODS and EDW.  Excel Pivot Tables are a way to report on Seattle University data and a great alternative to Report Builder.  It provides a powerful way to dissect and investigate data.

Excel: Getting Started at Seattle University

Video: Working with Pivot Tables in Excel 2013 - Part 1 
Video: Working with Pivot Tables in Excel 2013 - Part 2 
Video: Working with Pivot Tables in Excel 2013 - Part 3 
Video: Working with Pivot Tables in Excel 2013 - Part 4