1 / 21

Data Warehousing on a Shoestring

Data Warehousing on a Shoestring. Utah State University Logan, Utah May 14, 2001. Overview of Presentation. Genesis – Why we did it. Process – How we did it. Results – What we achieved. Lessons Learned – Opportunities. Q & A. Genesis. Why We Did It. President Wanted Information.

torgny
Download Presentation

Data Warehousing on a Shoestring

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