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
 

Data Warehouses Non Technical Issues

By Exforsys | on June 23, 2007 |
Data Warehousing

Data Warehouses Non Technical Issues

When companies get ready to implement a data warehouse, few of them pay attention to the political issues that may surround it. It must be emphasized that politics can reduce the chances for success with a data warehouse project, and I want to warn companies against these issues so they can be avoided. The definition of a data warehouse political scenario is when the goals of two parties within the company collide.

In most cases, these conflicts will be closely related to the data warehouse project. While the conflict may seem petty at first, it can eventually have a negative effect on the developers, and this will eventually hurt the project as a whole.

The problem with most papers on data warehouses is that too much emphasis is placed on the technical details of the project. Many writers on the subject fail to account for many of the non-technical issues that can cause a data warehouse project to become a failure. The parties that will be odds the most during this project will be the users against IS, IS against IS, and user against user. A company that is divided against itself cannot stand, so these issues must be dealt with if the data warehouse project is to be a success. There are a number of challenges that a company must meet when dealing with data warehouses, and some of them are resources, deadlines, and similar issues.

Conflicts between IS projects can be some of the most difficult to solve. There is a crucial decision that companies must make at the beginning of a data warehouse project, and this is whether or not the DW development group should be connected to a group that works with transaction processing, or should the DW group be independent. Traditionally, transaction processing teams have worked closely with work backlogs, and they will see the need to quickly respond to any crisis that may occur. Despite this, some experts believe that data warehouses are much more successful when they are done via an entrepreneur like perspective.

It should be noted that many companies will become heavily dependent on their data warehouses, especially when it comes to their daily activities. To be efficient, this data warehouses need to have very high levels of industrial safety. If the data warehouse development group is allowed to work independent of other teams, this will reduce the transfer of knowledge that may be necessary for the industrial safety of data warehouses. Another important decision that a company will need to face is who should be responsible for administering the databases for the data warehouses. In most cases, the available options will either be the data warehouse development group or the DBA group.

A company will often find that they will have to consistently make changes to the structure of data warehouse databases. The use of data marts, combined with the wrong mentality by workers, can create a situation where index and table changes need to be made. If the developers of the data warehouse are concerned with having problems with the users, they may want changes to be made frequently, and if they have to deal with the DBA backlog, they could be irritated. At the same time, the DBA has profound knowledge of the processes that are necessary for the industrial safety of the databases.

If the DBA team is pushed out of the support for the data warehouse project, this can reduce the valuable wisdom that may have been made available to the project. It is also important for companies to make sure they get the support of feeder system developers. They are useful because they have a lot to lose if the data warehouse development is not successful. Often, when a data warehouse project is initiated, a company will find transaction process problems that may have remained undetected for a long period of time. The developers who are proficient with these systems may feel alienated if they feel that their work will not be appreciated.

Being able to deal with the politics of a data warehouse is crucially important. In addition to the technical issues that a company must deal with, there are other factors that must be considered as well. If everyone is not on the same page, the chances of the project being successful are highly reduced. 

« « NLP and Scientific Analysis
Client Server Features » »

Author Description

Avatar

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

Ads

Free Training

RSSSubscribe 416 Followers
Ads
  • Popular
  • Recent
  • Rules to Use With Your Data Warehouse

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

    August 8, 2006 - 0 Comment
  • How To Evaluate The Software For your Data Warehouse

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

    February 15, 2007 - 0 Comment
  • Federated Data Warehouse Architecture

    September 16, 2006 - 0 Comment
  • Crucial Requirements For Successful Data Warehouses

    February 7, 2007 - 0 Comment
  • Data Warehouse Tools

    August 18, 2006 - 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
  • 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

  • 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
  • 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