Session Information
Click here to go to the previous page
Sweeper - An Automated Data Validation (4117)
Track: Portal, Communication, Process & Information Management
Program Code: 4117
LEAD PRESENTER / PANEL ORGANIZER / BOF LEADER :   Click the plus sign to see more detailed information about each speaker.
 Daniel Schoch, Senior Programmer, The Principia
Description
Sweeper is an automated data validation system that our institution developed to help solve the challenge of monitoring data quality. Data corruption may be the result of inconsistent data entry, data entry allowed by Banner but violating local business rules, or unresolved bugs. Sweeper runs locally-developed SQL data validation scripts (coded with our institution's business rules), logs errors for later reporting, reports exceptions via email, and reschedules the next test. Additional tests can be added easily to the suite of tests in Sweeper, and each test can have its own scheduled frequency. A custom Self Service Banner application makes test script management easy, and also provides analytical graphs to monitor test results. Customizing our system to your institution's needs is as easy as writing SQL scripts and inserting them with their job parameters into a table. Come see how Sweeper can help you monitor your data quality!


Audio Synchronized to PowerPoint
(Code: 4117)
Attendee:Free
Virtual Attendee:$10 USD
Authorized NON-Attendee:$25 USD
  
This session is a part of:
Handout Online
(Code: 4117)
Attendee:Free
Virtual Attendee:Free
List Price:
  
This session is a part of: