Testing Data, Reports & Patience: How Princeton Got a Grip Testing an Ever-changing BI Environment

Presentation Summary

Elisabetta Zodeiko; Princeton University

Testing Data, Reports & Patience: How Princeton Got a Grip Testing an Ever-changing BI Environment

Over eight years, Princeton University’s Information Warehouse has evolved to become the University’s primary B.I. environment, serving Faculty, Students and Administration. Since January 2012, over one million reports have been run by Warehouse Clients, and over fifty-thousand in the month of September, 2012 alone. During this time, the Warehouse had to survive upgrades and patches, fixes and new releases, new hardware, new operating systems, an expanding architecture, and the occasional natural disaster. Through all of these events, proper testing ensured that our Users never lost the exceptional Warehouse service they had come to expect and enjoy. “How did you do that?” you ask. Very good Testing. And Google. This presentation explains the various events affecting Princeton’s Warehouse (architectural growth and multiple instances, hardware changes, database software and B.I. patches, fixes, and upgrades, and operating system and E.R.P. patches, fixes and upgrades), our process to determine what should be tested (data, functionality, reports) and who completes the testing (IT or Client). We’ll share our experience with automating our test plans within our B.I. tool, experiences from past B.I. and PeopleSoft upgrades, and plans for tackling the future PeopleSoft split. (As a bonus, there will be no Test given after this presentation.)

Presentation Speaker(s)

Elisabetta Zodeiko

Presentation Files

You must be a registered member of the HEDW and properly logged in to view this content