Lessons from a Successful Data Warehousing Project Management

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.

Critical Success Factors of Enterprise Data Analytics and Visualization Ecosystem

“…DespitetheplethoraofstudiesonCSFsintheISliterature(e.g., Chen,Nakayama,Shou,& Charoen, 2018;Lech, 2013;Otra-Aho, 2017;Rahman, 2017;Stevenson & Starkweather, 2017;Wan&Saade,2018),itappearsthatnosystematicandrigorousstudiesexistforcharacterizinga collectivesetofCSFsforimplementingDAVecosysteminenterprises.Accordingtoasystematic review on the current state of DAV research by Sun, Wu, Liang, and Liu (2013), the constantly growingbodyofresearchonDAVtechnologieshasmostlyfocusedonaddressingtechnicalanddesign issues.However,theimplementationofDAVplatformsdoesnotonlysimplyentailthepurchaseof acombinationofsoftwareandhardware;rather,itisacomplexundertakingrequiringappropriate infrastructure,resources,andexecutivesupport (Basole,2014).AstudybyOlszak(2016)showedthat theorganizationalfactorsareconsideredtobemoreimportantthatthetechnologicalonesbecause theyareoutofthedirectcontrolofDAVdevelopers. Yeoh,WilliamandKoronios(2010)reported thatthetopmanagementsupportandcommitmentisthemostreferencedfactorintheextantresearch andpractice.Otheroftenreferencedfactorsarerelatedtotheenterprise'sstrategyandarchitecture requirements,user-centricmanagementandtraining,aswellasdataqualityandintegrity (Daradkeh, & Al-Dwairi, 2017).…”