Back to search

University of British Columbia

An OLAP-based PM prototype for cost control and manpower allocation

Abstract

dc:description

In the past decades great efforts have been made in applying Information Technology (IT) in the construction industry. The existing IT-integrated PM tools seem to be helpful to improve the efficiency of a single project control task, such as scheduling, but they lack a level of integration and coordination that can help manage construction projects from multiple perspectives in a unified manner. Although the OLAP (On Line Analytical Processing) technology has been widely used for business management, known as "Business Intelligence" (Bl), it has not been well adopted by the construction industry in the project management domain. The main objective of this thesis research is to test and evaluate whether the fast growing OLAP technology can facilitate project management in the construction industry, at least in some selected aspects. A Web-based, OLAP-integrated PM prototype was established to do the testing and evaluation. A data warehouse with multidimensional data structure was established in Microsoft Access, followed by the design and processing of OLAP cubes through Microsoft SQL Sever Analysis Services. The Microsoft Bl Portal was utilized as the front-end OLAP solution for multidimensional data representation and analysis. Two OLAP cubes were developed in the prototype for project cost control and manpower allocation analysis respectively, and the testing and evaluation was carried out by combining the OLAP features with several realistic project management scenarios. The thesis concludes that the OLAP technology does offer potential improvements to project management, but a great deal of future work is needed to extend the prototype to a well-rounded system. The benefits of this OLAP-base PM prototype, along with its shortcomings and limitations, are summarized at the end of the thesis. Also included is the discussion and suggestion of the future research work in this area.

Degree

thesis:*
Name thesis:degree_name
Master of Applied Science - MASc
Level thesis:degree_level
master's
Discipline thesis:degree_discipline
Civil Engineering
Grantor dc:publisher
University of British Columbia
Year dc:date
2005

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Nie, Hao (Howard)

Rights

dc:rights
Statement dc:rights
  • For non-commercial purposes only, such as research, private study and education. Additional conditions apply, see Terms of Use https://open.library.ubc.ca/terms_of_use.
Language dc:language
eng

Identifiers

dc:identifier.*
Handle dc:identifier
http://hdl.handle.net/2429/17240

Chain of custody

source
Harvested from
University of British Columbia
Base URL
circle.library.ubc.ca/oai/request
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
related terms
citation

Nie, Hao (Howard). An OLAP-based PM prototype for cost control and manpower allocation. master's thesis, University of British Columbia, 2005. http://hdl.handle.net/2429/17240