Business-Model-Driven Data Warehousing: Keeping Data Warehouses Connected to Your Business

The quality of Business Intelligence (BI) depends mostly on the available information behind it. This is particularly evident given such functional improvements in the latest generation of BI tools as much better reporting and analysis functions, new visualization capabilities, dashboards, portals, data mining tools and new analytical applications like business performance management, forecasting, planning etc. Unfortunately, business users are still dissatisfied by the business information they receive every day. What the business needs is consistent, accurate, accessible, actionable and transparent information across the whole company.

Today's businesses also need flexibility and responsiveness, so that when they want to extend or change their BI – either because they have a different view now or because of an actual business change – this should be quickly achieved without any compromises on the quality of BI.

Why is this so difficult? There is no doubt about the importance and value of BI, and we have made an enormous progress in this field. At the same time, we are still struggling with issues like inconsistency between two reports that we received in the same morning, arguing over the completeness of data, or dissatisfied that this was exactly what we needed. There are times when we want to trace back what changes have caused our figures to appear so different this month or to audit whether our business rules are consistently applied.

Data quality is the usual suspect, but equally, we should also question the effectiveness of our data integration in data warehouses and marts. It is difficult to achieve total integrity when the business rules used for derived data are spread across multiple ETL strings as on-the-fly transformations or applied as last minute transformations in the fragmented BI components.

IT has rightly turned to enterprise data warehouses and master data management (MDM) to fix these issues. Regardless of whether they are sitting on a highly scaleable platform, implemented as a central or federated architecture, or designed in normalized or dimensional models, most of enterprise data warehouses – and the data marts derived from them – fail to deliver fully on their promises to the business.

This paper analyzes the issues of conventional data warehouse design process and explains how this practice can be improved using a business-model-driven process that covers not only the requirement definition and design, but also the development, operation, maintenance and change requirements of the data warehouses and data marts in support of effective BI.

Already a Bitpipe member? Log in here

Download this White Paper!

• Corporate Email Address:

  You forgot to provide an Email Address.

  This email address doesn’t appear to be valid.

  Please provide a Corporate Email Address.

  This email address is already registered. Please log in.

• First Name:

  You forgot to provide your first name.

• Last Name:

  You forgot to provide your last name.

• Company Name:

  You forgot to provide a company name.

• Job Title:

  You forgot to provide a job title.

• Seniority: C-Level / Executive Team EVP / SVP / VP / AVP Director Manager Architect Analyst Staff

  You forgot to select your seniority.

• Job Function:

  You forgot to select your job function.

• # of employees: Select number of employees... 10,001+ 5,001-10,000 1,001-5,000 501-1,000 251-500 101-250 11-100 1-10

  You did not select the number of employees at your company.

• Industry: Select... Agriculture/Forestry Architecture and Engineering Automotive Aviation & Aerospace Business services Civic & Social Organization Construction Consumer Goods & Services Education Electrical/Electronic Manufacturing Financial/Banking Government & Public Policy Healthcare Insurance (non-Healthcare) Legal services Manufacturing/Industrial Oil/Gas/Mining/Other natural resources Outsourcing/Offshoring Photography Publishing/Broadcast/Media Real Estate Recreation/Entertainment Research and Consulting Retail Technology Transportation/Distribution Travel/Hospitality Utilities Veterinary Wholesale Wireless

  You did not select which industry you are in.

• Sub-Industry:

  You did not select which industry you are in.

• Address 1:

  You did not provide a full local address.

• Address 2:
• City/Town:

  You did not provide a full local address.

• Country: Select... Afghanistan Aland Islands Albania Algeria American Samoa Andorra Angola Anguilla Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bonaire, Sint Eustatius and Saba Bosnia and Herzegovina Botswana Brazil British Indian Ocean Territory Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Cocos (Keeling) Islands Colombia Comoros Congo Congo, The Democratic Republic of the Cook Islands Costa Rica Cote D'Ivoire Croatia Cuba Curaçao Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands Faroe Islands Fiji Finland France French Guiana French Polynesia Gabon Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Honduras Hong Kong Hungary Iceland India Indonesia Iran Iraq Ireland Isle of Man Israel Italy Jamaica Japan Jersey Jordan Kazakhstan Kenya Kiribati Korea, North Korea, South Kosovo Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macau Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Palestine Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Islands Poland Portugal Puerto Rico Qatar Reunion Romania Russia Rwanda Saint Barthélemy Saint Helena Saint Kitts and Nevis Saint Lucia Saint Martin Saint Pierre and Miquelon Saint Vincent and the Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Sint Maarten Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia and the South Sandwich Islands South Sudan Spain Sri Lanka Sudan Suriname Svalbard and JanMayen Islands Swaziland Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand Timor-Leste Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States United States Minor Outlying Islands Uruguay Uzbekistan Vanuatu Vatican City Venezuela Vietnam Virgin Islands (British) Virgin Islands (U.S.) Wallis and Futuna Western Sahara Yemen Zambia Zimbabwe

  You did not select the country you are from.

• State/Province:

  You did not provide a full local address.

• Zip/Postal Code:

  You did not provide a full local address.

• Phone:

  You forgot to provide a phone number.

  This phone number format is not recognized. Please check the country and number.

• • I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

  Please check the box if you want to proceed.

• • I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.

  Please check the box if you want to proceed.