Management of project scope, execution & control, change management
Case Study Project Management For Data Warehouse Development Project
Discuss about the case study Project Management for Data Warehouse Development Project.
Answer:
Project Integration Management
Project Charter
| Project Title | Establishing new data warehouse capability within the existing SST IT infrastructure | ||
| Project Location | Southern State TAFE | ||
| Brief Description of the Project | The project “Establishment of a new warehouse” aims to ensure the cross application production reporting capability. The undertaken project will encompass data warehouse provision, dashboard production and will provide reporting capability of the BI portal. | ||
| Prepared By | [Name of the Student] | ||
| Date | [Mention Date] | Version | 1.0 |
Scope Statement
Management of Project Scope, Execution & Control, Change Management
Scope of the Project
Following are the in scope of the project.
- To develop a multi-dimensional database of the warehouse based on Microsoft 2012 SQL Server Platform
- To develop a SharePoint site for using the Business Intelligence Portal
- To implement a data load and file transfer mechanism according to the SST infrastructure standards
- To develop a security model for BI portal and data warehouse that provide a conjunction along with Active Directory Groups
- To define the Key Performance Indicators (KPI) along with the Balance Score card
- To create a link between the BI Portal and SST intranet
- To train the SST staff for using the data warehouse and BI portal
Out of Scope
The following will be excluded in the project.
- To link any other system with the data warehouse
- To create the data extraction from any other systems
Project Execution and Control
Previously, an estimated task schedule was provided for the required project plan. However, after analysis with the actual project scenario and using latest technical equipments, several changes will be made in that table as follows:
[The ones marked in yellow have been changed]
Project Quality Management
| Task No | Task Name |
| 1 | Data Warehouse Development and Installation Project |
| 1.1 | Project Initiation Phase |
| 1.1.1 | Understanding the Requirement |
| 1.1.2 | Conducting feasibility test |
| 1.1.3 | Developing the project charter |
| 1.2 | Project Planning Phase |
| 1.2.1 | Develop project plan |
| 1.2.2 | Create project scheduling |
| 1.2.3 | Create resource allocation |
| 1.2.4 | Developing communication plan |
| 1.2.5 | Forming the team |
| 1.3 | Execution phase |
| 1.3.1 | Development of Data Warehouse |
| 1.3.1.1 | Develop the architecture |
| 1.3.1.2 | Collect the data from various sources |
| 1.3.1.3 | Develop the multidimensional cube of the warehouse |
| 1.3.1.4 | Develop the blueprint of hardware system |
| 1.3.1.5 | Develop the system design of Business Intelligence Portal |
| 1.3.1.6 | Design the User Interface of the system |
| 1.3.2 | Implementation phase |
| 1.3.2.1 | Hardware implementation |
| 1.3.2.2 | Designing the database |
| 1.3.2.3 | Software implementation of the data warehouse system |
| 1.3.2.4 | Development of the SharePoint site |
| 1.3.2.5 | Connecting the Business Intelligence Portal and data warehouse |
| 1.3.2.6 | Connecting the warehouse with another system |
| 1.3.3 | Deployment and Testing Phase |
| 1.3.3.1 | Testing the architecture design |
| 1.3.3.2 | Software testing |
| 1.3.3.3 | Data validation testing |
| 1.3.3.4 | Security testing |
| 1.3.3.5 | Unit testing |
| 1.3.3.6 | Risk identification and mitigation |
| 1.4 | closing phase |
| 1.4.1 | Creating a link to BI portal and SST intranet |
| 1.4.2 | Training of the staffs |
| 1.4.3 | Maintenance of the warehouse |
Control
Configuration Management
The systems will be configured according to the requirements once the project starts. Latest technical configurations and best possible equipments will be used for the project.
Human Resource Management
HR Planning
Organisational Chart/s
Resource Allocation – After analysing the project requirements, the manager will analyse financial statement and available resources. He will then allocate resources in each field of the project.
Employee Management – The project manager will delegate tasks to the employees according to their specializations. He has to ensure that every employee completes their jobs effectively and efficiently.
Preparation and Sending of Project Reports – The project team should prepare and send regular project reports to the manager so that he is able to track the progress of the project.
Resources
The estimated resources for this project are as follows:
| Task | Resource | Estimated Cost |
| Feasibility Test | Testing Softwares, Automated Analysis Tools | $1000 |
| Employee/Expert Recruitment | Specialized Experts | $15000 |
| Architecture Development | Architecture Softwares, Latest Computer Systems | $5000 + $20000 |
| Data Collection | Internet Tools | $1000 |
| Development of Blueprint, Intelligence Portal, User Interface | Design Softwares | $10000 |
| Implementation of Architecture, Hardware, Blueprints, Designs | Technically Upgraded Systems | $10000 |
| Testing (Software, Unit, Design, Security) | Testing Softwares | $2000 |
| Staff Training | Specialized Trainers | $10000 |
Project Communications Management
Suitable Medium/s & Channels
| Stakeholder | Communication Medium |
| Project Sponsors | Phone calls, formal mails, fax |
| Customers | Advertisements |
| Project Manager | Face-to-face, phone calls, formal mails |
| Internal Customer | Leaflets |
| SST Staffs | Face-to-face |
| Tester, Developers, Coder | Face-to-face |
| Training Team | Face-to-face (Interactive) |
| Insurance Company | Mails, fax |
| Security Team | Face-to-face |
| SST Administrator | Mails, chats |
Project Procurement Management 400
In this particular project, procurement is necessary for assimilating all the necessary resources and using them effectively to proceed with the project according to the plan. Procurement will be necessary for technical equipments and employees / personnel.
Scope
Procurement of resources (technical or human) will help the company in the upgradation as well as expansion.
Contract Commencement Date
Number of Contractors
Contract Terms
Funding
Estimated Contract Value
The estimated total contract value is $100,000.
- The contractor should not break the terms of the contract unless mutually agreed.
- The company holds the right to terminate any contract anytime.
- The contractor will not be responsible for any effect of the fault from the company’s part.
Outsourcing
In this project, there are several tasks that cannot be done by the internal employees of the organization only. Hence, outsourcing is needed in order to hire outsiders in this project. A simple outsourcing plan has been provided as below.
Planning Purchases and Acquisitions
A purchase plan for the company along with estimated budget is provided below.
| Asset / Requirement | Estimated Budget |
| Updated Hardware Systems | $100,000 |
| Latest Versions of Softwares | $50,000 |
| System Equipments | $20,000 |
| Others | $25,000 |
Bibliography
Marchewka, J.T., 2014. Information technology project management. John Wiley & Sons.
Menzies, T., Brady, A., Keung, J., Hihn, J., Williams, S., El-Rawas, O., Green, P. and Boehm, B., 2013. Learning project management decisions: a case study with case-based reasoning versus data farming. IEEE Transactions on Software Engineering, 39(12), pp.1698-1713.
Ryerson, M.S. and Woodburn, A., 2016. Manage Flight Demand or Build Airport Capacity?. ACCESS Magazine, 1(48).
Sen, A., Ramamurthy, K. and Sinha, A.P., 2012. A model of data warehousing process maturity. IEEE Transactions on Software Engineering,38(2), pp.336-353.
