1Introduction 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.1Project 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:
2.3 Project approach
The approaches that are utilized in the project include:
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:
2.6 Assumptions
The assumptions related with the project are as follows:
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:
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.
|
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:
3.3 Scope Statement
In-Scope
Out scope
Work Breakdown Structure Developmen
1.1 Scope Change Management Process
The changes within the project scope can be identified, addressed, communicated as well as documented with the help of following:
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:
1.2 Plan Modification Rules
The plan modification rules include:
2chedule management plan
2.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 |
3 Cost management plan
3.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 administrator, Resource manager |
$ 2,240.00 |
|
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 |
3.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.
4Quality management plan
4.1Quality 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. |
4.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. |
The lists of tools that are helpful in managing the quality of the project are reflected below:
4.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.
5 Risk management plan
5.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 |
5.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. |
5.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. |
5.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. |
5.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 |
|
Improper management |
0.7 |
8 |
5.6 |
|
Schedule slippage |
0.7 |
8 |
5.6 |
6.1.1Project Team
|
Name |
Role |
Phone Number |
Email Address |
|
<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 engineer |
<Please Fill> |
<Please Fill> |
|
<Please Fill> |
Network architect |
<Please Fill> |
<Please Fill> |
|
<Please Fill> |
Application engineer |
<Please Fill> |
<Please Fill> |
|
<Please Fill> |
Programmer |
<Please Fill> |
<Please Fill> |
.1.1 Key Stakeholders
|
Key Stakeholders |
|||
|
<Stakeholder 1> |
<Stakeholder 2> |
||
|
Role on Project |
Project Sponsor |
Supplier |
Project manager |
|
Organization |
VP of IT |
VP of IT |
VP of IT |
|
Phone Number(s) |
|||
|
Email Address |
|||
|
Unique Facts |
Prefers the use of email for project documents |
Utilizes resource list for supplying resources |
Utilizes progress report for updating team members about project progress |
|
Suggestions for managing communications |
Keep informed of all project progress |
Keep information about the quality of the resources |
Guide the team members so that they can perform well |
1.2 Resource Requirements1.1Resource Assignment
|
Task |
Project manager |
Project planner |
Resource manager |
Database administrator |
Network system engineer |
Network architect |
Programmer |
|||||
|
KPI’s excel worksheet is created by BPC, SST |
I |
R, A |
||||||||||
|
Setting manual insert rules |
I |
C |
R, A |
|||||||||
|
Database is created by BPC |
I |
A, R |
C |
|||||||||
|
Data validation is set up BPC |
I |
A, R |
C |
|||||||||
|
BPC develops decreases ETL process abase validation rules |
C |
A, R |
I |
|||||||||
|
BPC creates ETL process to load files from oracle financials |
I |
C |
A, R |
|||||||||
|
File mechanism is created by BBC, SST |
I |
C |
A, R |
|||||||||
|
BPC creates KPI maintenance screen |
C |
A, R |
I |
|||||||||
|
BPC creates performance point screen |
C |
A, R |
I |
|||||||||
|
Security systems |
C |
I |
A, R |
|||||||||
|
SST sets active directory group |
I |
C |
R, A |
|||||||||
|
. |
||||||||||||
2Communication plan
2.1 Stakeholder Analysis
|
<Please Fill> |
<Please fill> |
<Please fill> |
|
|
Role on Project |
Database administrator |
Project Sponsor |
Project manager |
|
Organization |
VP of IT |
VP of IT |
VP of IT |
|
Contact Information |
<Please Fill> |
<Please Fill> |
<Please Fill> |
|
Unique Facts |
Stores information properly within the database of the organization. |
Prefers use of email for project documents |
Manages the project effectively so that it get finished within time |
|
Level of Interest |
High |
High |
High |
|
Level of Influence |
Medium |
High |
High |
|
Suggestions for managing relationships |
Keep informed if any type of technical issues occur |
Keep informed about the progress of the project |
Guiding the team members of the project |
2.2 Project Reports
|
Data Needed |
Frequency of Collection |
Responsible Party for Data Collection & Analysis |
Report Media & Format |
Responsible Party for Distributing Report |
|
|
Schedule Status |
Tracking project schedule |
Weekly |
Project team member |
Schedule status Form |
Project manager |
|
Quality status |
Tracking quality of the resources |
Weekly |
Quality analyst |
Quality status form |
Project manager |
2.3 Project Meetings
|
Purpose |
Frequency |
Attendees |
Reporting Requirements |
|
|
Status Review Meeting |
Update on project status |
Weekly |
Project team members, sponsor and other stakeholder |
Meeting Minutes |
|
Monthly status meeting |
Update on the challenges that the team is facing while working with the project |
Monthly |
Project manager and project planner |
Status report |
|
Kick off meeting |
Update on the objectives as well as goals of the project. |
Once |
Project team member |
Meeting minutes |
2.4 Project Information Accessibilit
The information related with the project is mainly stored within the following places:
Website: Website act as one of the centralized location for for storing project documents and oter templates
Database: All the other information related with the business is stored within the database of the organization
3Communications Summary
|
Stakeholder |
Type |
Communication Medium |
Frequency |
Responsible Party |
|
<Please Fill> |
Weekly status report |
Email, face to face |
Every Monday |
Project manager |
|
<Please Fill> |
Kick off report |
Face to face, Email |
Once before the initiation of the project |
Project manager |
|
<Please Fill> |
Technical review report |
Email, conference |
Whenever needed |
Technical engineer |
|
<Please Fill> |
Monthly project performance report |
|
Last day of the month |
Project manager |
Badewi, A., 2016. The impact of project management (PM) and benefits management (BM) practices on project success: Towards developing a project benefits governance framework. International Journal of Project Management, 34(4), pp.761-778.
Calvo-Mora, A., Navarro-García, A. and Periañez-Cristobal, R., 2015. Project to improve knowledge management and key business results through the EFQM excellence model. International Journal of Project Management, 33(8), pp.1638-1651.
Chih, Y.Y. and Zwikael, O., 2015. Project benefit management: A conceptual framework of target benefit formulation. International Journal of Project Management, 33(2), pp.352-362.
Conforto, E.C., Salum, F., Amaral, D.C., da Silva, S.L. and de Almeida, L.F.M., 2014. Can agile project management be adopted by industries other than software development?. Project Management Journal, 45(3), pp.21-34.
Costantino, F., Di Gravio, G. and Nonino, F., 2015. Project selection in project portfolio management: An artificial neural network model based on critical success factors. International Journal of Project Management, 33(8), pp.1744-1754.
Heldman, K., 2018. PMP: project management professional exam study guide. John Wiley & Sons.
Joslin, R. and Müller, R., 2015. Relationships between a project management methodology and project success in different project governance contexts. International Journal of Project Management, 33(6), pp.1377-1392.
Kucharska, W. and Kowalczyk, R., 2016. Trust, Collaborative Culture and Tacit Knowledge Sharing in Project Management–a Relationship Model.
Marcelino-Sádaba, S., Pérez-Ezcurdia, A., Lazcano, A.M.E. and Villanueva, P., 2014. Project risk management methodology for small firms. International journal of project management, 32(2), pp.327-340.
Marcelino-Sádaba, S., González-Jaen, L.F. and Pérez-Ezcurdia, A., 2015. Using project management as a way to sustainability. From a comprehensive review to a framework definition. Journal of cleaner production, 99, pp.1-16.
Mir, F.A. and Pinnington, A.H., 2014. Exploring the value of project management: linking project management performance and project success. International journal of project management, 32(2), pp.202-217.
Riol, H. and Thuillier, D., 2015. Project management for academic research projects: balancing structure and flexibility. International Journal of Project Organisation and Management, 7(3), pp.251-269.
Svejvig, P. and Andersen, P., 2015. Rethinking project management: A structured literature review with a critical look at the brave new world. International Journal of Project Management, 33(2), pp.278-290.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download