. Data Management University Blog - EWSolutions

Teaching Data Management Since 1998

Data Management University

Request a free consultation with a DMU Expert

Search DMU Library

DATA MANAGEMENT MOMENTS

2 - 3 Minute Data Management Videos

1 Jul, 2007

Global Project Management Office Implementation Part 1

01 July, 2007
Waffa Karkukly
Project Management

Global Project Management Office (PMO) development and implementation requires planning and support to ensure successful implementation Introduction There has been a growth in the Project Management  Office (PMO) market and PMOs seem mushrooming everywhere in every organization. The good news is it is about time the PMO function started to take a prominent role within the various industries and a

1,720 views

1 Apr, 2007

Benefits of an EIM Initiative

01 April, 2007
Michael F. Jennings
Data Management

Through the development of an enterprise information management program, organizations can realize many business benefits and manage data as an asset. Introduction More and more companies are coming to the realization that an Enterprise Information / Data Management (EIM)  initiative provides a critical foundation that is essential to meet today’s many business challenges. A fundamental asset o

959 views

1 Apr, 2007

Performance Benefits of Surrogate Keys in Dimensional Models

01 April, 2007
Pete Stiglich
Data Warehousing

There are many benefits to implementing surrogate keys in a dimensional model design for a data warehouse data model Introduction There are many reasons for implementing surrogate keys in Dimensional Models (enterprise data modeling) such as insulating dimensions from changes to source systems and enabling historical versioning of dimension members. However, query performance in the data warehouse

1,158 views

1 Oct, 2006

Data Governance Maturity Overview

01 October, 2006
Anne Marie Smith, Ph.D.
Data Governance

Using a data governance maturity model to assess and continually measure the performance of the data governance program can give any organization tactical and strategic benefits. Introduction Generally, data governance  is a long-term strategic initiative, but data governance can also deliver short-term, tactical benefits. The need for both strategic and tactical approaches to data governance con

1,017 views

1 Jul, 2006

Fundamentals of the Capability Maturity Model

01 July, 2006
Anne Marie Smith, Ph.D.
Data Management

Using a framework such as a Capability Maturity Model (CMM) brings many benefits to any organization, for any project or program. Introduction Would you eat in a restaurant that had not been inspected periodically by the local inspector? Of course, you would not – because you could not be sure that the restaurant followed the best sanitary practices as a matter of routine. But passing the inspec

1,357 views

1 Jul, 2006

Security Threats in the Data Warehouse Environment

01 July, 2006
Michael F. Jennings
ETL

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 

3,210 views

1 Apr, 2006

Migrating From “Independent” Data Marts

01 April, 2006
David P. Marco
Data Warehousing

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 unt

1,205 views

1 Jan, 2006

Metadata Definitions – Common Data Stewardship Activities

01 January, 2006
David P. Marco
Data Stewardship

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 p

1,931 views

1 Jan, 2006

Observations on Data Strategy

01 January, 2006
Sid Adelman
Strategy & Roadmap

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 idea what was in each ac

845 views

1 Jan, 2006

Enabling High Quality Analytics through a Data Validity Dimension

01 January, 2006
Pete Stiglich
Data Warehousing

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. 

554 views

 

View all podcasts

View Our Podcasts

DMU provides regular podcasts of our best webinars, expert speaking events and our 3 minute Data Management Moment teaching videos.

WordPress Image Lightbox