. Data Warehousing Archives - EWSOLUTIONS

Data Management University

Teaching Data Management Since 1998

Welcome to DMU!

Search DMU Library

27 Sep, 2017

Building a Rock Solid Data and Analytics Strategy

27 September, 2017
Patricia L. Saporito
Analytics

Every organization’s analytics strategy should be connected to its data strategy; and every organization should have a data strategy that supports its business strategy Introduction Like the lyrics in the children’s song Dem Bones, “the hip bone’s connected to the thigh bone”, your data strategy is connected to your analytics strategy – or it should be! Further, your analytics strategy

726 views

0 comments

21 Jul, 2017

Challenges of Data Warehouse Re-Architecture

21 July, 2017
Bruce D. Johnson
Data Warehousing

Data warehouse / business intelligence / analytics environments require business and IT cooperation for successful architecture and design Introduction In working with many large corporations across a variety of industries, it is clear that we all face the reality of re-architecting data warehouses, whether we want to admit it or not. Since data warehouses are business driven (rethink your strateg

405 views

0 comments

23 Feb, 2017

Data Warehouse Standards

23 February, 2017
Sid Adelman
Data Warehousing
New

Standards are different from guidelines.  Standards are firm and must be followed.  Successful data warehouses use standards Introduction Many dog owners give their dogs what they consider to be commands.  They are really more like guidelines. ("Boscoe come!… pause, pause, pause…  Well I guess Boscoe is busy with his chewy toy and doesn't want to come just now.") A number of organizations

928 views

0 comments

1 Oct, 2010

Increasing the Business Value of Business Intelligence

01 October, 2010
Mark Mosely
Data Warehousing / Business Intelligence / Analytics

Organizations can find increased value in business intelligence and analytics efforts through the use of various data delivery strategies. Introduction Like many organizations, your company probably has invested significant time, effort, and money into establishing your data warehousing and business intelligence environment.  You’ve built the databases and the ETL programs to move, clean and in

785 views

0 comments

20 Mar, 2015

Foundations of Data Warehousing

20 March, 2015
David Marco
Data Warehousing

Data warehousing is the proven architecture for delivering subject-oriented, stable, analytical information for decision making.  Effective data warehouse development provides many business benefits. Introduction A data warehouse is an enviroment that combines an integrated decision support database with software to collect, cleanse, transform, and store data from a variety of operational and ext

861 views

0 comments

1 Oct, 2008

Agile Framework for Managing and Measuring Enterprise Business Intelligence

01 October, 2008
Karthikeyan Sankaran
Data Warehousing

To be agile, business intelligence and analytics systems need frameworks and metrics to enable stable evolution. Introduction Enterprise Business Intelligence and analytics solutions are complex implementation efforts because of the Develop – Support (Growth-Sustain) cycles followed concurrently. Every enterprise wide BI system continuously evolves over a period with new business functionality

322 views

0 comments

1 Oct, 2008

Dimensional Data Modeling Fact Qualifier Matrix

01 October, 2008
Pete Stiglich
Data Warehousing

Fact Qualifier Matrix capabilities can be expanded to improve the value of conformed dimensions in business intelligence and analytics systems Introduction The venerable Fact Qualifier Matrix (FQM) has been a tool long used for demonstrating for dimensional models how fact and dimension tables intersect to ensure that dimensional models are conformed. A key principle of dimensional modeling is th

654 views

0 comments

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

284 views

0 comments

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 

532 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

409 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.

The First Steps in Building a World Class Data Management Program

Date : 18 Jan 2018, Time : 1:00 PM, USA/Chicago
Presenter:David Marco
Registration Opens December 11, 2017.

During this webinar international speaker and bestselling author, David Marco will walk us through the key first steps needed in building a world-class data management program.

View Our Data Management Moments

Watch our 2 - 3 minute Data Management Moment teaching videos to learn the very finest data management best practices.

WordPress Image Lightbox