dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Randy,

this is interesting though and projections are very common in BI solutions
in general.

Do you or anyone else have some thoughts on what type / algorithms should
be used for projections / extrapolation (there are quite a few)?

http://en.wikipedia.org/wiki/Extrapolation

regards,

Lars







On Mon, May 5, 2014 at 11:58 AM, Wilson,Randy <rwilson@xxxxxxx> wrote:

>  Before trying to re-invent the wheel, I wonder if anyone has experience
> creating charts and tables based on projected data in DHIS-2.  We have
> developed some data sets for community-based health information that takes
> data reported monthly and projects it forward to the end of the financial
> year.  For example revenues from co-payments and enrollment fees for 3
> months – is projected ahead 6 months and one year – using a variety of
> assumptions.
>
>
>
> I can see 3 options:
>
>
>
> 1.       Develop an algorithm that runs at the end of each quarter and
> inserts the projected values into datavalue table so that we can use DHIS-2
> analytical tools to create charts, tables and maps.  (I think Jason
> Pickering has done something like this using R)
>
> 2.       Design queries and custom tables to store the projected values
> and build iReports with charts and tables.
>
> 3.       Extract the data from DHIS-2 into Excel (where the current
> analysis tools have been developed) and continue to use Excel for the
> visualization.
>
>
>
> Here are some sample outputs:
>
>
>
>
>
>
>
>
>
> If you have other suggestion they are most welcome.
>
>
>
> *Randy Wilson*
>
> Senior HMIS and Data Use Advisor, Ministry of Health/Rwanda
>
> Integrated Health Systems Strengthening Project
>
> Management Sciences for Health, Inc. (MSH)
>
> BP 371
> Kigali, Rwanda
> +250-788308835
>
> Skype Name (wilsonrandy_us)
>
> www.msh.org<http://www.msh.org/?utm_source=2012-10-15+MSH+internal+announce+email+signature&utm_campaign=iemailsig&utm_medium=email>
>
>
> [image: Description:
> http://ih.constantcontact.com/fs017/1102482301888/img/438.gif]<http://www.msh.org/?utm_source=2012-10-15+MSH+internal+announce+email+signature&utm_campaign=iemailsig&utm_medium=email>
>
> *Stronger health systems. Greater health impact.*
>
> [image: Description: Follow MSH on Facebook]<http://www.facebook.com/ManagementSciencesForHealth>[image:
> Description: Follow MSH on Twitter]<https://twitter.com/#%21/MSHHealthImpact>[image:
> Description: YouTube] <http://www.youtube.com/mshhealthimpact>Follow us
> on Facebook and Twitter
>
>
>
> _______________________________________________
> 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
>
>