Flipping into Intelligence! A Business Intelligence Approach toward Analysis and Prediction of Operation Performance for Traditional Automatic Parts Wholesaler--A Case of Company H

• Main Authors: Young-XunShi, 施詠勛
• Other Authors: Sheng-Tun Li
• Format: Others
• Language: zh-TW
• Published: 2019
• Online Access: http://ndltd.ncl.edu.tw/handle/utm39w

碩士 === 國立成功大學 === 高階管理碩士在職專班(EMBA) === 107 === The spirit of business intelligence is to analyze the company's data based on analyses, insights, actions, measurements, etc. The business intelligence combines data from different sources to build data warehousing, and builds an online analysis system to help decision makers making decisions from massive and complex data. Through this methodology, companies can quickly identify valuable information to understand the customers’ buying behavior, the overall economic environment, and the impact of product evolution on invoicing management. With this information, companies can thus plan for future strategies, which can improve operational performance in a more accurate and more efficient way. This study establishes a business intelligence model to help H company, the traditional automatic control electronic parts company, making decisions more intelligently. Based on the proposed method and purpose, we firstly a collected H Company's daily transaction data from 2011 to 2017, and built a data warehouse and business intelligence model to provide relevant visual analysis. Furthermore, in order to provide decision makers with insight of the needs of customers, and then explore the current difficulties of Taiwan's traditional automatic control electronic parts wholesale and retail industry, the data dimensions, such as sales amount, total sales and gross profit according to various product categories were selected and analyzed. The new opportunities for its product evolution enable the company to have a more precise marketing strategy and more optimized invoicing management to achieve the goal of improving the company's operational performance, so that the company can maintain a competitive advantage in the industry.