系統識別號 U0026-1208201413053000
論文名稱(中文) 商業智慧之研究-以國內某化工公司為例
論文名稱(英文) A Study of Business Intelligence – Using the Chemical Company as an Example
校院名稱 成功大學
系所名稱(中) 工業與資訊管理學系碩士在職專班
系所名稱(英) Department of Industrial and Information Management (on the job class)
學年度 102
學期 2
出版年 103
研究生(中文) 王瀅竣
研究生(英文) Vince Wang
電子信箱 luvbaby0129@gmail.com
學號 R37011011
學位類別 碩士
語文別 英文
論文頁數 53頁
口試委員 指導教授-李昇暾
中文關鍵字 風險管理  商業智慧  線上分析處理  資料倉儲 
英文關鍵字 Business intelligence  Cause of failure analysis  Risk management  OLAP 
中文摘要 在複雜的商業流程中風險管理是個關鍵且複雜的工作,尤其當流程是變化快速的。因此,在企業裡如何達到預防勝於治療是十分關鍵的。現今,有許多描述和分析流程的工具已經存在且有效應用在各領域,以解決流程動態變化的問題。
風險管理不僅為一種可定性的描述,如何有效利用以往工廠執行各項EHS (Environment Health and Safety)活動的成果,將大量的結構與非結構資料有效地管理與分析,再根據分析後的新見解做基礎,進而做出改變與改善,也就是利用既有的資料進行統計分析,進而提供營運決策參考。
英文摘要 It is not a simple task to depict cause and effect relations in complex business processes, especially when they are rapidly changing. However, this task is critical to achieve “prevention is better than cure” in modern business environments. Recently, a large number of tools used to describe and analysze the causes and effects in these business processes have been developed to facilitate this effort that also have been used effectively in various fields.
Risk management is not only a qualitative description of how to effectively use a factory to implement previous EHS (Environment Health and Safety) activity results, but it also allows a large number of structured and unstructured reports to be effectively managed and analyzed. Then, according to new insights, with the analysis as a foundation, changes and improvements can be made that make use of existing data for statistical analysis and provide operational decision-making capability.
Currently, most of the existing systems in enterprises are unable to meet user demand for a large number of real-time computing and multi-dimensional data statistical analysis, and a wide variety of complex and routine reports are still highly dependent on IT staff for development and maintenance that often fail to meet the requirement of real-time information and to provide relevant statistical information retrieval needs. They are often also limited by the level of expertise of the user.
In this study, we use business intelligence technology to analyze large amounts of both structured and unstructured reports in order for decision-makers at all levels to get real-time feedback and to make more effective use of the data accumulated in the operation, thus providing various analyses and operational management of a number of major decisions and building a predictive statistical model. We plan to establish an "EHS performance Management system" through a comprehensive view and analysis of historical information related to EHS activities in order to evaluate the strengths and weaknesses related to environmental risk management and to further develop improvements in efficient use of resources under conditions of overall environmental risk in the area of online energy management development, thus enhancing corporate performance.
Therefore, this study uses cause of failure analysis, data warehousing and business intelligence to overcome these problems. The experimental results show that using these methods after adjustment in the reason attribution mode, allow analysts to obtain information more quickly, and a preventive effect can be achieved depending on the cause topology.
論文目次 摘 要 I
Abstract II
誌 謝 IV
Table of Contents V
List of Tables VIII
List of Figures IX
Chapter 1 Introduction 1
1.1 Research background and motivations 1
1.2 Research objectives 2
1.3 The process of the research 5
Chapter 2 Literature review 6
2.1 The Campbell award 6
2.2 The failure theory 6
2.2.1 Failure definition and management 7
2.2.2 Cause of failure analysis 8
2.2.3 Structure of failure knowledge database 10
2.3 Business reporting and business intelligence 11
2.3.1 The business routine report 12
2.3.2 The report in BI system 12
2.3.3 The architecture of BI 13
2.3.4 Document analysis and classification 15
2.3.5 Data warehouse 16
2.3.6 On-line analytical processing 18
Chapter 3 Research method 21
3.1 Management and decision-making support 21
3.1.1 Solve business and operational needs 21
3.1.2 Relevant information introduction 23
3.1.3 Format instructions and presentation 24
3.1.4 KPI selection and setting 24
3.2 Cause of Failure Analysis 25
3.2.1 Documents Collection and Generation 25
3.2.2 Failure Understandings and Failure Reverse Inference 25
3.2.3 Failure Factor Fictionalized and Normalization 26
3.2.4 Failure knowledge databases Construction 27
3.3 Business intelligence system implement 27
3.3.1 Documents collection and generation 28
3.3.2 Data warehouse 28
3.3.3 On-line analysis processing 29
3.4 The process of design of BI system 29
3.4.1 Establish core competence issues 30
3.4.2 Selection of business processes 30
3.4.3 Determine the granularity. 30
3.4.4 Choose the dimension facets and schema construction 31
3.4.5 Establish key metrics 34
3.4.6 Data warehouse bus 35
Chapter 4 Experiment and analysis 35
4.1 The result of system process 36
4.1.1 Real-time and ad-hoc query 36
4.1.2 Visualizing chart and graph interface output 37
4.1.3 Business dashboard and KPI output 41
4.2 System limits description 43
4.3 System implement assessment 44
Chapter 5 Conclusion and future work 47
5.1 Conclusions and limitations 47
5.1.1 Conclusions 47
5.1.2 Limitations of the study 48
5.2 Management implications 48
5.2.1 Multi-dimensional analysis and systematic real-time reporting 48
5.2.2 The KPI presented 49
5.2.3 Business continuity management and plan 49
5.3 Future work 49
References 51
參考文獻 Anand, N. (2014). "ETL and its impact on Business Intelligence." International Journal of Scientific and Research Publications Volume 4, Issue 2, February 2014 ISSN 2250-3153
Armes, A. (2006). "RECOGNIZING A PARADIGM SHIFT-Alcan Inc. and DynMcDermott Petroleum Operations Co. earn the 2006 Robert W. Campbell Award." Safety & health 174(6): 46.
Ballou, D. P. and G. K. Tayi (1999). "Enhancing data quality in data warehouse environments." Commun. ACM 42(1): 73-78.
Bukowski, T. J. (2012). "The business of safety-2011 Robert W. Campbell Award winner empowers employees to adopt safety culture." SH-Safety and Health-National Safety Council 185(1): 46.
Chaudhuri, S. and U. Dayal (1997). "An overview of data warehousing and OLAP technology." ACM Sigmod record 26(1): 65-74.
Codd, E. F., S. B. Codd and C. T. Salley (1993). "Providing OLAP (on-line analytical processing) to user-analysts: An IT mandate." Codd and Date 32.
Cover, T. and P. Hart (1967). "Nearest neighbor pattern classification." Information Theory, IEEE Transactions on 13(1): 21-27.
Feinerer, I. (2008). "Text mining infrastructure in R." Journal of statistical software 25(5): 1.
Goyal, R. and S. Kugan (2012). Hazard and Operability Studies (HAZOP)--Best Practices Adopted by BAPCO (Bahrain Petroleum Company). SPE Middle East Health Safety Security and Environment Conference and Exhibition, Society of Petroleum Engineers.
Hall, A., O. Bachmann, R. Büssow, S. Gănceanu and M. Nunkesser (2012). "Processing a trillion cells per mouse click." Proceedings of the VLDB Endowment 5(11): 1436-1446.
Inmon, W. H. (1996). "The data warehouse and data mining." Commun. ACM 39(11): 49-50.
Inmon, W. H. (2005). Building the data warehouse, John wiley & sons.
Khalid, K., H. M. Salim, S.-P. Loke and K. Khalid (2011). "DEMOGRAPHIC PROFILING ON JOB SATISFACTION IN MALAYSIAN UTILITY SECTOR." International Journal of Academic Research 3(4): 192-198.
Kimball, R. (1996). "The data warehouse toolkit: practical techniques for building dimensional data warehouse." John Willey & Sons.
Lönnqvist, A. (2006). "The Measurement of Business Intelligence." Information systems management 23(1): 32-40.
Langfelder, P. (2008). "Defining clusters from a hierarchical cluster tree: the Dynamic Tree Cut package for R." Bioinformatics (Oxford, England) 24(5): 719-720.
McDonald, Diane.McNicoll, Iain.Weir, George.Reimer, Torsten.Redfearn, Judy.Jacobs, Neil.Bruce and Rachel. (2012). "The Value and Benefits of Text Mining." JISC Digital Infrastructure.
Moss, L. T. (2003). "Nontechnical Infrastructure of BI Applications." DM Review 13(1): 42-45.
Murtagh, F. (1983). "A survey of recent advances in hierarchical clustering algorithms." Computer Journal, The 26(4): 354.
Negash, S. (2004). "Business intelligence." Communications of the Association for Information Systems 13(1): 177.
Olszak, C. M., E. Ziemba and A. Koohang (2006). "Business Intelligence Systems in the Holistic Infrastructure Development Supporting Decision-Making in Organisations." Interdisciplinary Journal of Information, Knowledge & Management 1.
Poe, V., S. Brobst and P. Klauer (1997). Building a Data Warehouse for Decision Support, Prentice-Hall, Inc.
Pujari, P. and J. B. Gupta (2012). "Exploiting data mining techniques for improving the efficiency of time series data using spss-clementine." Asst. Professor, Department of Computer science & IT, Guru Ghasidas, Central University, India. www. researchersworld. com 3(2): 3.
Sahoo, N., J. Callan, R. Krishnan, G. Duncan and R. Padman (2006). Incremental hierarchical clustering of text documents. Proceedings of the 15th ACM international conference on Information and knowledge management. Arlington, Virginia, USA, ACM: 357-366.
Seal, W. and R. Mattimoe "Controlling strategy through dialectical management." Management Accounting Research(0).
Usama Fayyad, G. P.-S., Padhraic Smyth (1996). Advances in Knowledge Discovery and Data Mining. American Association for Artificial Intelligence Menlo Park, CA, USA, The MIT Press.
Watson, H. J. and P. Gray (1998). Decision Support in the Data Warehouse, Prentice Hall Professional Technical Reference.
Watson, H. J. and B. H. Wixom (2007). "The Current State of Business Intelligence." Computer 40(9): 96-99.
Xiangzhu, G., S. Murugesan and B. Lo (2005). Extraction of keyterms by simple text mining for business information retrieval. e-Business Engineering, 2005. ICEBE 2005. IEEE International Conference on.
Zhang, D., C. Zhai and J. Han (2012). "MiTexCube: MicroTextCluster cube for online analysis of text cells and its applications." Statistical Analysis and Data Mining.
Zhang, D., C. Zhai, J. Han, A. Srivastava and N. Oza (2009). "Topic modeling for OLAP on multidimensional text databases: topic cube and its applications." Statistical Analysis and Data Mining 2(5-6): 378-395.
  • 同意授權校內瀏覽/列印電子全文服務,於2024-12-31起公開。

  • 如您有疑問,請聯絡圖書館