Question: Please include drawings A large state university system has four different campuses located all across the state. Each of these campuses operates as, essentially, its
Please include drawings
A large state university system has four different campuses located all across the state. Each of these campuses operates as, essentially, its own self-contained university, which means:
Each campus has its own IT organization that operates and maintains its own applications for that campus only
Each campus' applications include the following key software systems for:
Faculty management
Student admissions, grading, and administration
Facilities management (e.g., buildings and classrooms)
The state university's "main campus" is one of the four individual campuses, and is located in a small town in the center of the state
The main campus IT organization has responsibilities for not only that campus, but also support for the entire state university system as a whole
The main campus IT organization is just starting on a data warehousing initiative that is intended to serve the needs of 1) individual campuses as well as 2) the state university system as a whole.
________________________________
The start of the architecture, which will include data from the key systems on each campus being brought into a data warehouse:
Questions for this assignment
Draw (on paper, or in PowerPoint or another drawing program) two different approaches to building the data marts for this scenario.
Hint 1: You would not have 1 data mart for each of your source systems
Hint 2: Think of the types of analysis that university personnel would want to on data from the identified source systems
Hint 3: Think in terms of boundaries i.e., what data would be likely included versus excluded for someone doing different types of analysis
Please include drawings!!!!!
Step by Step Solution
There are 3 Steps involved in it
To address the question comprehensively and provide a detailed answer lets conceptually outline the approaches to building data marts for the universi... View full answer
Get step-by-step solutions from verified subject matter experts
