Lessons from a Successful Data Warehousing Project Management

Published In

International Journal of Information Technology Project Management

Document Type

Citation

Publication Date

10-1-2017

Abstract

This article provides an overview of project management aspects of a data warehouse application implementation. More specifically, the article discusses the project's implementation, challenges faced, and lessons learned. The project was initiated with an objective to redesign the procurement data pipeline of a data warehouse. The data flows from enterprise resource planning ERP system to enterprise data warehouse EDW to reporting environments. This project was challenged to deliver more quickly to the consumers with improved report performance, and reduced total cost of ownership TCO in EDW and data latency. Strategies of this project include providing continuous business value, and adopt new technologies in data extraction, transformation and loading. The project's strategy was also to implement it using some of the agile principles. The project team accomplished twice the scope of previous project in the same duration with a relatively smaller team. It also achieved improved quality of the products, and increased customer satisfaction by improving the reports' response time for management.

DOI

10.4018/IJITPM.2017100103

Persistent Identifier

https://archives.pdx.edu/ds/psu/25982

Share

COinS