@Randy, your solutions seems to be easiest once it reduces the amount of data to upload, but at the moment our requirement is to have population data structured as defined by National Institute of Statistics - NIS.
@Rodolfo, I guess we are at the same step. We are trying to setup an initial version of dhis2 for some Workshops, and your approach is in the way of what we need. Now I just need to create a procedure to automatically load all the data from the source, NIS excel files.
Kind regards,
Paulo Grácio
···
From: Wilson,Randy [mailto:rwilson@msh.org]
Sent: terça-feira, 26 de Março de 2013 18:24
To: Rodolfo Melia; Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: RE: [Dhis2-users] Population Definition
In Rwanda, we have tried to keep things simple by entering only total population figures for province, district, sector and health facility levels for each year.
We have then created indicators for each of the major target population groups by using census breakdowns and multiplying the total population by the following factors (we’re still waiting for results of 2012 census to update some of these):
Children 0 - 11 months
4.10%
Children 1 - 4 years
12.10%
Children 5 - 14 years
27.50%
Children < 15 years
43.70%
Population >= 15 years
56.30%
Children under 5 years
16.20%
Expected Pregnancies
4.10%
Women of reproductive age
23.60%
If your administrative units are very diverse this approach might not work, but it certainly simplifies analysis and people are less inclined to use smaller denominators to make their performance look better.
Randy
From: dhis2-users-bounces+rwilson=msh.org@lists.launchpad.net [mailto:dhis2-users-bounces+rwilson=msh.org@lists.launchpad.net] On Behalf Of Rodolfo Melia
Sent: Tuesday, March 26, 2013 6:11 PM
To: Paulo Grácio
Cc: dhis2-users@lists.launchpad.net
Subject: Re: [Dhis2-users] Population Definition
So far (I’m only doing tests, no yet in production), I have imported population data using a dataset with annual data collection, populating 2012, 13 and 14 with the same data, so I can do indicator calculations on those years.
For your case, I will create 3 data elements, each one associated to a category combination for Age, Gender and Area.
Rodolfo
On Tue, Mar 26, 2013 at 3:53 PM, Paulo Grácio pgracio@criticalsoftware.com wrote:
Hello,
I’m trying to figure out the best way to define population in a way that it can be used to calculate indicators. We have population values, lowest level is District, aggregated by age(0-5; 5-20;20-60;60+), gender(male, female) and area(rural, urban).
Based on you experience what do you consider to be the best approach for this?
Kind regards,
Paulo Grácio
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
–
Rodolfo Meliá
Principal
rmelia@knowming.com
www.knowming.com
+1 708 872 7636
+44 777 576 4090
Skype: rod.melia
Twitter: @RodolfoMelia
Note: Please note my new email address, which I will be using for PSI related work: rmelia@knowming.com