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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!