ASQ

Exclusive Content & Downloads from ASQ

Application of Quality Tools to Data Warehousing Projects

Summary: [This abstract is based on the authors' abstract.] This article aims to address the issues encountered in data warehousing projects and the use of quality tools to define, analyze, and solve the critical issues to improve data quality, reduce escalations, improve customer satisfaction, and reduce costs. On implementation of the proposed solutions, which were recommended after analysis using the quality tools, there was a 70 percent reduction in failures and a 60 percent reduction in extract, transform, and load (ETL) run time. This resulted in an improvement in the data warehouse quality, decreased the risk of not meeting production deadlines, saved much of effort and time (approximately one person-month), and finally resulted in increased business user satisfaction.

Anyone with a subscription, including Site and Enterprise members, can access this article.


Other Ways to Access content:

Join ASQ

Join ASQ as a Full member. Enjoy all the ASQ member benefits including access to many online articles.

Subscribe to Software Quality Professional Magazine

Access this and ALL OTHER Software Quality Professional Magazine online articles. You'll also receive the print version by mail.

  • Topics: Quality Tools, Quality Management, Customer Satisfaction and Value
  • Keywords: Software, Quality management (QM), Electronic data systems, Quality tools, Failure Mode and Effect Analysis (FMEA), Fishbone diagram (Ishikawa diagram), Pareto charts, Customer satisfaction (CS)
  • Author: Mahanti, Rupa;
  • Journal: Software Quality Professional Magazine