Modeling demographics

View previous topic View next topic Go down

Modeling demographics

Post  gbaren on 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

View user profile http://equalsql.wordpress.com

Back to top Go down

Re: Modeling demographics

Post  nick_white on 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 : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Modeling demographics

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

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

View user profile

Back to top Go down

Re: Modeling demographics

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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