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
 

How To Evaluate The Software For your Data Warehouse

By Exforsys | on February 15, 2007 |
Data Warehousing

How To Evaluate The Software For your Data Warehouse

When a company evaluates software to use in conjunction with their data warehouse, they goal should be purchase software which falls under the best of breed category. The first step in successfully evaluating software for your data warehouse is to do the analysis yourself. You should never rely on someone who is not a part of your organization..

Every technology that you come across will need to be evaluated carefully in order to be of great benefit to you and your organization. You have a greater knowledge of the needs of your company, and this knowledge is superior to an entity that lies outside your organization.

Another problem with dealing with outsiders is that they may have biases. If they have a vested (financial) interest in a specific product, they may urge you to purchase it without carefully evaluating rather or not it is truly the product your company needs. The only thing that outsiders should be used for is their knowledge of the things that you can use to evaluate the product. Another important tip of finding good software for your data warehouse is to decide whether or not you have technology within the company that can perform the task. This is crucially important, because you don’t want to waste money on something you don’t need.

A number of high quality data warehouses systems can be successfully built without having to purchase outside tools. Any time your purchase new technology, it will place a type of burden on your workers in which they are forced to deal with it. If possible, it is much better to use existing technology rather than spend money on new software, software that you workers will need to learn how to use. Because of the costs involved with data warehouse software, you can afford to place a high emphasis on the information provided by the software vendor. You should also get references from reputable sources that can give you an idea of the quality of the product.

Getting references is important, because it allows you to get practical information about the software you’re evaluating. Many business executives find that there are a number of operational issues that they find when they begin seeking references. Many of the reference sources you will encounter have spent a great deal of time evaluating the software, and they will tell you about problems that the vendor would "forget" to mention. This information can allow you to make intelligent decisions on whether or not a software product is worth your money. When you talk to the reference sources, you will want to ask them for websites or other places where you can find useful information on the product.

When you want to see the data warehouse software in action, the vendor will often require you to look at a demo. One could way to evaluate this software is to create a test case, and have each vendor follow it. This is very important, because it will allow you to make comparisons between the software products. Making comparisons between them will allow you to find advantages and disadvantages among them. It should also be noted that most vendors will not want to do this unless you are interested in spending a great deal of money.

When you read some technology magazines, you will often here of some pundits talking about the benefits of using certain data warehouse products. My advice to you is to be cautious in their endorsements, as many of these individuals are paid by the software vendors to praise the benefits of using their software packages. One good way to evaluate a software program is to analyze the stock of the company, as well as the industry as a whole.

This will give you an unbiased view of the company’s performance. The software maintenance is also very important. Many data warehousing tools will work with a device called a data dictionary. Find out what will happen if the fields in the data dictionary are changed.

One thing that should be emphasized is that there is no such thing as a perfect software product. Each one will have its own trade offs, and your company must be prepared. Any company who thinks they can "have their cake and eat it to" are in for a rude awakening.

« « 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.

Ads

Free Training

RSSSubscribe 417 Followers
Ads
  • Popular
  • Recent
  • How Does a Data Warehouse Differ From a Database

    February 11, 2007 - 0 Comment
  • How To Use Data Warehouses Strategically

    September 11, 2006 - 0 Comment
  • The Benefits of Data Warehouses

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

    February 13, 2007 - 0 Comment
  • How To Manage Current and Historical Information Within Your Data Warehouse

    September 11, 2006 - 0 Comment
  • The Disadvantages of a Data Warehouse

    February 4, 2007 - 0 Comment
  • Data Warehousing Introduction

    July 30, 2006 - 0 Comment
  • Understanding Quality Management For Data Warehouses

    February 13, 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 Non Technical Issues

    June 23, 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

  • Data Warehouses Non Technical Issues
  • 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