Subscribe to DMU

Search DMU Library

Categories

Facilitate Customer Integration using Generic Dimensional Modeling Techniques

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

The Importance of Data Integration

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

Data Architecture and Packaged Implementations Part Three

Challenges to implementing data architecture with packaged applications can be overcome by addressing issues and challenges during design Introduction In a previous article I discussed some issues that a client encountered when trying to implement a packaged application. They were convinced that the business would make the decisions and IT was not going to interfere in their packaged implementation.  There

Read More

Data Architecture and Packaged Implementations Part Two

Every organization should follow a set of guidelines for implementing packaged applications to ensure architectural harmony and avoid numerous problems. Previously I discussed some issues that a client encountered when trying to implement a packaged application.  They were convinced that the business would make the decisions and IT was not going to interfere in their packaged implementation.  There was a

Read More

Business-Focused Data Analysis

Business-focused data analysis activities allow for understanding data and correcting any discrepancies, regardless of systems design or implementation Introduction initiative is the first attempt at bringing business data together from multiple sources in order to make it available across different departments. Organizations that use a traditional system development approach on their data warehouse (DW) projects usually run into severe source

Read More

Data Mining

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

Read More

Use of Metadata Entities in Abstraction

Metadata supports the conditions that uses of abstraction in data modeling, ensuring lasting and scalable data models When I write on abstraction, I like to remind the reader of a very abstract painting I observed in a museum, which consisted of a white dot on a red canvas that represented a city skyline. In my first article in this series,

Read More

Contact us

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

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.