DHIS-2-Pivot

Hi all, some feedback would be much appreciated on the following document:

http://208.76.222.114/confluence/download/attachments/8096/How+to+set+up+Excel+Pivot+tables+with+DHIS2.doc

It's expanding the answer we have on launchpad, and I hope it will be
sufficient for all those who are not familiar with the DHIS structure,
database management, and SQL queries. Made it primarily because we need it
in Sierra Leone, but hope it will be useful for others too.

Johan

Hi Johan,

I have had a quick look at the document, and I think it is quite
useful. However, maybe you could indicate who the audience is? I
assume it will be primarily intended for DHIS2 implementers or
end-users?

I will revert with some more detailed suggestions directly in the text
of the document.

Best regards,
Jason

···

On Mon, Apr 27, 2009 at 4:50 PM, <johansa@ifi.uio.no> wrote:

Hi all, some feedback would be much appreciated on the following document:

http://208.76.222.114/confluence/download/attachments/8096/How+to+set+up+Excel+Pivot+tables+with+DHIS2.doc

It's expanding the answer we have on launchpad, and I hope it will be
sufficient for all those who are not familiar with the DHIS structure,
database management, and SQL queries. Made it primarily because we need it
in Sierra Leone, but hope it will be useful for others too.

Johan

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

Jason,

I'm not quite sure about the audience, but it was meant for Bob here at
WHO :slight_smile: But, yes, it will primarily be for DHIS2 implementers and
end-users. With the downloadable views, it is quite simple to set up pivot
tables, which are extremely powerful tools for analysis. From my own
experience, I know that if you don't know much SQL, and you don't work
with technical aspects of the DHIS on a regular basis, setting up pivot
tables can be quite a challenge. I thought this could be a chapter in the
regular DHIS manual, one of those appendices on auxiliary software.

Johan

···

Hi Johan,

I have had a quick look at the document, and I think it is quite
useful. However, maybe you could indicate who the audience is? I
assume it will be primarily intended for DHIS2 implementers or
end-users?

I will revert with some more detailed suggestions directly in the text
of the document.

Best regards,
Jason

On Mon, Apr 27, 2009 at 4:50 PM, <johansa@ifi.uio.no> wrote:

Hi all, some feedback would be much appreciated on the following
document:

http://208.76.222.114/confluence/download/attachments/8096/How+to+set+up+Excel+Pivot+tables+with+DHIS2.doc

It's expanding the answer we have on launchpad, and I hope it will be
sufficient for all those who are not familiar with the DHIS structure,
database management, and SQL queries. Made it primarily because we need
it
in Sierra Leone, but hope it will be useful for others too.

Johan

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to � � : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help � : https://help.launchpad.net/ListHelp