Desining a customer centric warehouse

View previous topic View next topic Go down

Desining a customer centric warehouse

Post  Z_K on Wed Sep 29, 2010 12:06 pm

We are designing a customer centric datawarehouse in company , right now it is order centric , there are subject areas like Order,Membership,Billing,Retention , we want to get all the event data(Order,Membership,Billing,Retention etc.) for customers at one place , what will be the best approach create one big fact table containing data for all customer events or multiple fact tables for different subject areas ( Order,Billing,Memnership etc.) then join individual fact tables to get result, because there are 100's of reports using this data. Also cubes related to order , Biiling ,Retention are alos need to be build daily.
Please advise.


Last edited by Z_K on Wed Sep 29, 2010 12:10 pm; edited 2 times in total (Reason for editing : typo)

Z_K

Posts : 3
Join date : 2010-04-26

View user profile

Back to top Go down

Re: Desining a customer centric warehouse

Post  ngalemmo on Wed Sep 29, 2010 12:46 pm

Atomic fact tables represent different business events or states. In a proper dimensional warehouse, you have multiple atomic fact tables, each within the scope of the event they represent (order, enrollment, etc...). You can then integrate the facts using queries or create aggregates from the atomic facts as necessary.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Desining a customer centric warehouse

Post  BoxesAndLines on Wed Sep 29, 2010 1:06 pm

I would go with a new integrated customer dimension comprised from all the source data. You can use data quality software to build the "golden view" of the customer. From there you can add the customer FK to all existing facts.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Desining a customer centric warehouse

Post  Z_K on Wed Sep 29, 2010 2:42 pm

Thanks for the suggestion

Z_K

Posts : 3
Join date : 2010-04-26

View user profile

Back to top Go down

Re: Desining a customer centric warehouse

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum