1 / 13

PhUSE 2011 Managing Data Issues

Learn about a new approach to managing data issues, including sharing and storing them in Excel for better collaboration and tracking resolution progress. This approach reduces confusion, streamlines communication, and increases efficiency in resolving data discrepancies.

johannamontes
Download Presentation

PhUSE 2011 Managing Data Issues

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PhUSE 2011 Managing Data Issues By Shafi Chowdhury

  2. Overview • How do we manage data issues now? • What is the problem? • The new approach • Benefits of the new approach • Conclusion

  3. How do we manage data issues now? • Send messages to the LOG window • Print dirty data in the OUTPUT window

  4. How do we manage data issues now? • Copy and paste the issues into e-mails and send to the Data Manager

  5. How do we manage data issues now? • When we re-run the program a week later and the issues are in the LOG again: • New issues or mostly the same ones? • Send all the issues to the DM again? • Don’t send, wait for a future run? • Discuss with the DM if something will be done about these issues?

  6. What is the problem? • Same issues sent to the DM in different e-mails • Not clear which are new and which have been sent previously • The DM frustrated by having to go through the list and first discount all those they have already looked into • The DM starts to ignore e-mails from the programmer!

  7. New approach • Don’t send issues to the DM • SHARE issues with the DM • Store them in ONE CENTRAL location • Use dates to identify new and old issues • Group the resolved and unresolved issues

  8. New approach • Use ONE Excel file to SHARE issues with the DM • Issues from each program in a new sheet • A summary sheet to show all programs and the number of issues resolved and unresolved

  9. New approach • Summary sheet

  10. New approach • To send the issues to Excel: • Create a dataset with the issue • Set the LABEL as the title • Specify a KEEP statement inside the label to print the variables in a specific order

  11. Benefits of the new approach • No need to cut, paste and send e-mails • One central location with issues from ALL programs • Easy to see the number of unresolved issues • Can see how long some issues take to resolve • The DM is happy and resolves the issues

  12. Conclusion • It is OK to help the DM and inform them when we find an issue…and we do find issues • Everyone is familiar with Excel, so it is easy to use this as a sharing tool • It is not any more work for programmers or Data Managers • It will help to manage the data issues in a more structured manner

  13. Questions or Comments Shafi Chowdhury shafi@shaficonsultancy.com www.shaficonsultancy.com

More Related