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.
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 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.
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.
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:
Student Reports (not yet available)
HR Reports (not yet available)
Contact InformSU@seattleu.edu with your reporting needs and questions.
A variety of self-service training is available for InformSU-Finance and related Chart of Accounts tools from the following links.
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
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