4) All DIV Meeting Agenda and Notes
Participants: Hana, Ayesha, Nicole, LaChandra, Issaka, Kate, Shaylee and Randy
- Viz Library - first step done, some dossiers are left which will be completed soon
- Next step of creating library pages has started and can be found here
- Integration Testing - happening this week, will be wrapped up by Wednesday 6/23
- PCD: Clusters approved for this round have started the development. Peds dossier had approval for 4 pages, waiting for the rest- they may need to present mock-ups during PSC meeting this Friday
Participants: Shaylee, Kimi, Randy, LaChandra, Kate, Hana, Femi, Alex, Issaka, Mackenzie, Ayesha and Nicole
- Viz Library - restarted this project. We will try to complete all screenshots by the end of this week. Will put together everything next week. For now only ICPI visuals but can expand to other data sources like POART slides later on. Add a missing tool here on archived ICPI visualizations
- Planned updates for Q3 was submitted last Friday. Datastrong is reviewing and will let us know the LOE
- For groups that have Mock-ups, presentation to PSC is this Friday at 1pm. Approval will likely come on Friday
- Integration testing for clean testing is coming up on June 21-23rd- Will send an email to confirm QCers
- Microstrategy training ongoing
- Discussions on API connection to Panorama
- Narrative Analysis - Brainstorming on how to visualize qualitative data in small group. If interested, let Randy know
Participants: Nicole, Randy, Shaylee, Femi, Issaka, Hana, Kate, Kunnica, Alex, Grace
- Viz Library - Calling for volunteers to comb through SP Excel tools for screenshots (Issaka, Kate, Hana)
- Core Competencies
- Q2 Release - waiting on list of issues will share with PCD after Friday
- Q3 Requirements/Planned Updates - Due June 4th to Nicole
- Pano Tech Call - Dossier hyperlinks conversation (DataStrong to provide next steps); Microstrategy update coming up will occupy DataStrong LOE
Participants: Randy, Nicole, Ayesha, Gabrielle, Kimi, Hana, Kate, LaChandra, and Issaka
- Will reach out to analysts working on data viz project to restart it
- Discussions on Pano 101 course which maybe similar to BI PVA course
- Aimed for new hires and existing members
- Develop a course like DATIM 101- more details will be shared later
- Courses are available, more users have signed up
- Plan is to make the training more structured type of process for content developers
- "Dashboarding with dossier e-learning" course-useful for new developers
- Slack channel; Microstrategy Analyst Training Reference excel is a good source to view which courses are recommended for analysts
- Share tips thru slack but can put together a group later
Next week May 17 thru 19th , kickoff call on Monday
- CDC is having a webinar on "visualizing qualitative data and mixed methods"
- Kimi will share tips with the group from the webinar
- Randy will try to share PPT slides if possible
- Pick out standout visualization from COP presentations
- May do an award
- COVID-19 open data repository is a good resource for COVID data with a mix of demographics, economic indicators, epidemiology, geography, health, hospitalization, mobility, government response, weather and more.
Participants: Randy, Shaylee, Nicole, Ayesha, LaChandra, Katie, Hana, Issaka, Mackenzie, Alex, Kimi, and Kate
Data Viz Library
- Lacking SMEs for creating content (help with screenshot, brief description etc.)-Randy will reach out to cluster leads on getting support
Core Competencies Group
- Rough draft, need to figure out next concrete steps
- Google doc for easy share? It is already on google drawing- Add to Sharepoint?
PVA Course
- Both courses (Power Bi and Tableau) are available on PVA
- Link to PVA: https://learn.pepfar.net/dashboard
- Need login for PVA in order to access the course
- Pano content development in progress
- Less than 2 weeks left, QC will begin after that
- Integration testing (Q1 clean release) went well, no major issues- will review tickets with Datastrong this week
- Microstrategy training is live now. This is a self-paced training. If interested, let us know
- Sign up for the training at this link: https://microstrategyb2c.b2clogin.com/microstrategyb2c.onmicrosoft.com/B2C_1A_signup_signinSAML/samlp/sso/login
- Study group of people taking the training?
Learning Collaborative
- Miro board was a great platform, fun session
- Presentations were good, low participation in some group. In other groups, engagement was fine
- Also maybe do a mock session on Miro/tools with facilitators for better understanding
- DIV maybe can do a similar exercise on dossiers?
AOB
Participants: Nicole, Randy, Katie, Issaka, Hana, Ayesha, Femi, LaChandra and Salem
Data Viz Library
- On Sharepoint, list of Tools to be archived
- Site layout work in progress
Core Competencies Group
- First draft
- Next steps
PVA Course
- Updates: Power BI and Tableau undergoing OGAC review
- Creating content on PVA
Learning Collaborative
- Nicole: Tool Landscape Analysis Presentation
- Activity TBD
- Content development kickoff 3/15
- Dossier updates all approved by Pano Committees
- QC next week (Monday-Wednesday)
- Nicole and Janice reviewing Zendesk backlog
- Microstrategy Training Bob Cahill setting up rollout plan, more analysts should be able to take training
- Pano Style Guide still waiting for feedback from Leads
Core Competencies
AOB
In attendance: Nicole, Randy, Katie, Issaka, Mackenzie, Hana, Ayesha, Femi, Gabrielle, LaChandra
Data Viz Library
- Knowledge management project which archives all the visualization produced by ICPI (past and current tools)
- Will serve as reference for indicators used to produce visualization
- Identify potential caveats when reviewing a visualization
Core Competencies Group
- Skills diagram on what skills an ICPI analyst should have
- Need to follow-up and update the drawing
PVA course
- Link to BI Training 201 PowerPoint slides can be found on SharePoint
- DIV members can review and provide their feedback
QC Round 2 pilot last week
- Welcome feedback on round 2, will also have opportunity to share your thoughts during ICPI staff meeting scheduled for Feb 25th
Integration Testing happening 02/16-02/17
- Pre-clean data release on 02/19
COP Pause – any implications for us?
- Determining LOE for Datastrong and how this will pause will affect them; more info to come
QC Automation
- Initial conversations happening with a small group
- Exploring Selenium program along with other options
- Goal is to standardize this process across dossiers
- Also looking to into using SharePoint to automate emails that are sent during QC process
In attendance:
- Yaa :(
- Nicole :)
- Finalize SharePoint Library Template (https://pepfar.sharepoint.com/sites/ICPI/SitePages/HTS.aspx?web=1)
- Core Competencies Free-For-All (https://docs.google.com/drawings/d/17kXmYy3onYubpeQaZ9mj7BBb0pvgCOAB55houulAHeg/edit)
- PVA Ongoing
- Update - Issaka to set-up a meeting this month; Nicole met with Shaylee to decide on initial responsibilities
- Integration Testing Review
- Unit Testing
- Viz Mockups and PSC Presentation
- MicroStrategy Training
- Volunteers?
In attendance: Alex, Femi, Issaka, Hana, LaChandra, Nicole, Tim, Larry, Shaylee, Randy, Yaa
- Reminder of action items
- mock-up your SharePoint Library page
- add to the Core Competencies map
- continue PVA development!
- Time to activate Style Guide team for updating the Panorama Style Guide draft
- Checklist added to Style Guide? Most likely after finalization of the Style Guide
- Alternative to Data Viz of the Week
- Need to keep up-to-date with current features in the world of data management and/or data visualization
- 2-3 members needed to be dossier POC for Panorama for any future requests for analyses
- Issaka interested
- Jamie, Randy, and Yaa currently reviewing submissions
- Will most likely inform PCD's of decisions week after Pano Steering Committee review (~xmas week)
- LOE status needed from members
- Tableau mapping feature with PSNU
- Our World in Data COVID map
In attendance: Alex, Erin R, Femi, Issaka, Kate W, LaChandra, Nicole, Tim, Randy, Yaa
- Jamie & Shaylee clarification on higher level comments
- Context: 1.5 years since last workplan review. Coordinator role is to summarize
- Clarification on comment from R: many opportunities for DIV to engage with the field. No expectation of an action
- Shaylee Comments: Capacity Building- OCB/Content developer relationship strong. Clear delineation between OCB & DIV (or other clusters) PVA rollout
- Leads are open to revisiting the roles/approach to capacity building
- How does the capacity building activities of DIV align with Learning Collaborative?
- Jamie: envisions LC as forum to highlight the trainings/products team is building on
- Core Competencies: Reviewed completed skills trees and discussed progression/foundational trainings. Notes:https://github.com/ICPI/DIV/wiki/6)-Core-Competencies-Notes
- DIV Viz library: Randy met with Grant et al last week to review prototype
- BI PVA Course: Met last week to review slide decks in development. Recommendations on standardizing language, datasets. Follow GitHub repo here. Extended deadline: End of January
- Q1 Reqs Process: Excel template due Dec 4th, full word document due Dec 11th
- Pano Tech Committee: Agreed on new Sandboxing environment in pano Dev, Prevention cluster likely to pilot once mock MER 2.5 data becomes available ~end of Jan 2021
- Draft FY21 Pano Dev Calendar: EMBARGOED, walkthrough of new 6-weeks of dev approach, 1 fast follow release per year.
- Kimi to organize call between prevention cluster, @SOhara and DIV co-leads to discuss data prep for AGYW_PREV mods, MER 2.5 mods
- Presented on Global Health Security index developed in 2019. Access here: ghsindex.org
In attendance: Alex, Erin R, Femi, Issaka, Kate W, LaChandra, Nicole, Tim, Randy, Yaa
- Role of DIV in supporting field analytics like interagency POART analyses?
- Recommendation: Try out the model to see if it works
- Recommendation: Ascertaining DIV members are also reps on other clusters
- Recommendation: DIV is well placed to develop innovative analysis for routine meetings
- Where will trainings sit/which group will focus on training/coordination?
- DIV has led the idea of course progression (e.g. BI 200 level series)
- Recommendation: DIV is poised to lead the charge on capacity building
- Recommendation: Should we focus on just data use or also data interpretation? latter is a key gap
- Will DIV take on coordination, development & delivery of all trainings?
- Discuss further with ICPI leads re: role
- PVA Sub-cluster: on task to complete training by mid-December
- Data Viz library: met with SharePoint developers and SP team will create a demo and present next week
- Core Competencies: interactive activity - across all
- Plan to present to Pano Steering Committee
- Next Steps: standardizing analysis, frequency, and update
- Next Steps: finalize draft pano style guide doc
- Received feedback from Botswana team
- team working on completing requested edits
- thanks to Kiefer for developing maps for us
- Issaka presented trends on global health expenditure, HIV/AIDS expenditure & Stephen Few quote
- Kate W volunteered for next DIV meeting
In attendance: Femi, Issaka, Kate, Kimi, Larry W, Mackenzie, Timothy, Randy, Yaa
- SharePoint meeting Wednesday at 3pm for Data Viz Library
- Core Competencies Skill Tree presentation
- PVA BI slides being developed
- Presented on the Pano committees last Friday
- Still waiting Leads feedback
- Awaiting next steps
- Deadline was last Friday
- Presentation by Kate and LaChandra
- Kimi potential for this to be a template going forward? Still need to explore and decide on process for infographic requests
- Nicole shared experience implementing the attribute selector
- Can now optimize the dossier using the attribute selector
- Yaa overview of discussion of innovative analyses (a missing Pano process discovered through waterfall issue)
- This is a subreview after the initial reviews
- HSS has concerns due to number of new content in the works
- Thanks Issaka!
In attendance: Femi, Issaka, Kate, Kimi, Larry W, Mackenzie, Timothy, Randy, Yaa
- Core Competencies: Completed additional tabs: Slack, SharePoint, SQL, QGIS, etc.
- Next steps- begin developing skill trees.
- Request to complete Doodle poll for meeting reschedule. Randy to resend
- PVA BI Trainings: Discussed syllabi for Power BI and Tableau combined training.
- Decisions: Intro section of knowledge checks from previous courses (e.g. MSD, Between the Spreadsheets), choose your path
- Data Viz Library: data governance issues with Github site mean we cannot use for library of internal visualizations.
- Alternative- SharePoint Page Demo. Possible to use SharePoint.
- Next Steps - Explore how to share library with non-USG
- Meeting with Pano Content Developers is in planning
- No feedback from ICPI Leads
- Presentation to Pano Tech Committee, 10/16/2020 @ 10:30 AM
- Pending presentation to Pano Steering Committee, 10/16/2020 @ 1 PM
- LaChandra submitted HRH data, Yaa submitted Financial data
- Randy will follow up on DREAMS data submission
- Schedule call with PET re: Budgets by Program Area
- Plan to submit draft by Friday
- Sign up if interested
- Work begins in FY 21Q1
- Sign up if interested
- Visualizing Uncertainty: https://flowingdata.com/2018/01/08/visualizing-the-uncertainty-in-data/
- Issaka will do next Viz of the week
- Post DRAFT Pano Style Guide on DIV Wiki page
- Follow up with leads re: DIV workplan and Landscape Analysis Tool
In attendance: Alex, Allison, Issaka, Jessica H, Kimi, Tim, Randy, Yaa
- Attribute selector demo - no comments
- Workplan was submitted to leads 9/25
- Will include link (Exemplars of Global Health)
- Multiple ways to explore data across and within countries
- Relies on publically available datasets from World Bank, UN, etc.
- Reorganized pages on DIV Repo WIki
- Team continues to brainstorm, reviewed workplan and milestones
- Developed requirements for Core Competencies and Data Viz Library
- Request to share open source Infographic templates/software
- Held several meetings with Botswana and HSS cluster members
- Meeting held 9/29 to discuss how to address key questions for infographics
- Thanks to Landscape Analysis team for submitting draft tool
- Ready to share with ICPI Agency Leads and broadly
- Organize a meeting with all Pano Content Developers to review results (DIV co-leads will follow-up)
- Brown Bag after Leads Approval
- Next Steps: Standardizing Analysis schedule (annual?), Automation, etc.
- Review PEPFAR Panorama Spotlight Dossiers and Datasets
- DIV will kickoff subgroup next week
- Thanks to Jessica Handy for transitioning recordings to PVA
- Additional Courses: Sharepoint
In attendance: Alex, Allison, Femi, Issaka, Kimi, Mackenzie, Nicole, Tim, Randy, Yaa
- Discussed two Options for Age Disagg Level Selector
-
a) Age Disagg Selector Options: All Ages, Coarse, Trends Fine Age -
b) Age Disagg Selector Options: All Ages, Coarse, Fine Age 2018, Fine Age 2019 - General consensus is that neither option is great.
- Group voted for option A because of correct naming standard for Retired Age Band. Need some additional information about plans to keep 2018 data in dossiers.
In attendance: Alex, Allison, Erin, Femi, Gabrielle, Jairo, Jessica H, Kate W, Kimi, LaChandra, Mackenzie, Nicole, Shaylee, Tim, Randy, Yaa
- Comments on brainstorming and requirements gathering sessions
- Very general timeline for first versions, prototypes for each subgroup
- Specific milestones to be outlined in workplan
- Will share through email for group to comment due to time crunch
- Excellent work Landscapers!
- 10 tabs of analyses produced by the group
- Recommended action items after analysis
- Showed off visualizations
- Group commented on potential next steps (checklist based on the data collection tool)
- Collab with PCDs, Brownbag, etc
- Training scheduled Sept 28th (topics: level selector replacement and unit testing) - calendar invite forthcoming
- Need to replace all level selectors to optimize back-end data
- Coarse age will need to be dropped, can still be sliced by Fine Age or Fine Age groups
- Unit testing introduction as issues still making through QC process
- Jamie showing TX Dossier to show what we mean by level selector replacement
- Issue with semi-fine age vs fine age, 2018-2019
- Tentative approval by leads, final approval tomorrow
- Request may have geopolitical ramifications
- Showed off interesting Baltimore Maps (https://apps.urban.org/features/baltimore-investment-flows/#:~:text=Race%20in%20Baltimore&text=It%20is%20a%20pattern%20Morgan,a%20community's%20health%20and%20vitality
In attendance: Alex, Allison, Erin, Femi, Gabrielle, Jairo, Jessica H, Kate W, LaChandra, Mackenzie, Nicole, Shaylee, Tim, Randy, Yaa
- Femi has joined the team, welcome Femi!
- 3 Subgroups: PVA 201 BI, Better Analysts Subgroup, Data Visualization Library
- Data Visualization Library: 1st meeting reviewed creation of Git Site, software needed and steps. Next Steps to share meeting notes, create instruction guide on how to set up a GitHub Site, exploring Sharepoint Pages as an alternative to GitHub Site (data governance issues)
- Better Analysts/Core Competencies: Randy Review competencies for all analytic tasks & software. Team needs to flesh out initial competencies list. Presented Skill Tree for ICPI Analyst Next Steps: start a GIS core competencies list. Jessica Handy followup with Keifer from GIS, GIS team is working on trainings.
- PVA 201 BI Subgroup:
- - Next Steps: Meeting Notes and Action Items to come!
- Presented on key skills covered on PowerBI and Tableau Training
- Plan to develop BI 201 level course on PVA for release Early December 2020
- Next Steps: Awaiting comments from Asia Region
- Dataset consolidated
- 50% of Tasks completed
- Outstanding tasks: Develop visuals, finalize critical components, finalize Quick Wins, Comment analysis
- Draft tool by this Friday, 9/4
- Plan to complete by 9/15
- Next Steps: Team to share Analysis on next DIV Meeting 9/15
- Request for Infographic from Botswana PCO - How much money the USG is committing to support Botswana's HIV/AIDS and TB programs in COP20? - The health facilities and health districts these funds are supporting & in which ways (TA/HRH/Commodities)? - Who are the implementing partners, how much money they receive to implement which activities - Which programs areas is COP20 supporting and for how many beneficiaries?
- HSS Cluster is currently doing a crosswalk of HRH and ER data so is well placed to answer HRH and Above-Site questions
- Next Steps: Reply to Jamie and potentially coordinate with HSS
- Showed an empty SharePoint page :(
- Post your QC tool in Sharepoint
- Next Steps: Submit QC Tools
- You know nothing about maps, John Snow!
- Next Steps: Jessica H to present next Data Viz of the Week
In attendance: Alex, Allison, Erin, Femi, Gabrielle, Jairo, Jessica H, Kate W, Kimi, LaChandra, Mackenzie, Nicole, Shaylee, Tim, Randy, Yaa
- Difficulty hearing. KP group had a separate demo and see opportunities for developing a cross indicator dossier for KPs.
- Recommendation to listen to recorded meeting.
- Next Steps: Provide guidance on new features and share on GitHub
- Big thank you to Kimi for hosting the office hours!
- Next steps: Post your QC tool in Sharepoint
- Regular biweekly meeting starting next week. Calendars sent.
- Meeting goals: begin active work on Greatest HITS, PVA, Core Competencies
- Next Steps: Reach out to Randy if invite missing or want to be added
- DIV Co-leads discussing BI presentation to Asia Region Advisory board on Aug 26th 11 PM
- DIV will host a Tableau Prep & Desktop training for 24 SI participants
- Plan to engage PVA Subgroup
- Presentation outline shared on call
- Next Steps: DIV members share screenshots of your Tableau Tools!
- Next Steps: Develop slide deck for Aug 26th presentation
- Data Analysis team met to review Kimi's consolidated dataset of landscape analysis with preliminary analyses
- Developed Recommendations for analyses: 1) Counts of responses for all dossier by gaps and good performance, 2) Easy wins summary, 3) Visualizations to group by dossiers or template components, 4) Formal recommendations
- Advise: Make sure visuals follow the Pano Style Guide
- Next Steps: Team will continue to finalize the consolidated tool
- DIV homepage (Code < >): Shows all folders existing currently and also lists associated Repos
- GCB Page will be revived starting next week
- Resources page
- Question: Can Schedule for Panorama Content Development be posted on repo?
- Next Steps: Post PCD Schedule on Github
- Next Steps: DIV Members play around in the DIV Repo
- Florence Nightingale, Crimean War Nurse
- Health statistics and visualizations of Mortality Rates during war
- Published anonymously
- Next Steps: None
In attendance: Alex, Allison, Erin, Gabrielle, Issaka, Jairo, Jessica, Kate W, Kimi, Nicole, Shaylee, Tim, Jamie, Randy, Yaa
- Thanks to all who completed.
- Reviving DIV Repo Use (Yaa and Randy)
- Next Steps: Doodle Polls to schedule routine calls for each activity
- USAID leads drafted questions for PRIME (e.g. purpose of training, scope, applicability, etc.).
- Final decisions will be shared once clarification received.
- Next steps: Share scope, proposed participants with DIV
- Met 2 days ago to review templates.
- Plan to meet on Monday, 8/10, to discuss analytic approach (Kimi is lead)
- Started with Slack (recorded) and GitHub-basic intro vs. project management.
- Jessica needs clarification on approach: 2-part or 1 long recording for 2 GitHub training.
- GitHub for code sharing training (Randy)
- PVA long term commitments: Porting Existing training, BI training.
- Request to have a meeting to see how Jessica ports training over to PVA.
- Broader discussions about how to manage training across all clusters -
- Leads plan to set a system/approach over the next few months (Jamie)
- Next Steps: Randy & Jess to review GitHub for code management/sharing
- Request for analysts to support building or guidance for building QC tools.
- Kimi volunteered to provide TA to PCDs who need help or assistance.
- Randy: idea is to help PCDs think through efficient builds for QC tools and support PCDs who need additional help with builds.
- Next Steps: Collate list of dossiers without QC tools on task manager, requests volunteers. Of note: HSS planned QC tool for Q4 and may need analyst to help with build at Q3
- GitHub website. Goal of visualization library.
- Should visuals be organized by tool or by analysis type?
- Erin, Kimi, Jamie feedback: organize by the latter, Kate: it will remove redundancy with Pano.
- Randy: Group needs to decide how to tag, categorize and default display.
- Need to be thoughtful about data governance and screenshot creation has to follow PEPFAR data governance rules a la Spotlight.
- Additional discussion points: Data Governance rules for maps
- Request: Demo on how to create GitHub website
- Next Steps: Interested parties sign up. Organize first call (Randy)
In attendance: Pilar, Jeff, Anu, Kashmira, Katie, Nicole, Randy, Shazad, Jenny, Katya
- overview of Testing process, timelines
- See issue #124
-
2nd 90 - by June 15th should be ready (Nicole)
-
PAWS meeting - push back given availability
- Randy will be the POC for PVA
- Transcription test
- Turn off side transcription
- Evaluation check
- Quizzes need to be done
- Course launch: tentatively May 20th
POCs
- QC Guide - Nicole
- Style Guide - Aaron
- canceling DIV calendar invite from Katya, new invite will come from Katie
In attendance: Shaylee, Kashmira, Aliyah, Jenny, Kimi, Shazad, Katya, Jamie, Jasmine
- ACTION ALL: please review & provide updates in GitHub ticket by OOB April 15 #117
- ACTION ALL: Propose quiz questions & answers for different sections by OOB April 15: https://github.com/ICPI/DIV/issues/118
- ACTION KASHMIRA: Course evaluation (week of April 15)? https://github.com/ICPI/DIV/issues/114
- ACTION ALL: email sgac training if you don't have access to learn.pepfar.net
- one more video remaining to download from Adobe
- all videos need to be uploaded to PVA; Imran to work with Kashmira on video editing
- TBD timeline
- Are there any outstanding issues?
- Jasmine update:
- two groups moving forward
- updates to existing status quo in Pano, prioritization process includes Roha & Shabeen, updating processes, holding systems team accountable; cataloging existing issues & improvements needed to dossiers & dashboards.
- pano evolution process (led by Jacob D.): style guide, landing page, some visuals will move smoothly into this process, others will need to be reworked. ICPI has access to the 6 dossiers created by Jacob D; review if possible.
- missing: what needs to happen in PEPFAR Data Hub vs. Panorama? e.g. calculated indicators need to be developed by PDH and then can be used by Pano. Loop in PDH folks when calculations for indicators are necessary. Ex: AGYW_PREV - requesting data element names for new indicators.
- two groups moving forward
- GIS cluster working on dossiers for Pano
- ACTION ALL: Jamie will share comments on 6 dossiers from pano evolution process; DIV to review & provide comments - send to Katya & Katie O. (cc Jamie & Jasmine) BY TENT. DEADLINE TUESDAY, APRIL 16.
- HSS Cluster - working on dossier (HRH)
- Henry, Janice, Pilar + 2nd 90 group (Imran, Aliyah, Nicole) + Jacob D. schedule call
- structure of pages using HTML, etc. for navigation
In attendance: Katie O, Shaylee, Jasmine, Nicole, Michelle, Kashmira, Randy, Imran
- Volunteer: Shaylee to review
- Plan - send to OCM to distribute to ICPI after final review from Shaylee
- need to record Aaron's videos - Volunteers: tentative Randy and need to find other volunteers
- Imran - videos are completed, just need to do final editing feature
- One aspect is the style guide (ICPI most involved with)
- Color palettes - next steps are to suggest a few color schemes
- https://icpi.github.io/
- Field users are wanting to pull R code from GitHub
- try to market to external audience
- currently we have no guidelines on management of using GitHub for clusters
- could DIV put forward the minimum guidelines for using GitHub? The DIV could use office hours to work with each cluster to help them.
- help navigate to tool vs the code to the tool
- Imran and Randy will test it out with the TSD and then present to DIV at April 9th meeting
- systems will be setting up a follow-up call with Adobe connect and Jasmine has requested to join this call
- embed the hyperlink in the virtual academy and it will not have subtitles. Kashmira will work on this tomorrow.
- Pano QC is just around the corner, Katie or Pooja will be reaching out soon for assignments on QC.
- DATIM Genie extract in the past has identified issues prior to QC for Pano and MSD. Recommendation would be to pull the genie extract prior to Pano QC and populate tool to test.
- problem is that there is a lot of labor in pulling the genie extract.
- possible solution is to have one person designated to pull everything from genie extract and to make a dataset
- Need to have Pano QCers be people who are not populating dashboards.
- Suggestion to have analyst that populates a tool help QC a totally separate tool.
In attendance: Katie O., Katya, Shazad, Jenny H, Kimi, Shaylee, Randy, Imran, Nicole, Jamie, Jasmine, Kashmira, Jasmine, Pooja, Aliyah
- Action ALL: Please review 5 out of 13 videos recorded, these are on learn.pepfar.net and comment on issue #110
- Schedule recording or find a replacement if you can no longer do it. to review videos- - volunteers needed to review (Katie, Michelle, Kashmira) - by Thursday morning
- editing and casting in process.
-
Action Kashmira: pepfar.net
-
done and done and delete PPR section.
- https://icpi.github.io/
- Coordination cluster is most active in GH. Could be a special case to break these ones out instead of static.
- add issue in DIV repo
- how do you want to get feedback? (via issues)
- Timeline for feedback? (by next DIV meeting, March 8th)
- it would be useful to have info viewed in two ways
- is there some way to test who is using one version vs. the other?
- update testing issue #108
- much more organized using the Analytic repo
- needed more details on what to track on DIV
- the presentation beforehand was a good resource and helpful
- more complicated issues had trouble getting a resolution (PDH issues) - we need to summarize and bring to another group.
- what do we need to summarize to bring to the data management meeting?
- DIV to summarize issues
- send to DAQ -if issue not resolved, DIV to document issues in DIV ticket
-
next meeting on March 12th.
-
R training series - unable to download from adobe connect and the video has to play through before the download. SGAC training team has not had a response yet except "working on it" as of this morning.
-
No other issues found.
In attendance: Shazad, Randy, Dereje, Imran, Aaron, Katya, Shaylee, Jasmine
- Moving meeting to every 2 weeks, 1-2pm on Tuesdays; bigger room (Katya will ask Rebecca)
- schedule video recording w/Katya or Jasmine this week/next week
- check out project page for process overview and outstanding items:
- schedule video recording w/Katya or Jasmine this week/next week
- DIV to review videos
- transcription will be completed once all videos recorded
- see the course on learn.pepfar.net (email Katya & Jasmine if you don't have an account)
- open-edx Q&A - Wednesday 3pm, let Katya know if you'd like to join.
- images in the quiz section
- update title
- handouts not showing
- Shaylee will update SIMs section (checks against SSD)
- latest version in DIV working folder on pepfar.net
- check out interactive webpage for ICPI in the works: https://icpi.github.io
- Jasmine to follow up on Pano style guide
In attendance: Kashmira, Shazad, Katya, Aaron, Shaylee, Imran, Randy, Jamie, Dereje, Nicole, Aliyah, Jasmine, Kimi
- dataset updated, nesting issue resolved (aaron)
- ACTION ALL: please review outstanding issues in the projects and see where you can fill in gaps.
- ACTION ALL:work on quiz questions for your section
- ACTION ALL: use the issues to store materials and collaborate on tasks/issues
- ACTION ALL:please schedule recording times for videos using issue #110
- can images be included in the quizzes? **ACTION: **Katya to check
- casting call (ACTION: Imran -- set up a GH issue)
- difference between between pano & ICPI color palettes
- ACTION Jasmine to follow up with POCs
- move forward with palettes as they are but will need to update materials to correspond with Pano color palettes
- individual cluster decision at this point - move forward or wait until pano color palettes available
- Kashmira & Nicole moving this to a vlog
- QC Guide needs some updates (per new data processes) by Feb. 18
- vlog by Feb.22
- stylistic integrity: ICPI logo, POC, data source and link (if applicable), link code
- ACTION: Katya will send latest QC guide w/updates needed: Kashmira, Kimi, Nicole
- each cluster can have an info page, interactive content
- can demo it
- ACTION: Randy & Imran to set this up, present on progress at next DIV meeting on Feb.19
In attendance: Kashmira, Shazad, Katya, Jasmine, Shaylee
1. Review scripts for the PVA/edX course: PEPFAR Between the Sheets. Thank you to those who have completed your scripts and uploaded it to GitHub.
- ACTION AARON: check w/Aaron on section 4 (quotation - as a text, read aloud, or reference?)
-
ACTION SHAZAD update section 5 on accessing datasets
- ex: there are four structured datasets for PEPFAR, but this training will focus will be on MSD
- (DONE) ACTION KATYA move up pivot charts to after filters, and move slicers after charts
- ACTION SHAZAD: create mock up using HTS pivot table for review at DIV meeting 2/12
2. Review project overview, timeline, outstanding tasks for PVA/edX course
- in video recordings, ensure next video follows previous layout screen, pivot table structure, etc.
- first video to record - accessing data w/Shazad
- use GitHub issue #110 to request date/time for recording, see Katya if need Camtasia or recording software
- ACTION AARON: take a look next week, why there are a series of subfolders that leads to the dataset.
- please review & comment if anything is missing
- at senior staff: rethink what would be useful for skills assessment for clusters along w/LOE
- convert from excel to an online survey platform (Survey monkey, qualtrics? google forms not accessible by DOD).
- complete by start of May 2019
- Kashmira to lead
In attendance: Katie O., Shaylee, Pooja, Aliyah, Randy, Kimi, Jasmine, Shazad, Imran, Dereje
- GitHub Analytic repo orientation
- Moving towards using GitHub for tracking QC and updates
- EVENT: Feb. 12 from 1-2pm training on Analytics repo (ask rebecca to work w/Pilar on room/logistics)
- Still will be useful to have a summary table of who is assigned to what (tag yourself)
- If you need access to the repo, please email Jasmine & Katya/Katie to get access, complete NDA
- ACTION--> GH previous testing schedule - set up one for Q1 (Katya/Katie) , plus due date for products
- Panorama QC testing timeline
- Feb.19 & 20 - testing days for Panorama
- Feb.26 ICPI products due
- ICPI Style Guide & Panorama
- ACTION: ALL Please review & provide comments by Wednesday 9 AM
- Share out of style guide & expectation for use (Leads should enforce, DIV needs to ensure analysts have resources to update tools based on the style guide)
- side-note PAWS: Best practices document in development (Imran, Aliyah, Nicole)
- PEPFAR Virtual Academy – how’s everyone doing on content creation?
- ACTION: Please complete your script (by post in GitHub) by end of this week (COB Feb.1)
- We will review scripts next Tuesday, 2/5
- R training videos -
- ACTION: Kashmira & Rebecca to export Adobe recordings (contact Katya if needed, and to upload to ICPI channel) (note: this does not affect sending out the communication about the R Training series & adobe links)
- Katya can put on ICPI channel, would be good to set up a PEPFAR Virtual Academy course with the R Training series videos
- AOB
Attendees: Pooja, Katie, Shazad, Shaylee, Michelle, Kashmira, Katya, Imran, Brittney S.
Agenda & Notes
- Debrief on open edX workshop & next steps (Katya)
- Training dataset being updated
- search functionality within course site - ask Shayna
- next course may be creating visuals in Excel (102)
- ID course name - 101?
- Timeline - by end of January
- Some videos (beginning) can be completed before Training Dataset
- complete script prior to recording videos
- Do one video and review together for consistency before recording all videos
- Next steps: begin to write script for your section Outline here
- Reviewer for all videos: Katie, Kashmira
- Panorama Q4 clean testing (Dec.28-Jan.2) (Pooja)
- confirmed testers, instructions sent out
- email Pilar & Pooja with any completed testing/questions
- next round - access to Analytics repo
- get list of people to have access to Analytics repo to do a batch training - check w/Jasmine but probably all ICPI
- make sure your GitHub handle has your first name & last name
- ZenHub access
- need to sign an NDA before access to the repo
- GitHub Analytics repo postponed for FY19Q1 testing (February 18-20)
- PAWS (Imran)
- building out visuals, doc issues in Slack
- Treatment cluster - second 90
- most ideal dataset - fully long dataset
- complicated with combo graphs
- drill down is cool
- possibly present at Inbrief - Jan.7th
- December/January meeting schedule updates (Katya)
- cancelled until Jan.8
- R Training Videos (Kashmira)
- Travis & Anu working on videos, estimated to finish by end of this week
- Shazad completed video
- AOB
Attendees: Shaylee, Pooja, Shazad, Catherine, Imran, Jasmine, Katya
Agenda & Notes
1. Working session: update Pivot Table Training Outline for edX workshop
- updated session outline
- further tasks assigned
- if you are attending and didn't an email to set up accounts, please let Katya & Jasmine know ASAP
2. Pano Q4 clean testing
- Testing schedule Q4 clean: January 2nd
- Q4 initial list https://github.com/ICPI/DIV/issues/101
- Add Ed - he is testing too
- Note issue in GH Ticket during testing
- Has the issue been resolved? Follow-up from systems needed.
- Summarize all issues found
- Janice will be backup while Ana is on leave
3. Potential Q1 updates in Pano
- dashboards moving to dossiers prioritization
- As part of prioritization, build in dossier/Analytic workspaces to move to Panorama
- Mock-up visuals in analytic workspaces
- Refresher for ICPI (tbd)
4. R Training videos
- tbd
5. Screencast recording software
- identify what you can get from your agency
- other options: Powerpoint, Adobe, Camtasia
6. PISA 2.0 Resources compilation
- proposal for PISA 2.0, which will be aimed at a wider, less-technical audience than PISA 1.0.
- gathering content that could be used to develop foundational systems trainings on a very basic level (i.e. what are the major systems, what do they do, how do they support PEPFAR’s mission, who uses the systems, etc.).
- see email attachment for resources list
Attendees: Shaylee, Katie, Imran, Aaron, Brittney S., Jamie, Katya
Agenda & Notes
1. Update on Pano testing (Katie)
- deadline COB today, 9/25
- issue with Eswatini MSD
- any errors found tomorrow will not be updated until next release
2. Pano dossier (soft-launch) (Katie, Jamie)
- some dashboards have been moved into dossier in Pano, won't be visible to public
- 50 people will be given user accounts to view dashboards in dossier (soft-launch using new ETL) = ICPI 20 spots of 50 (mix of data/program staff)
- backend isn't quite ready -> soft-launch of a few dashboards (OUxIM, testing visuals, continuum)
- access on Oct.1, want feedback on user interface and functionality (is it too slow?)
- Jasmine compiling 20 ICPI people
- workspaces pointing to old ETL, need to change this to new ETL, need to set up clearance & QC processess
- dashboards currently built in analytic workspaces will need to be rebuilt using new ETL
- next step: best practices to update dashboards in dossiers - needs to be defined (Ana)
- next step: can Pano team provide list of criteria for assessing dashboards in soft-launch
- Jamie supporting, (Jason -- Eboni & Kristin)
- map viewer -> Visual Crossing in Microstrategy will go live with dossiers (no maps created as of date), will create LOEs for maps
3. Pano Q4 (Katie/Jamie)
- no new items
- only bug, APR/Q4 calculation fixes
- prioritized dashboards for dossier based on # hits in sharepoint/Pano (Treatment continuum, TSD, viral load, PMTCT, VMMC)
4. R Training
- R training session 3 & 4 scoped out - Anu reviewed all the functions; Jamie to share GH ticket for session 3 & 4 from Leads meeting on 9/24;
- Dates: October 18-19, proposed 1.5 days training (wrangling full day, visualization half day)
- Content development/review: Travis (Imran to reach out)
- Training management -
- Communication/admin - icee/kashmira
- Training guidance/eval - div
- Content leads - Travis, Imran, Anu
- next steps: Jamie to follow-up on training management at ICPI
5. FY19 ideas (Katya)
- workplan + SOW review on pepfar.net
- plan to move training materials (GitHub, R, Tableau, data viz) to EdX; awaiting EdX orientation/plan from Shayna
6. FY18 summary doc (Aaron)
- AOB?
Attendees: Katie, Jess, Shaylee, Jasmine, Jamie
- Identify analytic questions for POART calls, does this fall to the DIV? (question from Jasmine)
- ICPI tools have a lot of analytic questions already - could be cross cutting? - more to think on this one from DIV perspective - R training - need to get an update from Shazad and if he needs any support to let us know - 26 responses - seem to be on track for content - there may be an issue with the dates for session 2 and 3 due to people being out
- Open EDX - 4 ICPI members that have credentials for Open EDX - Katya had issues with uploading tableau training content - would be good to have additional projects to upload - suggestion would be to upload R training - There seems to be an issue with uploading older presentation material since it is not a training following the Open EDX framework - ACTION ITEM- at next inbrief, as for volunteers that have created training to upload trainings via Open EDX (ex. R training, TSD training, GitHub training)
- Pano testing - data closes tomorrow - same process in previous quarters (there will be both a SIMS and MER structured dataset) - testing datasets should be available by the 17th but glitch with HTS to accommodate more rows of data - if ETL rework is delayed, Jess will confirm via email and GitHub ticket - please loop Pooja in on all things related to this
- AOB - Jess' last day Aug 31 - Katya changed the calendar invite to her name - DIV co-leads working through transition (ex. Pooja won't make inbrief slide but copy her to provide input)
Attendees: Aaron, Shazad, Jess, Brittney S., Catherine, Imran, Shaylee, Katya, Michelle
- Admin
- SoW (Leads reviewing final SoW)
- Workplan/GitHub issues - Two treatment repos - Imran will delete one and document
- Calendar invites (resending calendar invites from ICPI shortly)
- QC Guide - issue #82, comment and provide any feedback by COB Friday, 8/3
-
Tableau training best practices/evaluations
- print out copies of evaluations for future training, build in time for evaluations maybe an hour before concluding. report-out in small groups.
- suggestions: advanced topics
- online training? EdX; using handouts. (Catherine interested in online training)
- Follow-up from July 16 meeting
- Github Basics (Katie O.)/Advanced (Aaron) - all good and done :)
- Tableau server pilot? (Brittney S.) - State has server, looking to see if they can give access to others. Working with Kristy & Abe on it.
- AOB?
- R Training (Shazad/Imran)
- looking into open EdX for R training
- Imran scripted out sessions 1 & 2 (3hrs)- visuals; might need to be split out into 3 sessions
- Imran out next month (Aug6-Sept4)
- Core competencies of data management; mock run through took longer.
- Shazad developing slides
- save the date went out for Aug.23
- need to finalize registration & pre-training assessment
- identify presenters
- need: meeting to review all questions, logistics, script & slides review
- Shazad to schedule meeting w/core group on Thursday
Attendees: Catherine, Shaylee, Katie O., Imran, Yaa, Jess, Brittney S., Katya
- DIV Visualization Best Practices presentation for Zambia rTDY
- please review and make updates as needed so we can have a standardized orientation to data viz best practices/DIV for introducing to new staff/visitors.
- Updated SOW
- please review and comment on issue/word doc by COB Tuesday 7/24, as this is due to leads by end of July
- QC Guide
- Katya to send out Leads Feedback to full DIV if others can assist; Shaylee to review and revise by Friday, July 27.
- R Utilities/Functions (Aaron)
- Brown-bag scheduled for August 2nd
- R Supplemental Training (Shazad/Imran)
- core competencies built out, will discuss first two sessions (basics of R, run through Tidy data); each session builds on previous. contact imran/div if you are able to support this training. Katie O. attended virtual R training and shared materials previously. Customizing training materials for ICPI.
- GitHub basics (Katie) & Advanced (Aaron)
- Katie O. creating GitHub 101 session; skeleton of presentation completed. Creating project for HEI dashboard as example. Scheduling meeting to discuss 101 presentation - anyone else interested? (Katie O., Katya, Imran, Shaylee)
- Tableau Server Pilot @ State
- Brittney Shook to inquire.
- CDC - one team procured Tableau licenses (where B.Baack sits); on program team don't have licenses. Discussions to see what Tableau needs are within CDC Team. Exploratory phase with CDC ICPI team. Loop in Jamie about Tableau Server vs. individual licenses.
- Tableau training reboot @ PC Aug.21 or 22 - let Katya/Annie Schwartz if you are interested.
- detailed handouts from training were helpful (Catherine)
- analytic workspaces - handouts were helpful to have and follow (Katie O.)
- AOB?
MER Revision - Panorama changes given reporting frequency changes with indicators (Yaa O.)
- what does this mean for some indicators (e.g. PVLS)?
- Kristine C. & David N. looped in PDH team
- data will be shown for quarters it is reported in future based on changes, but will not show retroactively if it was not required to be reported in previous quarters.
- what stage are the prioritizations for visuals put off until Q4? (Yaa/Jess): revisions not accepted at Q3 b/c of switch to 'dossier' to 'report builder'. Unclear at this point - meeting on Thursday and may be more info at that point.
- Should new messaging to go out to clusters that updates to tools can be made quarterly/easily? Clusters/ICPI will not be required to make updates to visuals but developers will continue to do the basic quarterly updating of visuals. If there is a change to a visual that may be more tricky.
- Katie O moving PEDS to workspaces - bring to cluster leads to prioritize building tools in analytic workspaces. Take it to the next level. Discuss w/Jasmine on timeline and next steps for building in analytic workspaces. Maybe do a hackathon?
Update on Tableau training Other items ?
- Current sprint https://github.com/ICPI/DIV/issues/78
- Style guide - Catherine can support, reach out to Aaron & Brittney B.
- Bring in GIS folks - Shazad/Imran to loop in GIS for style guide
- Katie O. powerpoint presentation on GitHub basics, Michelle will join
-
GitHub workshop
- Aaron developing materials - presentation linked
- QC Guidance review
- Shazad QC Template
- R Training - update to be provided at next mtg.
- Shazad/Imran
- Tableau training content development
- Naming conventions - revisit? was it effective?
- can we move the date to the beginning?
- are people following the convention? Imran & Catherine to check out stats on pepfar.net
- bring up at next all staff meeting
- Current file located in DIV Resources folder
- Review of membership list and Github list
- Volunteering isn't working, who has bandwidth and can support DIV activities sprint
- Katie O. will begin review
- current membership list stored under workplan
- Panorama
- big thank you
- release delayed due to bug w/cumulative values
- pano will go live tomorrow 5/23
- Jess will post updated version of issues tracker
For Tuesday’s all DIV meeting, please come ready to talk about what you’re currently working on for DIV as it relates to the current/recent sprints, and any issues/risks you’ve encountered or foresee. We’ll also talk briefly about the analytic workspaces meeting for Thursday. April 16 – May 1 sprint: https://github.com/ICPI/DIV/issues/70 May 1 – 15 sprint: https://github.com/ICPI/DIV/issues/78
Updates: Tableau training R Training GitHub Best practices document? Done? Disseminate?
Attendees: Yaa, Tom, Katie O. Shabeen, Jess, Shaylee, Imran, Shazad, Catherine, Aaron, Katya
• Integration of SIMS into analyses
• Catherine
○ smaller discrete tasks
• Shazad
○ color palette vlog release this Thursday
○ R reboot: use core competencies and outline session
• Imran
○ R reboot, CDC - workshop using R for DGHT meeting, might be useful for R reboot
○ Set for July
• Shaylee
○ Vlog
○ Can work on other guidance
• Jess
○ Reviewed BI tickets in GitHub
○ Old tickets in GitHub or stay in Excel
• Yaa
○ Trying to rengage
○ 10%, interest with BI
• Tom
○ KP data and completeness of data
○ SME
• Shabeen
• Katie O.
Attendees: Kimi, Noah, Jess, Michelle, Catherine, Shaylee, Katie O., Aaron, Imran, Yaa
- Continue discussion on leads feedback & plan for ongoing and next sprints
- Tracked edits to feedback can be found on pepfar.net
- see file:
- Review Leads feedback & plan for updates (Jess/Katya) (15min)
- Analytic workspaces plan (Brittney/Jess) (10min)
- Tableau training (Katya)
- AOB
-
QA/QC --> coordination cluster
- Updating best practices on QC for ICPI?
- Scope of this for DIV
-
Backend building in Excel: is this the future?
- Need to provide support for field to use with in-process data
- Prioritize setting up in back-end excel tool
-
Analytic workspace
- Review list of assignments
- ICPI will receive some support from developers
-
Next steps
- Review Leads feedback by end of this week and be prepared to identify which projects you want to participate in sprint teams coming up
- Next meeting to discuss and plan - 4/16 or 4/17 next week
- Presentation to ICPI Leads
- SOW
-
Workplan
- send your membership/role by Wednesday OOB.
- Record Vlog
- Intro to ICPI Color Palettes
- Naming Conventions
- Others?
- AOB
- Send your membership info to Jess & Katya
- Any comments on presentation, SOW, workplan
- Reviewed presentation, SOW and workplan.
Viz Library
- Held sprint in December
- OCM knowledge management within scope too
- Handed off attribute list & survey to OCM
- Are we still tagging products?
- OCM activity
Core component
- Visualization Library put in GCB (SOW & workplan)
- Best practices & visualizations
- Create a visualization library that would act as best practices or examples others would follow
- How to present data better?
DAQ & DIV Collaboration (Kristy)
- ICPI trainings - data management, processing, software, structure datasets for software, best practices around software; datasets in analytic workspaces
- Innovative data mgmt and viz methods
- Headquarters & field based
Field engagement
- Menu of services/sample activities that DAQ could provide field with
- Engage with SI Advisors
- Specific examples of services
- DIV - broad services can offer and specific examples
- Collaboration with other clusters
Keep in mind: Defining analytic questions
- Systems training - defining analytic questions
- DIV could possible create a training material around that
Best practices in starting up a tool
Participants: Kristy S., Imran M., Katie O., Aaron C., Katya N.
- AC downloaded all outbrief slides - how could we improve some of the visualizations? Use a teaching moment
- Visuals that didn't fit into narrative, even though cool didn't get input
- Source info for each of the slides
- Errors in Panorama - not DIV responsibility to fix
- These issues could be raised by Jess during DIV meetings
- Would be helpful to know if others have same issues before submitting ZenDesk ticket (or going through to confirm issues are real issues)
- How to make this info more accessible to Pano users?
- Within Panorama - show which issues have been identified on a support page in Pano
- Ex: issues fixed emailed out to Pano users recently
- Teams mistrust Pano data
- Panorama support page
- Put ongoing tickets in a table form and status of zendesk tickets relevant to data issues
- Review (developer/pano team) to look at the issues that is actually something wrong and not a misunderstanding of data (some ppl send in requests data is wrong)
- Next step: Kristy --> mock up a layout for Pano issues
- Follow up with Jess
- Contact: Katya & Katie O.
- power users meeting to be held on Thursday 10am-12pm, could go longer if needed
- objectives:
- to identify best or good enough practices to use with ICPI datasets
- to zero in on objectives for the training
- see issue #28 draft outline and Feb.12 planning meeting notes
- Guide users on best practices - e.g. when to start a repository
- Training on github
- Put vlogs on youtube
- Propose private and public channel for ICPI *Aaron will start working on github to refine ICPI pages
- Training dataset - created to be used in trainings
- Making Github easily accessible to country teams
- Contact: Aaron (Imran interested in video too)
- Propose review and presentation
- Contact: Aaron
- New logo - review & presentation (Aaron)
- Cluster branding & icon (Aaron)
- Panorama tickets viewing on support page (Kristy mockup, Katya bring up at OCM)
- f/u Jess on Q2 requests (Katya/Katie)