1 / 21

Data Warehousing on a Shoestring: A Case Study from Utah State University

This presentation delves into Utah State University's innovative approach to data warehousing under budget constraints. It outlines the motivations behind the project, detailing the president's demand for accessible information across various stakeholders. The process adopted involved collaboration amidst a decentralized IT environment, leveraging existing systems and technology. Key results demonstrate effective data management despite challenges. The lessons learned provide valuable insights into developing cost-effective data solutions. Explore the journey of achieving efficient data warehousing in an autonomous setting.

torgny
Download Presentation

Data Warehousing on a Shoestring: A Case Study from Utah State University

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Warehousing on a Shoestring Utah State University Logan, Utah May 14, 2001 Data Warehousing on a Shoestring – Utah State University

  2. Overview of Presentation • Genesis – Why we did it • Process – How we did it • Results – What we achieved • Lessons Learned – Opportunities • Q & A Data Warehousing on a Shoestring – Utah State University

  3. Genesis Why We Did It Data Warehousing on a Shoestring – Utah State University

  4. President Wanted Information Instant information, Broad brush, Drill down to details On the Telephone with: • Student / Parent • Faculty / Staff • Alumnus / Donor • Regent / Legislator Data Warehousing on a Shoestring – Utah State University

  5. What the President Wanted What He Was Willing to Pay For Data Warehousing on a Shoestring – Utah State University

  6. Process How We Did It Data Warehousing on a Shoestring – Utah State University

  7. Utah StateUniversity Data Warehousing on a Shoestring – Utah State University

  8. Decentralized IT Environment • Autonomous Colleges and Departments • CS defacto Administrators of IT • Weak University Wide IT Plan • No Vice President of IT or CIO Data Warehousing on a Shoestring – Utah State University

  9. Four Mainframe Applications Systems & Computer Technology (SCT Shop) • SIS Student Information System • HRS Human Resource System • FRS Financial Records System • ADS Alumni Development System • High School/College Relations • Other Interested Campus Entities Data Warehousing on a Shoestring – Utah State University

  10. 200+ File Servers • Strong Novell Presence • Strong SUN Presence • Growing Linux Presence Data Warehousing on a Shoestring – Utah State University

  11. Islands of Information • Student Services • Budget Office • Planning & Analysis • Contracts & Grants • Personnel Services • Independent Colleges Data Warehousing on a Shoestring – Utah State University

  12. President Wanted Information Put your best people on it – Get it done! Build… or Buy Simonize Data Warehousing on a Shoestring – Utah State University

  13. First Iteration Information Builders EIS Client / Server Implementation Support Intensive / Poor Performance Shallow Input from required participants In-fighting & Turf Battles over data ownership and definitions Data Warehousing on a Shoestring – Utah State University

  14. First Iteration R e s u l t s Data Warehousing on a Shoestring – Utah State University

  15. Data Warehousing on a Shoestring – Utah State University

  16. We looked again at OTS vendors Display of logo does not imply endorsement or criticism of products or companies. Data Warehousing on a Shoestring – Utah State University

  17. We Chose to Build • FreeBSD 4.1 • PostgreSQL 7.0 • PERL • Apache • Netscape 4.x Data Warehousing on a Shoestring – Utah State University

  18. Our Most Important Step! We created two functioning groups empowered to make decisions. AIMS Council Administrative Information Management System S & M Group System & Management Group (Smoke & Mirrors) Data Warehousing on a Shoestring – Utah State University

  19. Results What We Achieved Data Warehousing on a Shoestring – Utah State University

  20. Tour the USU Data Warehouse Data Warehousing on a Shoestring – Utah State University

  21. As the Ancient Martial Arts Warn: Be Careful How You Use It! Data Warehousing on a Shoestring – Utah State University

More Related