I have a scenario I’m trying to set up and I just wondered if you had any tutorials that you could direct me to that might cover off something similar?
I’ll explain my situation below, but essentially it is a pretty common scenario, where you might need to report on data at multiple levels, such as:
team member / team / division, or
city / country / continent
student / course / degree
My situation relates to NZ population data …
The NZ Dept of Statistics breaks the country down into “meshblocks”, which are a very low level of granularity.
Meshblocks can then be combined in a number of ways.
In my example, meshblocks are grouped to form “Community Boards”.
In turn, Community Boards can be combined to form “Territorial Authorities” (aka “Councils”).
I have a fact table that contains some population data down at the “meshblock” level and I need to produce some reports from it, based on Councils and Community Boards.
I just want to be sure that I’m setting up my data model in the best way, that allows my reports to be filtered easily down to a specific council level, or lower still, to a particular community board.
I’m guessing you’ve probably covered off something similar in one of your many excellent tutorials, so if you are able to point me in the right direction, that would be much appreciated.
Thanks for your help!