2,076
21
Essay, 3 pages (650 words)

Data warehouse gantt chart and pert chart

Running Head: DATA MART PROJECT Data Mart Project: Gantt Chart and Network Diagram [Put here] [Put here] Gantt Charts and Network Diagrams have been very simple, but effective tools for project management. With the development of software applications such as Microsoft Project, these tools are now in even more widespread use.
Data Mart Project:
Gantt Chart
The project plan in concern (Data Mart Project) uses a Gantt chart to organize the tasks. The task breakdown is done assuming a linear or waterfall development approach and it is a fairly complex breakdown. Work has been allocated on an hourly basis taking a total of 809 hours, which is approximately 100 working days. Since the 100 days are excluding the weekends, the elapsed duration, however, is different and the project spans over 4 calendar months starting from 03rd Sep 2007 to 01st Jan 2008.
The task assignments have overloaded certain resources. This is because, when setting predecessors, only adjacent tasks have been considered in certain cases. For example, some of the tasks to which the resource named Goran has been allocated on the same day are 75, 76, 109 and 110. Task 76 has a dependency on task 75 and task 110 has a dependency on task 109. But, because the same resource is involved, there is a dependency between tasks 76 and 109 as well. Ignoring dependencies such as these has resulted in that resource been overloaded. Hence tasks assignments need to be reworked.
The dependencies could be simplified if they were set using the summary task numbers instead of the detail task numbers. Task 170, ‘Test d_contactInfo table’ has tasks 109, 110 and 111 as predecessors all of which are sub tasks of task 108, the building of that table. Predecessor could be set as 108, thereby, simplifying dependency management.
There are several milestone tasks. They have been used to mark significant tasks which need to be completed before proceeding to later tasks. It is not prudent to deploy the system without validating it in the two migration environments. The validating activities, therefore, are marked as milestones and the Deploy task is set as dependent on the two validation tasks.
Network Diagram
The network diagram appears very complex because of the setting of the dependencies to the lower level tasks. This complexity can be reduced if the dependencies are set to the higher level summary tasks.
Usually, in MS Project, the tasks that lie on the critical path are highlighted in red color in both Gantt chart and network diagram views. The testing of the dimension and fact tables is critical for the success of the system. Therefore, those testing tasks appear on the critical path, in red color, along with the migration and deploy activities. However, the fact that the critical path does not extend to the beginning of the network diagram should be analyzed carefully. This could be due to a mistake in the setting of the predecessor activities.
This observation is based on the idea that the critical path of a project is the path with the longest duration. Hence, it represents the shortest time in which a project can be completed. (Schwalbe, 2000). What this implies is that, in a network diagram the critical path should extend from the beginning till the end of that network. The absence of this property in the critical path indicates the possibility of some missed dependencies.
Overall, it could be stated that the plan has been setup covering the full development cycle with a finer level of task breakdown. However, by doing the simplifications and validations mentioned above it is possible to ensure that the plan is manageable and traceable. (3 resources are shown as overloaded, which should be corrected by resource leveling. This, however, was not considered in detail as it is beyond the scope of what is requested.)
References
A Revamp of Student Admission Data Mart Project. mpp. 2007
Schwalbe, K. (2000). Information Technology Project Management. Thomson Course Technology.

Thank's for Your Vote!
Data warehouse gantt chart and pert chart. Page 1
Data warehouse gantt chart and pert chart. Page 2
Data warehouse gantt chart and pert chart. Page 3
Data warehouse gantt chart and pert chart. Page 4

This work, titled "Data warehouse gantt chart and pert chart" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Essay

References

AssignBuster. (2022) 'Data warehouse gantt chart and pert chart'. 20 January.

Reference

AssignBuster. (2022, January 20). Data warehouse gantt chart and pert chart. Retrieved from https://assignbuster.com/data-warehouse-gantt-chart-and-pert-chart/

References

AssignBuster. 2022. "Data warehouse gantt chart and pert chart." January 20, 2022. https://assignbuster.com/data-warehouse-gantt-chart-and-pert-chart/.

1. AssignBuster. "Data warehouse gantt chart and pert chart." January 20, 2022. https://assignbuster.com/data-warehouse-gantt-chart-and-pert-chart/.


Bibliography


AssignBuster. "Data warehouse gantt chart and pert chart." January 20, 2022. https://assignbuster.com/data-warehouse-gantt-chart-and-pert-chart/.

Work Cited

"Data warehouse gantt chart and pert chart." AssignBuster, 20 Jan. 2022, assignbuster.com/data-warehouse-gantt-chart-and-pert-chart/.

Get in Touch

Please, let us know if you have any ideas on improving Data warehouse gantt chart and pert chart, or our service. We will be happy to hear what you think: [email protected]