dhis2-users team mailing list archive

["Wilson,Randy" <rwilson@xxxxxxx>]

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:

[cid:image005.png@01CF6859.B73055D0]

[cid:image006.png@01CF6859.B73055D0]


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>
[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.
[Description: Follow MSH on Facebook]<http://www.facebook.com/ManagementSciencesForHealth>[Description: Follow MSH on Twitter]<https://twitter.com/#%21/MSHHealthImpact>[Description: YouTube]<http://www.youtube.com/mshhealthimpact>Follow us on Facebook and Twitter