Development Of Business Intelligence On Enterprise Resource Planning For Business Small And Medium

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.