Problem: As a Business Intelligence Consultant, you have been tasked with submitting a proposal for creating an enterprise data warehouse for a university.
Currently, the information is contained in a separate database by each university department (HR, Payroll, Registrar, Bursar, etc.). Some of the information contained in the various databases for students are: courses, tuition payments, extracurricular activities, scholarships, grades, and personal information. Faculty/staff: positions held, courses taught, salary & benefits, personal information, and published work or research.
They want to use this data warehouse to be able to see a single view of all university information for students, faculty, and staff. You have been tasked with creating a project plan, choosing the BI tools that will be used, and giving cost information.
1. Project Plan and Requirements for the Data Warehouse
2. Database Design
3. ETL Tool Selection
4. Data Mining/Reporting Tool