- Published: January 20, 2022
- Updated: January 20, 2022
- Level: College Admission
- Language: English
- Downloads: 34
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.