A Business Intellligence Application Based on Enterprise Resource Planning System

• Main Authors: Neng Pin Tseng, 曾能彬
• Other Authors: Duen Ren Liu
• Format: Others
• Language: zh-TW
• Published: 2006
• Online Access: http://ndltd.ncl.edu.tw/handle/53756539346987033045

碩士 === 國立交通大學 === 管理學院碩士在職專班資訊管理組 === 94 === Although Enterprise Resource Planning (ERP) systems are good at capturing and storing data, the systems lack capabilities to analyze and report data due to some constraints. Firstly, ERP systems usually keep data about organizations’ current status. This makes it difficult to perform the trend analysis directly on ERP systems. Secondly, the ERP system is the backbone of data processing for many organizations. Performing many long queries at the same time directly on the ERP system may have a severe impact on the system performance. Thirdly, many ERP systems themselves do not provide the tools to create chart and interactive reports. Users usually have to download the raw data from ERP systems and build the chart reports on their own by using their desktop tools. Through building a business intelligence (BI) environment, we could conquer these constraints and make business analytics more flexible, responsive and convenient but with no or minimal impact on the performance of the ERP system. Through the use of data warehouse, this study successfully integrates ERP and non-ERP systems data sources. The case study shows that a cost effective BI solution could be built if available software resources are well utilized. The new BI application offers better data report quality and speed up significantly the creation of management reports.