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
 

What You Should Know About Building a Data Warehouse

By Exforsys | on February 10, 2007 |
Data Warehousing

What You Should Know About Building a Data Warehouse

As we move further into the Information Age, the global competition among companies has become more fierce, and many of them are relying more on data warehouses to help them make critical decisions. Before a company can use a data warehouse to achieve their own goals, they must first understand how it is built.

Some of the greatest challenges involving a data warehouse will be seen when it is implemented by the company for the first time. The quality of the data within the warehouse is very important. It must be accurate if the company wants to make good decisions based on it. Some of the things that the company will want to look at is the source of the data, and whether or not it comes from a program that is operational.

If the data does come from an operational program, a company will need to analyze the rules of this data before they allow it to be placed within a program that is operational. It should also be noted that it is critically important for companies to understand the rewards that surround placing data in the warehouse properly. When data is pulled from the Internet, this is of great importance. While some areas of the Internet like e-commerce may be highly accurate, other parts of the Internet may be highly inaccurate. Because of this, one important aspect of running a successful data warehouse is making sure the data has been cleaned.

Once the data has been cleaned, it can be analyzed properly. The maintainence of data plays an important role in the construction of the data warehouse. Dealing with personal names can be very challenging because many people may go by numerous names. Some of these may be legal names or nicknames. The same problem may also occur when dealing with addresses. If a person lives in an apartment, they can enter the information in a number of different ways, and this can cause inconsistencies in the system. To solve these problems, it is important for companies to construct programs that are capable of making correlatoins between data that is similar.

Every company that decides to use a data warehouse must figure out how they will store the data within it. A company must understand that there is a big difference between moving the data into the warehouse versus changing the operational systems in a way that makes them more friendly to the data warehouse. The recent advent of software that can automate the data cleaning process and combine this process with the transport of data via an operational system is useful, and can play an important role in the business decisions that are made by the company. In addition to placing data within the data warehouse, it is also important to make sure that data is defined.

Many of the users may not have a technical knowledge of the warehouse, and it is important for companies to make sure a definition of the data is made. Analysts will want to look at the potential queries that will commonly be made by the user, and make preparations for them. The number of possible queries for a data warheouse are quite numerous, and this is why it is so crucial for the analysts and developers to make sure the data is defined.

Queries which are highly intelligent will make the information that is found that much more valuable. The warehouse schema should be set up in such a way that it allows the largest number of questions to be asked and answered.

This schema should only be limited by the database management system itself. Another issue that companies will want to consider is how updated the data warehouse should be. The maintenance of the warehouse should be done based on the volatility of the data within it. For instance, an address that was entered for a customer 18 months ago may not be current, and the customer may no longer live at that address. The ultimate goal of a company should be to design a schema that is close to real time. A company can’t afford to make decisions on data that is old or obsolete. When the data warehouse is being updated in near real-time, this will allow the company to make decisions which are highly accurate.

« « Fundamental Themes For Your Data Warehouse
How To Rate 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
  • Understanding Quality Management For Data Warehouses

    February 13, 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
  • 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
  • Understanding Quality Management For Data Warehouses
  • Creating an Efficient Process for Data Warehouses

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