Development Of Business Intelligence On Enterprise Resource Planning For Business Small And Medium
DOI:
https://doi.org/10.35134/ekobistek.v8i2.37Keywords:
business intelligence, data warehouse, ERP, SMEs, automotive manufacturing, ETLAbstract
Small and Medium Enterprises (SMEs) are business sectors that are the foundation of the real sector of the
Indonesian economy.SMEs are currently experiencing considerable challenges both from the internal in the
form of quality and continuity products and external challenges since the enactment of the ASEAN-China
Free Trade Agreement (ACFTA), where automotive manufacturing products from China enter the
Indonesian market freely. In the competition open and competitive like this, the use of information
technology is an urgent need for SMEs to be able to compete and increase business capacity. Use of
Enterprise Resource Planning (ERP) in the manufacturing sector SMEs, is an information system that
supports daily transactions and operations in managing company resources in an integrated manner,
including: funds, people, machinery, spare parts, time, material, capacity, even method. Cross-functional
integration capabilities in ERP provide overview of the flow of information on people, goods and services in
real time. But a manager companies need not only transactional information, but also require fast data easy
to understand to support decision making. This study aims to develop an intelligence business application
that is service-reusable for integration, analysis and monitoring the performance of an SME in the
manufacturing industry sector. Application development starts with do analysis on transactional data, and do
the design of analytic applications provide a decision-making process with time-based access from various
data sources,use ETL (Extract-Transform-Load) and graphical data display. The final results of this study
describe the relationship between BI processes and modules on ERP.
References
Botta-Genoulaz, V. & Millet, P.-A. (2006): An Investigation into the Use of ERP Systems in the
Service Sector, International Journal of Production Economics, 99, pp. 202-221
Esteves, J., and Pastor, J.: Enterprise Resource Planning Systems Research: An Annotated
Bibliography, Communication of the Association for Information Systems (7:8) 2001.
Inmon, W.H. 2005: Building the Data Warehouse, 4th edition, John Wiley & Sons Inc. USA.
K. Kumar, J. Van Hillegersberg: ERP experiences and evolution, in Communications of the ACM,
vol. 43, no. 4, 2000, pp. 23.
Kusnawi 2010: Multidimensional Data Warehouse dengan menggunakan MySQL,
http://portalgaruda.org (April 2014)
Downloads
Published
How to Cite
Issue
Section
License