INF30019 Information Systems Project: BI Data Warehouse Plan

This project plan, developed for Swinburne University's INF30019 course, outlines the implementation of a Business Intelligence (BI) data warehouse for Southern State TAFE. The plan details the project's objectives, which include developing the data warehouse, establishing new data warehouse capacity, and supporting BI reporting. It covers project scope, deliverables (multi-dimensional database, report systems, etc.), a work breakdown structure, and scope change management processes. The schedule management plan includes milestones and completion dates, while the cost management plan provides a detailed budget breakdown. The quality management plan addresses quality standards, metrics, and control measures. The project's constraints, assumptions, and plan modification rules are also defined. The plan's aim is to enable cross-application reporting and a BI portal within the organization. The project is to be completed by December 31st, 2018, within a budget of $189,400.

Swinburne University of Technology
Faculty of Information and Communication Technologies
INF30019 Information Systems Project Management
Guideline: Look at http://www.projectmanagementdocs.com/ for some other templates and
some explanations of different parts of the project plan.

FINAL PROJECT PLAN
1 Introduction and Objectives of the Project Plan
1.1 Overview of the Organization
The paper mainly focuses on the organization “Southern State TAFE” that mainly reflects
on the implementation of Business Intelligence data warehouse for enabling the production of
cross application reporting ability as well as BI portal. The project mainly helps in establishing
new capability of Data Warehouse within the IT infrastructure of SST that generally assists in
laying foundation for the activities of future reporting.
1.2 Current Situation and Problem/Opportunity Statement
The paper mainly focuses on the implementation of BI data warehouse within the
organization “Southern State TAFE” that is quite beneficial for the organization. It is found that
the organization faces lot of challenges and issues in managing data and information and for this
the organization wants to implement BI data warehouse for enabling the production of cross
application capability of reporting as well as BI portal. It is found that the implemented project
will be found as an advanced capability proof. The activities of the project is helpful in entailing
the establishment of the needed hardware and system software for supporting BI reporting, for
defining source system, for processing the data and for delivering in reports in both printable as
well as online format.
2 Project Charter [5 Marks] (Note this section should not be revised
after it has been written)
2.1 Project Information
Project Start Date: < Development of BI Data warehouse > <14/5/18>
Project End Date: <Development of BI Data warehouse > < 31/12/18>
Project Manager: < Please Fill >
Project Sponsor: <Please Fill>
2.2 Project objectives
The objectives of the project are as follows:
 To develop Business Intelligence data warehouse

 To establish new data warehouse capacity within SST IT infrastructure
 To establish the software and system software for supporting BI reporting, defined source
system as well as for delivering reports.
2.3 Project approach
The approaches that are utilized in the project include:
 Establishing Business Intelligence portal
 Establishment of data warehouse capacity
 Implementation of data ware house capacity
2.4 Roles and Responsibilities
Name Role Position Contact Information
<Please Fill> Project manager Project manager <Please Fill>
<Please Fill> Project planner Project planner <Please Fill>
<Please Fill> Resource manager Resource
manager
<Please Fill>
<Please Fill> Database
administrator
Database
administrator
<Please Fill>
<Please Fill> Network system
administrator
Network system
administrator
<Please Fill>
<Please Fill> Network architect Network architect <Please Fill>
<Please Fill> Application
engineer
Application
engineer
<Please Fill>
<Please Fill> Programmer Programmer <Please Fill>
2.5 Project Constraints
The constraints of the project are as follows:
 The development of BI data warehouse must be finished within 31st December 2018
 The project must be finished within the approved budget that is around $189,400
2.6 Assumptions
The assumptions related with the project are as follows:
 The project of BI data warehouse will be finished within the budget of around
$189,400
 The development of BI data ware will be finished within 31st December 2018

2.7 Preliminary Schedule and Budget Estimates
The development of BI data ware house will be finished within 31st December 2018 by
utilizing budget of around $ 189,400 as approved by the Southern State TAFE.
2.8 Plan Modification Rules
The rules for medication include:
 The project manager is the only person who can be able to make changes within the project
 The changes that are required to be done within the project must be approved by the higher
authority of the organization.
2.9 Approval Signatures
Project Manager:
As project manager on <Please fill >, I have reviewed the information contained in the Project
Charter and agree to its content.
Name Position Signature Date
<Please Fill> Project manager <Please Fill> <Please Fill>
<Please Fill> Project planner <Please Fill> <Please Fill>
<Please Fill> Resource manager <Please Fill> <Please Fill>
<Please Fill> Database
administrator
<Please Fill> <Please Fill>
<Please Fill> Network system
administrator
<Please Fill> <Please Fill>
3 Project Scope Management plan
3.1 Product description
The Business intelligence data warehouse that is implemented within the organization
Southern State TAFE generally assists in enabling the production of cross application reporting
as well as business intelligence portal.
3.2 Project Deliverables
The list of project deliverables include:
 Multi-dimensional database
 Validation procedure
 Report systems
 Data mechanism and data transfer
 Financial system
 Student management system
 Payroll system

3.3 Scope Statement
In-Scope
 SharePoint site for the BI portal
 Development of BI data warehouse
 Dashboard for displaying revised balanced scorecard
 Security model use for data warehouse and BI portal
 Review of errors
 Establishment of installation and infrastructure of the required system software.
Out scope
 Generation of data extracts from the system
 Changes within the financial system
 Replacing the management system for the student
 Reconciling of the data that is uploaded
3.4 Work Breakdown Structure Development
Figure 1: WBS
(Source: Created by Author)

3.5 Scope Change Management Process
The changes within the project scope can be identified, addressed, communicated as well
as documented with the help of following:
 Communication
 Tracking project
 Reporting
 Status report
The list of members of the change control board who will generally involve in rejecting
as well as approving the changes within the project are as follows:
 Project manager
 CEO
 Higher authorities of the organization.
3.6 Plan Modification Rules
The plan modification rules include:
 The changes in the project can only be done by the project manager
 Approval from the higher authority of the organization must be taken before making any types of
changes within the plan.
4 Schedule management plan
4.1 Project Schedule
Milestone Completion Date
Milestone 1: Completion of KPI excel workbooks Fri 18-05-18
Milestone 2: Completion of SST defines KPI's Thu 30-08-18
Milestone 3: Completion of SQL server data Wed 24-10-18
Milestone 4: Completion of BI portal Thu 06-12-18
Milestone 5: Completion of active directory group Tue 18-12-18

5 Cost management plan
5.1 Project Budget
The project “development of data warehouse” will be completed successfully within the
budget that is around 189,400. The cost that is needed in order to finish the budget of the project
is provided in the table below:
Task Name Duration Resource Names Cost
Implementation of BI data
warehouse 166 days $ 189,400.00
KPI 79 days $ 73,808.00
KPI excel workbooks 8 days $ 3,080.00
KPI's excel worksheet is
created by BPC, SST 5 days Project manager, Project planner $ 2,000.00
Setting manual insert
rules 3 days Project planner, Resource
manager $ 1,080.00
Milestone 1: Completion
of KPI excel workbooks 0 days $ 0.00
SST defines KPI's 71 days $ 70,728.00
Corporation 3 days Project planner, Resource
manager $ 1,080.00
SQL server data is
created by BPC, SST 4 days Network system administrator,
Network architect $ 1,632.00
Database is created by
BPC 5 days Application engineer, Database
administrator $ 1,800.00
Data validation is set up
BPC 3 days Application engineer, Database
administrator $ 1,080.00
Defining physical system 5 days Network architect, Programmer $ 1,840.00
Defining logical system 7 days Network system administrator,
Network architect $ 2,856.00
BPC develops database 8 days
Database administrator, Network
system administrator,
Hardware[1]
$ 25,328.00
Report is created by BPC 6 days Project planner, Resource
manager $ 2,160.00
BPC develops decreases
ETL process abase validation
rules
8 days Network system administrator,
Network architect $ 3,264.00
BPC creates ETL process
to load files from oracle
financials
8 days Database administrator,
Programmer $ 3,008.00
File mechanism is created
by BBC, SST 12 days Application engineer, Database
administrator $ 4,320.00

New structure of database
is created by BPC 8 days Database administrator, Project
manager $ 3,520.00
BPC implements new
database structure to student
management system
10 days Database administrator, Network
architect $ 3,920.00
BPC creates planning for
implementation 9 days Network architect, Project
manager $ 3,888.00
Project plan is executed
by BPC 8 days Project manager, Project planner $ 3,200.00
BPC perform further
maintenance 9 days Network system administrator,
Network architect $ 3,672.00
BPC implements new
database structures to SST
infrastructures
10 days Programmer, Project manager $ 4,160.00
Milestone 2: Completion
of SST defines KPI's 0 days $ 0.00
SQL server data 43 days $ 49,056.00
Multi-dimensional database 4 days Network architect, Programmer $ 1,472.00
Validation procedure 5 days Application engineer, Database
administrator $ 1,800.00
Report systems 8 days Project planner, Resource
manager $ 2,880.00
Data mechanism and data
transfer 9 days Network system administrator,
Programmer, Software[1] $ 31,496.00
Financial system 8 days Network system administrator,
Programmer $ 3,136.00
Student management
system 5 days Network architect $ 960.00
Payroll system 6 days Network system administrator,
Programmer $ 2,352.00
BPC creates excel
workbooks 7 days Programmer, Project manager $ 2,912.00
Automation rules are set by
BPC 4 days Network architect, project planner $ 1,408.00
Usage activities 4 days Project planner $ 640.00
Milestone 3: Completion
of SQL server data 0 days $ 0.00
BI portal 35 days $ 61,480.00
BPC set up connection to
SST intranet 4 days Database administrator, Network
architect $ 1,568.00
SharePoint screen 3 days Application engineer, Network
architect $ 1,056.00
SharePoint site 4 days Application engineer, Database $ 2,240.00

administrator, Resource manager
Balanced scorecard 5 days Network architect, Programmer $ 1,840.00
Dashboard 6 days Network architect, Programmer $ 2,208.00
BPC creates SharePoint 2 days Network system administrator,
Programmer $ 784.00
BPC creates SharePoint
screen 6 days Programmer, Project manager $ 2,496.00
BPC creates SharePoint site 6 days Application engineer, Network
architect $ 2,112.00
BPC creates balanced
scorecard 7 days
Database administrator, Network
system administrator, Additional
cost[1]
$ 27,912.00
BPC creates Dashboard 5 days Network architect, Resource
manager $ 1,960.00
Performance point screen 9 days Database administrator, Project
manager $ 3,960.00
KPI maintenance screens 7 days Network architect, Project
manager $ 3,024.00
BPC creates performance
points 6 days Network architect, Programmer $ 2,208.00
BPC creates KPI
maintenance screen 5 days Application engineer,
Programmer $ 1,680.00
BPC creates performance
point screen 9 days Application engineer, Network
architect $ 3,168.00
BPC creates KPI
maintenance screen 8 days Network system administrator,
Network architect $ 3,264.00
Milestone 4: Completion
of BI portal 0 days $ 0.00
Active directory group 9 days $ 5,056.00
Security systems 5 days Network system administrator,
Project manager $ 2,280.00
SST sets active directory
group 4 days Application engineer, Project
manager $ 1,600.00
BPC, SST creates system
security validation 3 days Network architect, Resource
manager $ 1,176.00
Milestone 5: Completion
of active directory group 0 days $ 0.00
5.2 Budget Constraints
It is identified that in this project, definitive estimate is used in order to estimate the budget
of the project. It is considered as one of the most accurate method of budget estimation. The
accepted level of variation that can occur within the projected cost and the actual budget of the

project will be around -10% to +10%. Thus in order to prepare the project budget with the
help of definitive method it is quite necessary to perform large amount of research within
the project for getting lower variations within the project.
6 Quality management plan
6.1 Quality Standards
Project Processes/Reports Quality Standards
<Enter project area here> <Describe the standards that apply to project processes/reports
here>
Status Reporting The project manager mainly tracks the process of collecting
information that is done for the project status report.
Quality reporting The resources that are utilized in the project are checked by the
project manager for ensuring that they are of good quality.
6.2 Quality Metrics
Project Deliverables Quality Metrics
<Enter project deliverable
here>
<Describe the quality metrics that apply to project deliverable
here>
Customer Satisfaction The customers of the organization are provided feedback form for
reflecting the level of satisfaction that they are getting from the
organization. The level of satisfaction must be between 3 to 3.5.
Employees satisfaction The satisfactions of the employees are checked and it is mainly
analyzed by the way they are mainly involved with the project.
6.3 Quality Management Approach
The lists of tools that are helpful in managing the quality of the project are reflected below:
 Check sheet
 Control chart
 Histogram
 Pareto chart
 Scatter diagram
 Stratification

6.4 Quality Control
The steps of quality control include:
Creating quality plan: The quality plan helps in describing how the quality requirements
as well as expectations, quality tools as well as quality needs are met.
Controlling quality of the project deliverables: It is identified that the quality control
activities are the steps that generally focuses on the entire quality of the project deliverables that
are generally produced.
Assure the quality of the deliverables: Quality assurance mainly refers to the step that
generally helps in validating processes for creating the deliverables of the project. It is quite helpful for
the sponsor as well as managers for managing project quality.
7 Risk management plan
7.1 Risk Management Strategies
Process Name Process Description
<Enter Process Name Here> <Describe Process Here>
Risk identification A brainstorming session is arranged before the initiation of the
project and a form is provided to the project team member’s so
that they can identify the risks.
Risk evaluation Proper information are gathered about and they are evaluated
so that proper idea about its mitigation can be identified
Risk mitigation Proper strategies are identified which are helpful in resolving
the risks and challenges
7.2 Risk Management Tools
Tool Name Tool Description
<Enter Tool Name Here> <Describe Tool Here>
Risk Status Report .Weekly status report is created so that the team members can
be able to know about the risks and challenges
Risk identification matrix Risk identification matrix is created for prioritizing risks as
well as challenges of the project.
Interviewing Interview of the team members are taken for knowing if they

are facing any risk while involving with the project.
7.3 Data Sources
Data Source Name Data Source Description
<Enter Data Source Name Here> <Describe Data Source Here>
Lessons Learned Database PMO maintained database is used that include information bout
risks
Documentation PMO maintained document is used for getting idea about how
to manage project.
7.4 Risk Categories
Categories Description
Budget shortfall Budget shortfall occurs when the budget of the project is not
tracked properly. In order to resolve this issue, it is necessary to
undertake earned value analysis.
Technical issue Technical issue occurs because after implementation, the
system is not tested. If the system is tested properly then the
chances of technical issue will get minimized.
Improper management If the project managers are not able to manage the project
effectively then it will be quite difficult to finish the project on
time. In order to avoid such issues,, it is necessary to hire
experienced project manager.
Schedule slippage Schedule slippage occurs if the schedule is not tracked
properly. For mitigating this issue, it is necessary to track
schedule on a regular basis.
7.5 Risk Probability and Impact
Item Probability (P) Impact (I) Total Risk Score
<List items here> <Enter a value between
0.1 – 1.0>
<Enter a value between
1 – 10>
<Multiply P x I>
Budget shortfall 0.8 9 7.2
Technical issue 0.7 9 6.3