Q:

Can you give a three-dimensional size example of what a data warehouse would be to support a four year university?

A:

Sid Adelman’s Answer: These are some university data warehouse applications:

  • Provide information to be used in a grant proposal
  • Administer grant proposals
  • Provide information on ethnicity statistics for a grant proposal
  • University finances
  • Human resources
  • Student demographics
  • Financial aid
  • Room and course scheduling
  • Data would be captured on the characteristics/demographics of students to better understand retention and success among minorities.

Chuck Kelley’s Answer: Of course (no pun intended), it depends on what the data warehouse needs to do. Dimension examples: date/time, course, instructor, student, buildings, grades. The Fact (attendance) could do a lot of good analysis, including grades to attendance, students to teachers, buildings and grades (if you have the same or similar class(es) in different buildings), morning students vs. afternoon students vs. evening students. The list could go on and on.

With other dimensions, you could do financial analysis, trend analysis (like the backgrounds of students who do well in your curriculum/teaching environment).

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access