Case Studies > Passaic County Community College Improves Data Integrity Across Campus with Entrinsik Informer

Passaic County Community College Improves Data Integrity Across Campus with Entrinsik Informer

Customer Company Size

Large Corporate

Region

America

Country

United States

Product

Entrinsik Informer
Colleague by Ellucian

Tech Stack

Entrinsik Informer
Colleague by Ellucian

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Cost Savings
Productivity Improvements
Customer Satisfaction
Digital Expertise

Technology Category

Functional Applications - Enterprise Resource Planning Systems (ERP)
Application Infrastructure & Middleware - Data Exchange & Integration
Application Infrastructure & Middleware - Data Visualization

Applicable Industries

Education

Applicable Functions

Business Operation
Quality Assurance

Services

System Integration
Training

About The Customer

Passaic County Community College (PCCC) is a higher education institution located in the United States. It serves a diverse student population and offers a wide range of academic programs and services. The college is committed to providing quality education and fostering a data-driven decision-making environment. PCCC faced significant challenges in managing their data, ensuring data integrity, and enabling self-service reporting for non-technical users. The college's IT staff was overwhelmed with report requests and struggled with the inefficiencies of their existing data management tools. To address these issues, PCCC sought a solution that would streamline their data management processes, improve data accuracy and security, and empower both IT and non-technical users to access and utilize data effectively.

The Challenge

Before implementing Informer, Passaic County Community College was experiencing daily challenges trying to manage their data. Accessing important information on their Colleague® by Ellucian database using the native Query Builder tool was difficult, time consuming, and inefficient, leaving end users frustrated and IT staff overwhelmed. “The main challenge was the urgency of the user needs and unclear requirements,” said Hanumant Borate, Database Administrator at Passaic County Community College. “A lot of time had to be spent on developing and modifying user reports and queries.” Self-service reporting with Query Builder was impossible for non-technical users and IT staff who could use the tool found it inefficient and extremely limited. Users could only examine small amounts of data at one time, queries were difficult to customize and report outputs were challenging to modify. Along with spending a large amount of time fulfilling user requests for reports, IT staff also experienced challenges with data integrity and security, never knowing if data was accurate or secure in their database.

The Solution

Staff at Passaic knew they needed a better solution for handling their reporting needs. Users needed a reporting tool that was truly end-user friendly, relieving IT from time-consuming report requests. IT staff needed a better way to manage and audit their databases to ensure data was accurate and secure. After reviewing several tools and unsuccessfully implementing another solution, Passaic selected Entrinsik Informer due to various recommendations from other colleges. Within days, Passaic was already seeing results with Informer. “Setup and implementation of Informer reporting tools is very fast, and within a few hours we were live,” said Borate. “Entrinsik support provided very good initial help to setup, create our production data sources, map files and fields, and with initial security setup. We were able to create reports in the first week.” With Informer’s intuitive interface, adoption across campus spread quickly with end-users in various departments finally able to access data previously unavailable to them. Users especially loved the ability to connect to multiple data sources simultaneously, one-click mapping of files and fields from their Colleague database, auto scheduling of reports, email functionality, report sharing capabilities, and security settings at every level.

Operational Impact

After implementing Informer, users at Passaic now find it easier and much less time consuming to access the information they need, all without IT intervention. Informer allows staff to view and analyze greater amounts of information from multiple sources, enabling more ad-hoc, multidimensional analysis of data and creating a data-driven decision making environment.
Users can now create multiple reports and dashboards based on the modules/functions in Colleague including Admission, Registration, Finance, and HR. With around 100 active users, Passaic has created hundreds of reports for every department, including: Dashboard of Key Performance Indicators, helping assess how well the college is achieving its mission and goals. Admission and Enrollment reports/dashboards keep enrollment up to date on targets, goals, and opportunities. Registrar reports for data integrity and analysis. Advising Department reports to identify students at risk and shorten the turn-around time to contact them. Data-driven tracking of progress reports. Academic Affairs – Course and Enrollment Tally reports. IR Office – Sure Data snapshots and reports for the state and federal Government. GL File suites, Enrollment Snapshots, Sure Data file suites and dashboards to compare data across multiple terms and years.
With their newfound reporting abilities, Passaic staff found more ways to accomplish their daily tasks and company goals than ever before. Informer allows both IT and non-technical users to create, customize, and share information within and across departments, leading to self-sufficiency, time and money savings college-wide.

Quantitative Benefit