摘要(英) |
In this study, a thin film transistor liquid crystal display (TFT-LCD) manufacturer as the case company, we applied Lean Six Sigma approach—define, measure, analyze, improve, control (DMAIC), to improve the data quality of its data warehouse. The purpose is to improve the accuracy and integrity of the data warehouse, in order to enhance customer satisfaction. DMAIC approach is to collect customer voices, to define the problem, and to identify the critical-to-quality characteristics affecting customer satisfaction. We used the detailed data processing flowchart of data warehousing to identify the data quality problems for further analysis. The cause-effect diagram is then employed to identify possible causes and their verification. With respect to real causes, we developed and implemented action plans to improve data accuracy and integrity. Finally, monitoring mechanisms are established in order to maintain the effectiveness of the lean six sigma approach. We found that DMAIC can effectively and quickly improve data quality of data warehouse since its implementation in March 2012. The average data accuracy of the data warehouse increased from 50% to 81%, and the average data integrity went up from 74% to 90% in 2.5 months.
|
參考文獻 |
【英文文獻】
Berndt, D. J., Fisher, J. W., Hevner, A. R., and Studnicki, J., 2001, “Healthcare Data
Warehousing and Quality Assurance,” IEEE Computer, 34(12):56-65.
Bhuiyan, N., Baghel, A. and Wilson, J., 2006, “A sustainable continuous improvement
methodology at an aerospace company,” International Journal of Productivity and
Performance Management, 55(8):671–687.
Inmon, W. H., 2005, Building the Data Warehouse, 4th ed., New York, John Wiley & Sons.
Paulraj, P., 2001, Data Warehousing Fundamentals, New York, John Wiley & Sons.
Watson, H. J., Annino, D. A., Wixom, B. H., Avery, K. L., and Rutherford, M., 2001, “Current
Practices in Data Warehousing,” Information Systems Management, 18(1):47-55.
【中文文獻】.
丁惠民譯,2004,六標準差設計立即上手,台北市,麥格羅希爾。Brue, G. and Launsby, R.,2003,Design for Six Sigma. New York, London : McGraw-Hill.
丁惠民譯,2005,精實六標差工具手冊,台北市,美商麥格羅。George, M. L., Rowlands, D., Price, M. and Maxey, J.,2005,The Lean Six Sigma Pocket Toolbook. New York, NY: McGraw-Hill.
丁惠民譯,2005,精實六標準差簡單講,台北市,美商麥格羅。George, M. L.,2004,What is Lean Six Sigma? New York, NY: McGraw-Hill.
丁惠民譯,2006,六標準差設計簡單講,台北市:麥格羅希爾。Pande, P. S., Neuman, R. P., and Cavanagh, R. R.,2005,What is Design for Six Sigma? New York, NY: McGraw-Hill.
吳建瑋與王瑞杰,2006,「應用六標準差手法於TFT-LCD之ODF製程改善研究」,中華民國品質學會第四十二屆年會暨第十二屆全國品質管理研討會,台中。
李志宏,2007,架構式資料倉儲之研究,國立中山大學資訊管理學系未出版之碩士論文。
李卓翰,2006,資料倉儲理論與實務,台北市,學貫行銷股份有限公司。
李芳齡譯,2004,豐田模式精實標竿企業的14大管理原則,台北市,麥格羅希爾。Liker, J. K,2004,The TOYOTA Way :14 management principles from the world’s greatest manufacture. New York, NY: McGraw-Hill.
林俊蓮,2009,利用六標準差手法提升封裝廠之晶片切割良率,國立清華大學工業工程與工業管理學系未出版之碩士論文。
張哲明,2008,「整合精實與六標準差以發展改善服務品質的方法」,明新學報,34卷2期:頁161-181。
張哲明、林敬森、姜台林和蘇朝墩,2006,「精實六標準差-服務品質改善的利器」,品質月刊,41卷12期。
陳重豪,1998,「是Lean and Six Sigma,還是Lean or Six Sigma?」,品質月刊,44卷10期:頁27-31。
黃國材,2002,六標準差在製造業之應用,大葉大學工業工程研究所未出版之碩士論文。
葛迺駿譯,2001,我懂了!六標準差:邁向高獲利的新境界,台北市,城邦文化。Chowdhury, S.,2001,The Power of Six Sigma: an inspiring tale of how Six Sigma is transforming the way we work. Chicago Dearborn Trade.
趙景明和楊清潭,2002,應用資料倉儲及資料探勘於行銷風險與決策─以資訊休閒服務業為例,2002商情資料庫分析與建置研究之成果發表會論文集:頁1-25,台北市。
樂為良譯,2002,六標準差簡單講,台北市,麥格羅希爾。Pande, P. and Holpp, L.,2002,What is Six Sigma. New York, NY: McGraw-Hill.
樂為良譯,2002,精實六標準差,台北市,麥格羅希爾。George, M. L.,2002,Lean Six Sigma. New York, NY: McGraw-Hill.
鍾漢清譯,2004,精實革命:消除浪費、創造獲利的有效方法,台北市,城邦文化發行。Womack, P. J. and Jones, D.T.,1996,Lean Thinking –Banish Waste and Create Wealth in Your Corporation, 2nd ed. New York, NY: Simon & Schuster.
蘇朝墩,2009,六標準差,台北市,前程文化事業有限公司。
【網路文獻】
Pyzdek, T., 2003,”DMAIC And DMADV”, http://www.sixsigmatraining.org/dmaicdmadv, accessed May 11, 2012.
友達光電股份有限公司,2007,「製程簡介 靜態簡報」,http://www.auo.com,存取日期:2012/04/29。
電子信息產業網,2011,「液晶面板業新競合圖譜」,http://www.dzsc.com/news/html/2011-6-1/128119_4.html,存取日期:2012/05/11。
|