. Data Warehousing Archives - Page 2 of 2 - 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, 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 

2,741 views

0 comments

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

982 views

0 comments

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. 

487 views

0 comments

1 Oct, 2002

Data Mining

01 October, 2002
Larissa Moss
Data Warehousing

Data mining is a powerful analytical activity that can be used with data warehouses and with operational systems, yielding valuable insights. Introduction Data mining is often confused with "writing lots of reports and queries," when in fact data mining activities do not involve any traditional report writing or querying at all.  Data mining is performed through a specialized tool, which executes

590 views

0 comments

1 Oct, 2001

The Evolution of the Corporate Information Factory

01 October, 2001
Bill Inmon
Data Warehousing

Introduction In the beginning were applications.  And applications served the corporation well until there was a desire for integration of historical information. However, applications supported neither integration nor historical data.  When it was noticed that applications - once built and put into production - were unable to be reshaped, the limitations of trying to get information out of appl

1,108 views

0 comments

1 Oct, 2001

Building a Data Warehouse in Iterations

01 October, 2001
Larissa Moss
Data Warehousing

Effective data warehouse development requires an iterative approach that results in a robust, well-defined and usable system for analytics. This article is excerpted from Data Warehouse Project Management (Addison-Wesley, Adelman and Moss, © September 2000). Data Warehouse Iterations Introduction A data warehouse cannot and should not be built in one Big Bang. Instead, a data warehouse is an evol

665 views

0 comments

1 Apr, 2000

Data Warehouse Costs

01 April, 2000
Sid Adelman
Best Practices

Developing a process for cost justifying a data warehouse and metrics for measuring various costs associated with a data warehouse project are essential for success This article is excerpted from a book titled Data Warehouse Project Management (published by Addison Wesley Longman (© 2000), Sid Adelman, Larissa Moss) Introduction Not every data warehouse project will be cost justified initially. 

834 views

0 comments

1 Jan, 2000

Data Warehouse Success Measures

01 January, 2000
Sid Adelman
Best Practices

Knowing how to measure success and failure, and qualifying results for a data warehouse or analytics project is essential for all project managers. This article is excerpted from a book titled Data Warehouse Project Management (published by Addison Wesley Longman (© 2000), Sid Adelman, Larissa Moss) Introduction There has been much heated discussion over the failure rate of data warehouses and de

1,183 views

0 comments

1 Jan, 1999

Data Mart Migration

01 January, 1999
David P. Marco
Data Warehousing

Fully architected solutions to data warehouse / analytics systems, not independent data marts, is the right way to ensure all the benefits of integrated data Introduction The need for an architected solution to decision support / analytics data, as opposed to the proliferation of independent data marts is becoming increasingly apparent.  The spread of independent data marts  have created "island

678 views

0 comments

1 Jan, 1999

Stranded on Islands of Data

01 January, 1999
David P. Marco
Data Warehousing

Independent data marts create stranded, unusable data.  Independent data marts can spread like a disease through an organization and must be eradicated. There is a severe disease that has spread to epidemic proportions throughout our society. This disease is particularly dangerous as its effects are not readily identifiable at the time of infection. However, if this condition goes untreated, it c

1,036 views

0 comments

 

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.

View Our Upcoming Webinars

Click here to signup for our upcoming expert webinars and to view our previous webinars

WordPress Image Lightbox