Business Intelligence Project Plan and Requirements for Essay

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 architecture (Longman, 2008).The objective of the requirement analysis phase of a data warehouse project is to design the Master Data Management (MDM) platforms the entire architecture will rely on to support the real-time access of the most critical information needed (McKnight, 2010). 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,….....