Study of Data Warehousing and Data Mining in Internal Auditing on Group Company of Electronic Industry in Taiwan

近年來海內外企業舞弊的新聞層出不窮，面對公司不斷發生的舞弊案件，必須思考、研究如何改變傳統稽核方法與工具，消極目的在協助董監事評估內控制度是否持續有效，積極目的在於執行舞弊專案稽核，進而強化公司之控制環境，逐步達到事前分析舞弊行為徵兆之可能。 本研究擬就資料倉儲之導入，建構個案集團公司內部稽核專屬資料倉儲，及藉由資料採礦分析軟體運用分析研究，挖掘出有價值的稽核元件知識；進一步完善持續性稽核的運作環境；為本研究動機所在。本研究將以跨全球經營之個案電子業集團公司為研究對象，從資料倉儲及資料採礦導入工作執行過程及內部稽核作業實際程序及分析結果加以研究，以下列議題進行相關分析探討： 議題一、個案電子業集團公司資料倉儲導入過程探討及成果分析 議題二、個案電子業集團公司導入資料採礦於內部稽核作業之運用分析 本研究較傳統單一議題或產業研究更具廣度，進而對更多在多面向內控舞弊查核議題上有興趣更深入探討的研究者，提供一個參考意見與研究方向。而以個案集團公司導入資料倉儲及資料採礦對內控循環作業中所涉及之集團內常見舞弊高風險交易作業(如：圍標、拆單等)的成果分析，廣泛運用於集團眾多事業群處及作業系統資料庫，是為本研究較為特殊之貢獻。 本個案研究係採取實地稽核作業實施方式，驗證資料倉儲及資料採礦導入分析結果。並歸納出多面向內控循環作業之舞弊查核、形成以風險評估為基礎之稽核計畫、專案舞弊查核結果再強化資料倉儲及資料採礦元件技術等研究結論。There is a competitive circumstance for all companies to face how to survive in the world, it includes the opening the marketing, competing with others, preventing from the internal fraud …and so on. Here is a study for the board of directors to focus on how to execute the internal auditing program to make everything perfect under control. To review lots of the prevailing fraud cases in past, a company must have its own opinions to adjust the suitable auditing program and to adopt the accurate detecting processing in order to strengthen the controlling power and narrow down the risk in advance. This study is how to establish the data input and then retrieve the useful information for further analysis based on the mega data bank in the prevailing system of one of public electronic companies in Taiwan. A company engages in the research and development of products, they can, pursuant to their need, add the research and development circle, including the control operation for the basic research, the design of products, the research of technology, the making and testing of products, the research/ development information, and the recording and storage of information in system. There are two main factor issues for further discussion and break it down as the following--- (1) The investigation on the practical data input and the analysis by the result (2) How to retrieve the data for the internal auditing purposes This subject study is different from the same case of the past in the electronic industry in Taiwan. If you scrutinize the details of this report, you will find out lots of fraud cases in the company and the accurate auditing program taken for each of them. There are very interesting and ambitious directions for the public people to consider and investigate in order to fit it in their own industries in future. There are lots of frauds happened in the progressing of the global biding or local biding. You are able to detect the fraud by the internal control points through the data analysis from the prevailing computer system. The result in group biding or separating biding, those activities are existed under controlled by the certain people for benefit themselves. This is a true case happened in Taiwan. The internal auditor of this company would adopt the appropriate auditing progressing by verifying the data warehousing and data mining. A service enterprise’s internal audit unit shall, based on the results of the fraud detecting, the risk assessment, to renew the auditing plan stipulated and designed by the subjected factor into the book