100% Data Management Success Since 1997
Contact
Data Management University
Teaching Data Management Since 1998

Work With Us

Request A Free Consultation With A DMU Expert
Free
Consultation

Pass The DAMA CDMP®

CDMP® Examp Prep Course
93% CDMP Exam Success
New
Product

Subscribe to DMU

Search DMU Library

Categories

Menu

Security Threats in the Data Warehouse Environment

July 1, 2006

Data warehouse implementations are vulnerable to internal as well as external security threats.  Follow these mitigating steps to reduce the risks. Introduction Security threats exist against your information resources, whether the systems are accessible through the Internet or buried deep within your internal network, available only to authorized users, including the enterprise data warehouse  and related analytics systems.  The increasing

Read More

Migrating From “Independent” Data Marts

April 1, 2006

Independent data marts cause many problems in data warehouse architecture; combining to result in numerous issues for business intelligence and analytics solutions. Introduction A severe disease has spread to epidemic proportions throughout our society.  This disease is particularly dangerous as it effects are not readily identifiable at the time of infection.  However if this condition goes untreated it can be

Read More

Metadata Definitions – Common Data Stewardship Activities

January 1, 2006

Creating and maintaining business and technical metadata definitions are two common data stewardship activities.  Doing them well is essential to data stewardship success. Introduction Data stewards  perform many common activities, including developing and maintaining data domain values, creating and managing business data rules, and supporting the data quality rules, validation and resolution processes.  However, the most common activities performed by

Read More

Observations on Data Strategy

January 1, 2006

A data strategy can contribute to an organization’s information strategic plan, and arrange for the productive use of the data asset. Introduction A Chief Financial Officer (CFO) was approached by the CEO and asked for an accounting of the company’s financial assets.  The CFO gave a vague response indicating a lack of knowledge of the corporate bank accounts, had little

Read More

Enabling High Quality Analytics through a Data Validity Dimension

January 1, 2006

Using a specialized data validity dimension in a data warehouse design can support data quality and analytics capabilities. Introduction While working on an Enterprise Data Warehouse for a state court system the issue of poor data quality in the source systems became apparent.  Referential integrity was not strictly enforced and there was very little in the way of attribute level constraints.  One

Read More

Facilitate Customer Integration using Generic Dimensional Modeling Techniques

October 10, 2005

Customer data integration can be improved by using generic dimensional modeling techniques Introduction If you are undertaking a Customer Data Integration (CDI) or Customer Master Data Management (MDM) project as part of a dimensional modeling endeavor, how will you tackle the problem of how to store customer addresses? Using customer addresses for direct marketing, analysis of household penetration, customer retention

Read More

Designing the Optimal Metadata Tool

July 1, 2005

Effective metadata management rs software require with robust functionality, enabling full capability for business and technical users Introduction Many government agencies and corporations are currently examining the metadata tools on the marketplace to decide which of these tools, if any, meet the requirements for their metadata management solutions.  Often these same organizations want to know what types of functionality and

Read More

Metadata Strategy Overview

July 1, 2017

Organizations need a strategy for managing metadata.  This strategy should be part of an enterprise data strategy, enabling the management of data as an organizational resource. Introduction Traditional systems development and implementation has focused on processes, rather than on data as the foundation of the enterprise.  A data orientation represents a major cultural change. It is not only a change

Read More

The Importance of Data Integration

July 1, 2017

Following some proven guidelines for data integration will ensure success in data warehousing and business intelligence, analytics and related systems initiatives. Introduction Almost every Chief Information Officer (CIO) has the goal of integrating their organization’s data.  In fact, the issue of data integration has risen all the way to the Chief Financial Officer (CFO) and Chief Executive Officer (CEO) level

Read More

Metadata Management and Enterprise Architecture

January 1, 2004

Every successful enterprise architecture relies on enterprise metadata management as part of its foundation. Introduction Almost every large government agency or Global 2000 company is struggling to properly manage an enterprise information technology (IT) architecture.  This difficulty is the direct result of the highly distributed, disjoined and overly expensive IT environments which currently exist throughout our industry.  This situation has

Read More

DMU Sponsors

Additional Resources

Menu

Quick Links

Menu

Services

Menu

Contact Us

Follow Us

Facebook Twitter Instagram Linkedin Youtube

© Since 1997 to the present – Enterprise Warehousing Solutions, Inc. (EWSolutions). All Rights Reserved

Menu

Contact us

  • This field is for validation purposes and should be left unchanged.
Menu

Request a free consultation
with a DMU Expert

  • This field is for validation purposes and should be left unchanged.

Subscribe To DMU

Be the first to hear about articles, tips, and opportunities for improving your data management career.