dhis2-users team mailing list archive

[Kenneth Børtveit <kenneth.bortveit@xxxxxxxxx>]

Is the algorithm implemented in excel?


2014-05-05 14:35 GMT+02:00 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
>>
>>
>
> _______________________________________________
> 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
>
>