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

Modeling demographics

3 posters

Go down

Modeling demographics Empty Modeling demographics

Post  gbaren Wed Mar 04, 2015 9:14 am

Need some help modeling viewership by demographic.

The fact contains measures for #Viewing and #TotalMarket for each of a large, variable list of demographics that change frequently. A single fact/demographic would be something like "500 Adult Males 24-79 out of a total 10,000 in market area." It actually gets even more interesting, as in "10,000 males 24-79 in market; 2,000 watching something; 500 watching this."

Thank you very much for your attention!

gbaren

Posts : 15
Join date : 2014-01-30
Location : 02

http://equalsql.wordpress.com

Back to top Go down

Modeling demographics Empty Re: Modeling demographics

Post  nick_white Wed Mar 04, 2015 1:02 pm

I think you would need to model these measures in separate fact tables as they appear to have different grains - and you can't mix measures with a different grain in the same fact table

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

Modeling demographics Empty Re: Modeling demographics

Post  BoxesAndLines Thu Mar 05, 2015 12:39 am

I've always modeled demographics as dimensional data that categorizes typically an address. All of the big vendors that provide demographic data base it off of an address. Household size, income, religion, age bands, ethnicity, are all dimension data. Your examples are a little confusing in that I'm not sure exactly what your metrics are.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Modeling demographics Empty Re: Modeling demographics

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