Can you give a three-dimensional size example of what a data warehouse would be to support a four year university?
Sid Adelman’s Answer: These are some university data warehouse applications:
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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access