dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

On 11 May 2011 21:18, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:

> Hi Randy,
>
> We have a similar situation in Zambia. We pre-projected the population
> figures for 2000-2010 (from the 2000 census) using growth figures, and
> then inserted these as normal data elements in the DHIS 2 database.
> AFAIK, DHIS 2 has no ability to "project" data in the manner which you
> describe. We used external statistical programs, followed by data
> transformation and import to accomplish this task.
>
> I have filed a blueprint on this topic...
>
> https://blueprints.launchpad.net/dhis2/+spec/data-projection
>
> In regards to the use of percentages for different populations, this
> should be possible through the use of indicators. If you have a base
> population and a factor for pregnant women, you would need to enter
> both the population and factor as data elements. The combination of
> the two could then be used as a denominator for instance in ANC
> calculations.
>

Hi Randy,

I would just enter the factor as a static number into the formula itself. No
need to create a data element and enter values for it.
E.g. "Total Population" * 0.041 in the denominatior expression for
Population <1 y will give the desired 4.1% of total population.

Also note that when using a data element (and data values) to put the factor
it will be aggregated like any other data element, which you don't want.


>
> I think the best way would be to pre-project the population figures
> for each year and the factors (pregnant women, WPA, etc) and import
> these for each organisational unit by year into DHIS 2. Then, you can
> use this as the basis for calculations for indicators. This is the
> procedure we use in Zambia, and it works fine.
>
> Agree with this. Projection inside DHIS is not supported and for now you
will have to enter values for each year.

Ola
-----


> Regards,
> Jason
>
>
>
> On Wed, May 11, 2011 at 8:56 PM, Wilson,Randy <rwilson@xxxxxxx> wrote:
> > We’ve been setting up DHIS-2 as a health data warehouse and dashboard for
> > Rwanda.  So far it has gone well, but I have found no useful
> documentation
> > about how to manage admin unit target populations … crucial for any
> coverage
> > indicator calculations.
> >
> >
> >
> > Ideally we’d like to store the populations once per org unit – for
> example
> > at the year of the national census – and then have a table of parameters
> > such as population growth rate, and breakdowns of % population in each of
> > the major programmatic target groups (e.g. 4.1% expected pregnancies &
> > children <1, 23.6% women of reproductive age, etc..) that can be pulled
> into
> > indicator calculations.  I’ve tried to create these parameters as data
> > elements, but I can’t seem to use them successfully in the indicator
> > definition screens, nor do I have any idea where the population data
> should
> > be stored.
> >
> >
> >
> > Has anyone done this before?
> >
> >
> >
> > Randy Wilson
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-users
> > Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > More help   : https://help.launchpad.net/ListHelp
> >
> >
>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260974901293
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>