Ad hoc analysis of epi data
This presentation is the property of its rightful owner.
Sponsored Links
1 / 5

Ad hoc Analysis of EPI Data PowerPoint PPT Presentation


  • 70 Views
  • Uploaded on
  • Presentation posted in: General

Ad hoc Analysis of EPI Data. Use of Microsoft Excel. Training Workshop for EPI Data Managers and Surveillance Focal Persons (Day 4) Ulaanbaatar, Mongolia – 25-28 August 2009. What is a ‘Pivot Table’?. Pivot table An interactive table that quickly combines and compares large amounts of data

Download Presentation

Ad hoc Analysis of EPI Data

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Ad hoc analysis of epi data

Ad hoc Analysis of EPI Data

Use of Microsoft Excel

Training Workshop for EPI Data Managers and Surveillance Focal Persons (Day 4)Ulaanbaatar, Mongolia – 25-28 August 2009


Ad hoc analysis of epi data

What is a ‘Pivot Table’?

  • Pivot table

    • An interactive table that quickly combines and compares large amounts of data

    • Can rotate rows and columns to see different summaries of the source data


Ad hoc analysis of epi data

How to create a pivot table

  • Demo

    • Gender of confirmed measles cases by aimag/sourn

  • Understanding the data:

    • iCaseID: Unique internally generated ID

    • sGender: Gender (M=Male; F=Female)

    • sLevel1: Aimag

    • sLevel2: Sourn

    • sConfirmedM: Confirmed measles case? (Y=Yes; N=No)


Ad hoc analysis of epi data

How to create a pivot table

  • Exercise

    • Check lab results of confirmed measles/rubella cases

  • Understanding the data:

    • iCaseID: Unique internally generated ID

    • iMIgM1: Measles IgM result (1=Positive;2=Negative; 3=Equivocal; 4=Pending; 8=Not done; 9=Unknown)

    • iRIgM1: Rubella IgM result

    • sConfirmedM: Confirmed measles case? (Y=Yes; N=No)

    • iConfMethodM: Method of confirmation of measles (1=Lab confirmed; 2=Epi-linked; 3=Clinically)

    • sConfirmedR: Confirmed rubella case?

    • iConfMethodR: Method of confirmation of rubella


Ad hoc analysis of epi data

How to make charts

  • Demo

    • Gender of suspected measles cases by aimag

  • Understanding the data:

    • iCaseID: Unique internally generated ID

    • sGender: Gender (M=Male; F=Female; U=Unknown)

    • sLevel1: Aimag


  • Login