Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Desining a customer centric warehouse

3 posters

Go down

Desining a customer centric warehouse Empty Desining a customer centric warehouse

Post  Z_K 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

Back to top Go down

Desining a customer centric warehouse Empty Re: Desining a customer centric warehouse

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Desining a customer centric warehouse Empty Re: Desining a customer centric warehouse

Post  BoxesAndLines 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.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Desining a customer centric warehouse Empty Re: Desining a customer centric warehouse

Post  Z_K Wed Sep 29, 2010 2:42 pm

Thanks for the suggestion

Z_K

Posts : 3
Join date : 2010-04-26

Back to top Go down

Desining a customer centric warehouse Empty Re: Desining a customer centric warehouse

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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