Summary: | 碩士 === 國立中央大學 === 資訊管理學系碩士在職專班 === 100 === 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.
|