The following is a short list of some of our past projects. For more information on completed projects, contact Tom Howa at firstname.lastname@example.org.
First Destination Dashboard
- The First Destination Dashboard takes career plans and pathway information from a set of surveys taken shortly before a student graduates, three months after they’ve graduated, and then six months after they’ve graduated. This dashboard organizes that information for a visual look at how well a student’s degree has prepared them for their desired career.
Public First Destination Dashboards
- While the First Destination Dashboard is strictly for internal use, the six Public First Destination Dashboards can be found on the Career & Professional Development Center’s “Who Hires U of U Grads" page. Unofficial report, these are for student use, as a resource to see potential post-graduation outcomes. Tracked data includes “Full-time Employment Salary,” “Career Outcomes by Organization,” and “Internship Placements.”
Continuing Education & Community Engagement
We worked with Continuing Education & Community Engagement to give them better access to data by moving the required data from PeopleSoft to the University's Operation Data Store (ODS). This data will be used to create dashboards for analytical purposes.
Marketing & Communications
The University Marketing & Communications department utilizes InfusionSoft software to maintain a contacts database that is used to send emails and target customers. There were some cases where the contacts data was wrong/outdated. We provided a permanent solution that will pull the correct data from the PeopleSoft system into the InfusionSoft software so the contacts database will always have correct and current information. The data from InfusionSoft is integrated into the ODS (BIPR Database), which can be used to perform any reporting in the future.
Office of the Registrar
Civitas Data Integration Project
- The project involved delivering PeopleSoft data from key student tables to the Vendor’s schema on the BIPR Database. The data is delivered using Informatica mappings and workflows. PeopleSoft tables, which do not use effective dating, have validations in the workflows to look for Inserts, Updates, and Deletes (marked) in the final data.