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
 

Creating an Efficient Process for Data Warehouses

By Exforsys | on February 13, 2007 |
Data Warehousing

Creating an Efficient Process for Data Warehouses

Since data warehouses were first introduced during the 1990s, a large number of companies have failed when attempting to implement and use them. Many of these failures are not a result of the data warehouse itself, but rather the policies and the processes that the company used when trying to implement and utilize it.

It could be said that the early years of data warehousing was filled with trial and error. Today, a number of approaches have been devised which make using the data warehouse much easier and efficient. One approach is called the MDMP, or Management Decision Making Process system. The goal of the MDMP is to simplify the task of dealing with the data warehouse while reaching core goals.

The MDMP is a spherical model that is based on cause and effect. It can be fully broken down into four fundamental parts. The MDMP is excellent for those who approach data warehouses from a business stand point. The first thing that an executive will want to decide with this model is how their business is doing. This is an important question, because it will give you a good idea of how you should approach a data warehousing project. In other words, you should be able to determine if your business is performing good or bad. Once you have established this, you will next want to decide why the business is performing this way.

If your business is doing well, you should know about the factors that have caused this. If your business is not doing so well, you should know about the factors that have caused this as well. The information should be detailed., and you will need to have the data summarized so that you can analyze it with simple tools. The tool that you use should allow you to get to the detailed data that will allow you to see what caused the success or failure. Once you have established why your business is performing the way it is, you will next want to deal with the "what if?" This is important, because it can set the stage which will allow you to make fundamental changes to your business.

If the business is conducted differently, any problems you’re experiencing at this time can be solved. One of the most important characteristics of a data warehouse is its ability to give executives a type of forecast on how certain business moves will pan out. One of the best ways to approach this issue with your data warehouse is to set up a low, medium, and high classification for various investments dependent on their risk. Once you have completed this stage, you will now want to invest. You have the idea that can allow the company to improve, and the business manager can be given the necessary capital for the investment.

Once a company or organization has followed all the steps above, they will want to again ask themselves how their organization is performing. Within the data warehouse, it is possible to generate a memory of various initiatives that you have tried, along with the results of these initiatives. As you can imagine, this can become very beneficial for the company over the long term. While the basic premise of data warehousing may sound simple, the technical details of it can become exceptionally complicated. Many companies lose sight of the simple premise, and this is precisely why they fail. Remember, the goal of a data warehouse is to help management make better business decisions. You cannot lose sight of this fact.

Many people have asked themselves why data warehouses are so complicated. One of the reasons for this is because data warehouse processes have not been well defined up until today. This products were produced by technical individuals who paid more attention to function than the actual goals of the product. By using the simple model that is discussed in this article, a company can save itself a great deal of headaches and financial losses. In other words, keep it simple. Don’t lose sight of the primary goals of the data warehouse, and look past all the bells and whistles. This is what will allow a company to succeed withn implementing this tool.

« « C++ Static Functions
Understanding Quality Management For Data Warehouses » »

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
  • 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
  • How To Assess Your Data Warehouse

    August 30, 2006 - 0 Comment
  • Historical Information About Data Warehouses

    January 31, 2007 - 0 Comment
  • How To Rate Your Data Warehouse

    February 10, 2007 - 0 Comment
  • How To Create a Data Warehouse Structure

    September 3, 2006 - 0 Comment
  • Data Warehouse Business Principles

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

    February 11, 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
  • 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
  • Understanding Quality Management 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