Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Archive for the ‘MDM’ Category

Customer Dimension and CRM related Analytics

Posted by Dylan Wan on August 14, 2007

Why is the customer dimension so important?

  • A well-maintained, well-deployed conforming customer dimension is the cornerstone of sound customer centric analysis

What are special characteristics of the customer dimension?

  • Customer dimension is extremely deep. It may have million rows.
  • Customer dimension is extremely wide. It has hundreds of attributes.
  • Customer dimension changes often. It is not really a slowly changing dimension. It is sometimes called as rapidly changing monster dimension.
  • Keeping the historical images of the customer data is important.
  • The data in the customer dimension come from multiple sources. Matching, de-dup, standardization among different sources is critical for successfully conforming the dimension.
  • The customer dimension with data may be enriched from the external data.
  • Customer data is the source for other dimensions – geography, industry, lines of business, etc.
  • You have to comply with the privacy regulation.
  • The data from external source may be only licensed for a period of time. The external data need to be associated with your own internal data for analysis for special purposes and the data need to be removed from your database.
  • The customer dimension itself is actually a source of fact tables. For example, # of customer living in California with the breakdown by age groups.

Posted in BI, BI Work, Business Intelligence, CDH, CDI, Customer Data Integration, Customer Intelligence, Data Warehouse, Marketing Intelligence, Master Data Management, MDM, Sales Intelligence, Service Intelligence, UCM | Leave a Comment »

Recent posts on my MDM blog

Posted by Dylan Wan on August 8, 2007

Good information comes from good data.  The quality of your data warehouse relies on a good master data management (MDM) solution.   Here are some of important concepts in any MDM application.  I explain more of them in my MDM blog – http://groups.google.com/group/MDM-us.

Survivorship – what is this?

Cross Referencing – why do we need it?

Posted in CDH, CDI, Customer Data Integration, Data Warehouse, Master Data Management, MDM, UCM | Leave a Comment »

Microsoft acquires MDM vendor Stratature

Posted by Dylan Wan on June 12, 2007

Microsoft recently purchased a Master Data Management vendor Stratature. After I looked at their web site, I guess that Stratature’s offerings seems falling into the BI related MDM , like what Oracle – Hyperion’s product. Their webinar is co-presented with Joy Mundy from the Kimbal Group.

Stratature provides the “Dimension Manager” as the solution for Customer Data Integration. Based on the name of the product, we can also know their solution is BI centric.

Here are several requirements I guessed they tried to target: Read the rest of this entry »

Posted in BI, Business Intelligence, CDI, Customer Data Integration, Data Warehouse, ETL, Master Data Management, MDM | Leave a Comment »

Why is a single view of customers important?

Posted by Dylan Wan on March 14, 2007

I think that it is important to understand why a single view of customer important.  Understanding this provides you a good perspective on why you should implement a MDM, or a CDI, solution.

I believe that a data warehouse deployment will be much easier and simplier if we can assume a MDM is in place.  However it requires some design efforts to leverage MDM in data warehouse data model and ETL design.

Read the rest of this entry »

Posted in CDI, Customer Data Integration, Master Data Management, MDM | Leave a Comment »

What is Master Data Management?

Posted by Dylan Wan on March 14, 2007

Master Data Management is a combination of business processes, software application, and technologies which helps you to manage your master data, such as “Customer”, “Supplier”, “Employee”, and “Product”.

There are four key components of a MDM solution… Read the rest of this entry »

Posted in Master Data Management, MDM | Leave a Comment »

Master Data Management and Conformed Dimension

Posted by Dylan Wan on March 4, 2007

Conformed Dimension is a concept coming from dimensional modeling. I believe that Conformed Dimension is one of the original source where the customer data integration and master data management come from.

Read the rest of this entry »

Posted in Data Warehouse, ETL, MDM | 3 Comments »