Weber State wanted to build a data warehouse to enhance data consistency and sharing of data across the University for reporting and analysis. Weber State considered building its own data warehouse, but it readily became apparent that the University could not complete the project in a timely way with the available resources and that requirements and policies would change too quickly and there were too many other demands on IT’s time.
In seeking a solution, Weber State investigated packaged cloud-based solutions, but due diligence showed that a majority of the universities who had purchased these solutions had ended up doing heavy customization. Weber State also faced a harsh reality; universities who had successfully built their own data warehouse or heavily customized a packaged solution had personnel resources six or seven times or more what we were able to throw at this development effort. Weber State felt boxed in at this point, and was leaning towards purchasing a packaged solution and customizing it.
Then Weber State found WhereScape--one of the things that stood out about WhereScape RED during its due diligence was that WhereScape RED is intended to be used with a small staff, which fit real well with the realities of the staffing available. From the selection of WhereScape RED to the implementation of a comprehensive Oracle data warehouse was nine months with two staff members. The initial rollout of the data warehouse contains Weber State student information comprised of 10 fact tables and supporting dimensions detailing one million student registration records dating back to 2006.
The Weber State enterprise data warehouse greatly enhances data consistency, data quality and data access for Weber State’s hundreds of Tableau users and is enabling analysts to ask and answer questions that were not possible due to the University’s previous data management infrastructure. Using Tableau, we are now able to analyze student demographics in some very powerful and insightful ways. The project has been deemed an overwhelming success by management and users alike.
From the selection of WhereScape RED to the implementation of our Oracle data warehouse was nine months with two staff members. The enterprise data warehouse greatly enhances data consistency, data quality and data access for Weber State’s hundreds of Tableau users.
Founded in 1889, Weber State University is a coeducational, publicly supported university offering professional, liberal arts and technical certificates, as well as associate's, bachelor’s and master’s degrees. The university prides itself in its excellent teaching, extraordinary commitment to meeting the needs of students at every stage of life and ongoing service to the community. WSU's Ogden, Utah campus is located on the western flank of the Rockies where more than 26,000 students study full- and part-time.