Business Intelligence Project Plan and Requirements for a Data Warehouse

Requirements Analysis

In defining the data warehouse requirements for the university data warehouse, the process areas most often relied on to serve the students, faculty, suppliers and broader community need to first be taken into account. The effectiveness of a data warehouse is directly related to the level of accuracy, clarity and precision it contributes to each role in an organization (Bara, Botha, Diaconita, Lungu, Velicanu, Velicanu, 2009). The single view of a data warehouse, which in the case of the students, faculty and staff need to be agile or flexible enough to support the most common processes, procedures and tasks they complete while being capable of scaling across the entire data management...

In the case of the university's implementation of a data warehouse, the most critical data elements are courses offered by major, tuition payment status and the financial status of accounts including tuition balances, and a comprehensive schedule overview of extracurricular activity costs and schedules, scholarship status and grades. Another area of the data warehouse will need to include a complete schema on all aspects of the information needs for faculty and staff, including their current and…