Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Understanding Quality Management For Data Warehouses

By Exforsys | on February 13, 2007 |
Data Warehousing

Understanding Quality Management For Data Warehouses

Quality is an important concept when it comes to data warehouses, as well as their environment. Quality should not be defined in terms of data, even though having quality data is important. When I talk about quality in this article, I’m talking about the big picture.

I’am referring to the success rate of the data warehouse in conjunction with its ability to help the company achieve its goals. In addition to this, it is also important for companies to learn when quality needs to be emphasized before the actual data warehouse is built. A company that wants to succeed must measure what they’ve already done, along with making the necessary adjustments for the actual measurement of the data.

Quality can simply be defined as reaching the expectations of your customers without going above them. The reason for this is because getting higher levels of quality is costly, and even if you surpass the expectations of your customers, there is no guarantee that you will have a higher rate of return. Some business executive may want to know why taking measurements is so important. If a company doesn’t take measurements, everything they perceive will be highly subjective. In other words, a company won’t know if they are continuing to improve over time. This is why data warehouses are referred to as a process rather than just a technology or a product.

Because data warehouses are a process, it is process based measurments that should be used. Companies will want to measure things such as "activities" and "lengths." Measuring a process is much different than measuring a product, and a data warehouse much be approached from a process oriented perspective. With a product measure, you will measure things such as the volume of the data you have. While getting quality in your data warehouse will not be free, the costs will be much lower than having a data warehouse with poor quality. The costs that you will have to pay for quality will come in the form of re-planning, implementation, and measurments.

It could be argued that re-planning is the most important factor in data warehouse quality. Once the problems of today are solved, and company must be prepared to deal with the problems that will occur tomorrow. It is also important to analyze the value of data warehousing from the business perspective. For business people, the purpose of using a data warehouse is clear: to gain a powerful insight into decisions they can make to help their company become more productive. Based on this, the true measurement of a data warehouse is whether or not the data warehouse can help the business succeed. Over time, the upper management in the company must be able to see progress. If they cannot, the data warehouse project will be considered a failure.

Many companies make the mistake of believing that a data warehouse is silver bullet. They think that by simply using the most cutting edge technology, they will automatically be given an edge in the marketplace. It is attitudes that like that often cause data warehouse projects to become failures. A data warehouse is not one technology. It is multiple technologies combined, and once a company purchases it, it will need to be customized. Most importantly, the company will need to establish guidelines for operating the data warehouse if they wish to run the program efficiently.

It is also important to realize that data warehouses are tools that must evolve. This is precisely why they are often built in an incremental format. Some experts feel that data warehouses is a process of evolution, and they also feel that companies need large scale projects that can be built in three months rather than three years.

Companies that want to produce quality management for their data warehouses must know what they have done right, as well as what they have done wrong. This is where metadata becomes so useful. Metadata can play an important role in the measurement and quality of your data warehouse.

There are three types of success that companies must aim for, and this is political, economic, and technical success. When the data warehouse increases the bottom line, a company has succeeded economically. When the company is using the data warehouse daily, it has succeeded politically. When the right tools have been chosen for the right tasks, the company has succeeded technologically.

« « Creating an Efficient Process for Data Warehouses
How To Evaluate The Software For your Data Warehouse » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Ads

Free Training

RSSSubscribe 417 Followers
Ads
  • Popular
  • Recent
  • Data Warehousing Introduction

    July 30, 2006 - 0 Comment
  • How To Evaluate The Software For your Data Warehouse

    February 15, 2007 - 0 Comment
  • How To Properly Manage a Data Warehouse

    September 16, 2006 - 0 Comment
  • Rules to Use With Your Data Warehouse

    February 5, 2007 - 0 Comment
  • Data Warehouses At a Glance

    August 8, 2006 - 0 Comment
  • Understanding The Challenges of Using Data Warehouses

    February 15, 2007 - 0 Comment
  • How To Manage Meta Data Within a Data Warehouse

    September 16, 2006 - 0 Comment
  • Data Warehouse Issues

    February 5, 2007 - 0 Comment
  • Data Warehouse Overview

    August 14, 2006 - 0 Comment
  • Data Warehouses Non Technical Issues

    June 23, 2007 - 0 Comment
  • Data Warehouses Non Technical Issues

    June 23, 2007 - 0 Comment
  • How To Evaluate The Software For your Data Warehouse

    February 15, 2007 - 0 Comment
  • Understanding The Challenges of Using Data Warehouses

    February 15, 2007 - 0 Comment
  • Creating an Efficient Process for Data Warehouses

    February 13, 2007 - 0 Comment
  • How Does a Data Warehouse Differ From a Database

    February 11, 2007 - 0 Comment
  • How Data Is Stored Within a Data Warehouse

    February 11, 2007 - 0 Comment
  • How To Rate Your Data Warehouse

    February 10, 2007 - 0 Comment
  • What You Should Know About Building a Data Warehouse

    February 10, 2007 - 0 Comment
  • Fundamental Themes For Your Data Warehouse

    February 8, 2007 - 0 Comment
  • Why Data Warehouses Can Be Useful

    February 8, 2007 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Data Warehouses Non Technical Issues
  • How To Evaluate The Software For your Data Warehouse
  • Understanding The Challenges of Using Data Warehouses
  • Creating an Efficient Process for Data Warehouses
  • How Does a Data Warehouse Differ From a Database

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2021. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy
Necessary Always Enabled