Lessons from a Successful Data Warehousing Project Management

Author(s):  
Nayem Rahman

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.

Author(s):  
Yajun Zeng ◽  
Yujie Lu ◽  
Miroslaw Skibniewski

Enterprise Resource Planning (ERP) systems are configurable enterprise-wide information system packages that integrate information and information-based processes within and across functional areas in an organization. They have been widely adopted in many organizations and accepted as a de facto industry standard for the replacement of legacy systems. This paper analyzes and presents the costs and benefits of ERP systems for project-based industries, which  have lagged behind other major industries in adopting ERP systems due to their project-centric nature and the high stakes involved in ERP implementation. The challenges during the process of ERP implementations are also identified as part of the effort to understand the implied costs of an ERP system. The evidence of the costs and benefits are drawn from previous studies and the analysis of the prevailing working practices in project-based firms. The classification of the costs and benefits constitutes a cost and benefit taxonomy which can be used to enable executives in project-based firms to make informed decisions on their ERP system investments.


Author(s):  
Francisco Chia Cua ◽  
Steve Reames

This paper discusses the critical use and lessons learned from the single case model while implementing an Enterprise Resource Planning (ERP) system at a leading university. The researcher examined one university’s business ERP in the deployment of a new enterprise system, a complex phenomenon which took place over several stages and involved different players at each stage. The paper discusses the case system inclusive of the grounded case theory, diffusion of innovation theory, innovation-process theory and their application during the ERP system implementation.


Author(s):  
Annika Andersson

Research in the integration of technology and content knowledge using problem-based learning (PBL) is a challenge. Thus, the aim of this chapter is to describe experiences and lessons learned from integrating ERP-systems (enterprise resource planning systems) into economic topics course using PBL and cases created for the integration of technology and content knowledge in a business school setting. The mission was to develop the economic students’ analyzing abilities using a ERP-system as a pedagogical tool. A summary table describes how problem-based learning and cases were developed and used within collaboration among universities, colleagues, businesses, and students to accomplish integration of both technology and content knowledge. The experience was that students developed abilities to analyze technology from both theory and a deeper understanding of theory by analyzing technology. The lessons learned were that integration of technology and content knowledge using problem based learning and cases is a never-ending cooperative and learning process.


2013 ◽  
pp. 901-913
Author(s):  
Dana L. Dalton

This case study describes the events from 2003 to the present surrounding the implementation of a relational student information Enterprise Resource Planning (ERP) system. The introduction and implementation of an ERP to a campus that previously engaged separate stand-alone administrative computer components is indeed a cultural and philosophical shift. Campus leaders must not discount the importance and to some degree, acceptance, of these shifts. Multiple factors have to come together to make the ERP a successful venture. We found that continuous communication and a sense of ownership aided the cultural shift. At the beginning of any institution-wide project, all the stakeholders should have a seat at the table and a role in the decision-making processes. As in any undertaking, best practices and the lessons learned served as both formative and summative types of evaluation in this experience. This case is not meant to serve as a “how to” guide, but a narrative of prominent issues that other institutions may find helpful if a conversion is in their future.


2013 ◽  
pp. 581-595
Author(s):  
Annika Andersson

Research in the integration of technology and content knowledge using problem-based learning (PBL) is a challenge. Thus, the aim of this chapter is to describe experiences and lessons learned from integrating ERP-systems (enterprise resource planning systems) into economic topics course using PBL and cases created for the integration of technology and content knowledge in a business school setting. The mission was to develop the economic students’ analyzing abilities using a ERP-system as a pedagogical tool. A summary table describes how problem-based learning and cases were developed and used within collaboration among universities, colleagues, businesses, and students to accomplish integration of both technology and content knowledge. The experience was that students developed abilities to analyze technology from both theory and a deeper understanding of theory by analyzing technology. The lessons learned were that integration of technology and content knowledge using problem based learning and cases is a never-ending cooperative and learning process.


2021 ◽  
Vol 5 (01) ◽  
pp. 55-64
Author(s):  
Dhuhadmya Anggiya Kirana ◽  
Muhardi Saputra ◽  
Warih Puspitasari

PT XYZ is one of the mining companies in Indonesia that has many subsidiaries. From user interviews, there’s a problem in carrying out daily transactions in the procurement process. There is no integration between departments when using existing applications, lots of inappropriate data, and some documents with missing files. Thus causing data not on time and working time. The analysis was carried out using a conceptual model to see the problems and needs in PT XYZ. ERP system needs to be implemented, coordinating the company’s business processes and reset the company’s infrastructure and standardization. The ERP system in the material management module will be implemented using the ASAP method because this method is tailored to the company. The ASAP method can describe implementation activities to support project management and data migration faster than other implementation methods.


Author(s):  
Dana L. Dalton

This case study describes the events from 2003 to the present surrounding the implementation of a relational student information Enterprise Resource Planning (ERP) system. The introduction and implementation of an ERP to a campus that previously engaged separate stand-alone administrative computer components is indeed a cultural and philosophical shift. Campus leaders must not discount the importance and to some degree, acceptance, of these shifts. Multiple factors have to come together to make the ERP a successful venture. We found that continuous communication and a sense of ownership aided the cultural shift. At the beginning of any institution-wide project, all the stakeholders should have a seat at the table and a role in the decision-making processes. As in any undertaking, best practices and the lessons learned served as both formative and summative types of evaluation in this experience. This case is not meant to serve as a “how to” guide, but a narrative of prominent issues that other institutions may find helpful if a conversion is in their future.


Author(s):  
Roni Kurniawan

Information technology improvement is one of drivers that changes in computer-based accounting information system called Enterprise Resource Planning (ERP) System. The advantages of ERP system leads companies decide to eventually implement the system. The objective of this study is to comprehend the impacts of some variables such as end-user role, procedure, data, hardware and project management to the success of ERP implementation, both partially and simultantly.This research implements descriptive analysis method where thedata are collected by questionare on a survey. Population is a company of oil-palm industry located in Pekanbaru - Riau which implements ERP system for its operational. Data are proccessed using SPSS version 17.00 and hypothesis testing is performed using statistic tests, which are validation test, reliability test and double regression test. The result and discussion of this study in general shows that end-user role, procedure, data, hardware and project management variables have positive correlation and influence to the success of ERP implementation, both partially and simultantly.


2011 ◽  
Vol 338 ◽  
pp. 152-155 ◽  
Author(s):  
Abdoulmohammad Gholamzadeh Chofreh ◽  
Feybi Ariani Goni ◽  
Mahdieh Gholamzadeh Jofreh

Enterprise Resource Planning (ERP) system is an advanced manufacturing system that enables the integration of transactions-oriented data and business functions throughout an enterprise. ERP system holds the potential of greatly enhancing organizational performance and establishing competitive advantage. ERP project team can reduce their implementation costs by having a well thought out ERP implementation process. This research examines the ERP implementation process from the project management based perspective. The theoretical framework is developed to specify the ERP implementation process, which is categorized into five phases in project life cycle: initiating, planning, executing, controlling and closing. The research adopts the iterative triangulation as a methodology to establish this study, and one large company in Iran has been chosen by researchers to examine the proposed framework.


2017 ◽  
Vol 13 (3) ◽  
pp. 23-35 ◽  
Author(s):  
Ritesh Chugh ◽  
Subhash C. Sharma ◽  
Andrés Cabrera

Successful Enterprise Resource Planning (ERP) implementations are a boon for organisations. However, there have been many instances of failed ERP implementations globally resulting in millions of wasted dollars. It is vital to learn from past ERP implementations so that such expensive mistakes are not recurrent. This qualitative exploratory case study aims to explore and document the lessons learned from ERP implementations in an Australian global natural resources company to mitigate such problems in the future. A single case study was conducted with the aim to understand experiences from different sites of the company that have already undergone proprietary ERP system implementation. Data was collected through interviews of key participants who were involved in the implementation. Analysis of the interviews has resulted in comprehensive lessons learned around the project focus areas. Finally, ten tips, divided in 4 categories i.e. People, Strategy, Technology and Management have been identified, to guide future ERP implementations and increase chances of success.


Sign in / Sign up

Export Citation Format

Share Document