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 The Challenges of Using Data Warehouses

By Exforsys | on February 15, 2007 |
Data Warehousing

Understanding The Challenges of Using Data Warehouses

While data warehouses can be greatly beneficial to the companies that use them, there are many challenges that a company will face in their implementation and utilization. Some experts have even said that data warehouses are one of most overrated tools in the computer industry.

Many companies decide to use data warehouses beause they simple think that it is the "next big thing," and they don’t take the time to think about the requirements they will need to meet in order to use this tools.

Being able to afford a data warehouse is just one of the many requirements a company will want to look at when implementing them. Many of the companies that implement data warehouses are disappointed with its performance.

A large number of these companies fall victim to vendors that promise to help them easily implement and use the product. However, many of these vendors are more concerned with turning a profit than helping the company succeed. To face the challenge of implementing a data warehouse, it is first important for you to understand why they can be challenging. First, constructing a data warehouse is much different than constructing an OLTP system. Many companies compare data warehouses to standard OLTP systems, and this is a grave mistake. Data warehouses are much more complex than OLTP systems. There are a large number of tools in the standard warehouse, and these tools are further broken down into many categories.

It is also important for companies to realize that data warehouses are not core business tools. What this means is that a data warehouse is much more vulernable to the politics that may occur within a company or organization. If the data warehouse does not have the support of the employees, it will fail. Many employees have a hard time using data warehouses because of their complexity, and the companies they work for will often make the situation worse by failing to educate them. It is also challenging for companies to keep their data warehouses in tune with their production units. To make matters worse, many of their developers are not trained in calibrating them.

It should be noted that data warehouse projects fail frequently. While they are great for the companies that properly implement them, they are disasters for companies who are not prepared. Much of the literature that is written on data warehouses is to positive toward the topic, and they don’t spend enough time talking about the negatives of using a data warehouses. The biggest mistake that a company can make is not properly analyzing a data warehouse project before paying for it. By not doing a detailed requirements analysis, a company sets themselves up for failure. They will waste time, money, and the careers of some of their employees may be ruined.

This article is not meant to scare a company away from implementing a data warehouse. However, a company must be aware of the pitfalls involved with using a data warehouse. Don’t rely on the vendors to tell you about this, because they will be too busy trying to sell your company the product. Unless they are a good company, your success implementation of the product is of little interest to them. If a company wants its workers to use the data warehouse, they must become familiar with fundamental SQL, since it plays an important role in the construction of many data warehouses. If the user does not understand basic SQL, it will be difficult for them to use the product efficiently.

It is also important for the company to pay attention to the vendor who is selling them the product. Is the vendor reputable?

Do they have a history of helping companies successfully implement their data warehouses?

How long have they been in the business?

It is amazing to see so many companies fail at their data warehouse implementation because they were distracted by the bells and whistles of a product. It is best to avoid doing business with vendors that don’t have a proven history of success in implementing a data warehouse. It is also important to make sure your employees accept and understand the use of the data warehouse.

They need to be given an elaborate education on using the program, and this should play an important role in the implementation of the data warehouse.

« « Understanding Quality Management For Data Warehouses
How to avail Scholarship » »

Author Description

Avatar

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

Free Training

RSSSubscribe 401 Followers
  • Popular
  • Recent
  • Crucial Requirements For Successful Data Warehouses

    February 7, 2007 - 0 Comment
  • Data Warehouse Tools

    August 18, 2006 - 0 Comment
  • Maintaining Records Within a Data Warehouse

    September 15, 2006 - 0 Comment
  • Why Data Warehouses Can Be Useful

    February 8, 2007 - 0 Comment
  • Data Warehousing Methods

    August 22, 2006 - 0 Comment
  • Advantages and Disadvantages to Using a Data Warehouse

    September 15, 2006 - 0 Comment
  • Fundamental Themes For Your Data Warehouse

    February 8, 2007 - 0 Comment
  • Data Warehouse Design Strategies

    August 27, 2006 - 0 Comment
  • The Difference Between Data Mart and Data Warehouse

    September 15, 2006 - 0 Comment
  • What You Should Know About Building a Data Warehouse

    February 10, 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 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
  • 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 Quality Management For 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
© 2022. 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