"Selections run much quicker and the ability to manipulate the result view immediately after the report is executed is a huge win for our users. I believe they will appreciate the added control and flexibility."
Southeast Community College Cuts Data Mining & Evaluation Time with Informer
Conversation with Duane Roth, IT Programmer/Analyst, Southeast Community College
Pain Points
- Lack of Personalized Monthly Reports for Employees
- Constant Increase in Data Collection Time
- Burden on Valuable IT Resources
Challenge
Duane Roth, IT Programmer/Analyst and the team at Southeast Community College require a monthly upload be processed for all retirement deposits for 700+ employees on the payroll. This report must be sent in a specific file format with a minimum of five records per employee configured with specific field lengths.
Several years ago they were using a well-known report writer to create the multiple records required. The collection process took nearly one hour to format the data for all 700+ employees and send that output to an MS Excel file for further manipulations. The Excel file was then put into a COBOL program, and the pre-defined formatted output records were created for the upload.
Each month the data collection time would increase as another month of data needed to be evaluated. “Our initial run of several years ago went from a couple of minutes to almost an hour for data collection”, says Roth.
Solution
Using Informer, data evaluation and collection went from nearly one hour to under a minute. Southeast was able to create one report with all the required data elements and then export to an Excel macro file for additional data manipulation. Much of this data manipulation can now be done using the “Add Calculations” feature of Informer 4.0. “The whole process from start to upload is now just a few minutes compared to an hour previously”, says Roth.
Results
Multiple files are accessed by Informer in this report and through links within many of their reports. “Moving data fields to a different order in the report are also a snap”, says Roth. “Reporting capabilities are easy to use and the new ‘Add Calculations’ feature will deliver significant benefits.”
What he loves most about the latest release of Informer, says Roth, are the added benefits of using SQL files for input and the ease of formatting the reports. “We have realized significant time savings”, says Roth.
Selections run much quicker and the ability to manipulate the result view immediately after the report is executed is a huge win for our users. I believe they will appreciate the added control and flexibility.
Streamline Data Collection
Southeast Community College can complete necessary reporting in minutes. If you want to save time on reporting, then book your demo of Informer, the top-rated business intelligence platform.