Initiative: Dashboards planning

[ExperimentsInHonesty]

Overview

We need to identify and start building a roadmap for all the website dashboards, so that we can prioritize, manage and recruit.

Details

There are:

• live dashboards
• dashboards in dev
• proposed dashboards
• dashboard ideas

See resources for all the issues we were able to find

Action Items

• Find all dashboard issues
  • rationalize labels on repos other than website, so that they match the website repo's name of label
  • make sure all issues that come up in a search for dashboard on the target repo, have the specific dashboard label
  • review each issue within each dashboard label and add the relevant issues to the Resources section below (relevant is defined by being useful to present and future management of the dashboards. e.g., an closed/resolved issue to fix a spelling mistake on the dashboard).
  • Places to check
    • Internship project
    • Data Science
    • Website
    • Team Analytics
• Find any related WIKI pages (checking same repositories)
• Create Roadmap
  • Create Google doc for roadmap
  • Format Document
    • Separate Users and Location into two Headings under each roadmap
  • organize in order of priority
  • Identity what information is missing
  • ??
• Create or revise issues for each dashboard

Resources/Instructions

• A shortcut to the new dashboard Google Drive from the Website Team Google DriveGoogle Drive, Website, PM, Dashboard
• Google Drive, HfLA: Dashboards
  • HfLA website: HfLA Dashboard Development Roadmap
    • HfLA website: Dashboard Roadmap: Skills / Productivity
    • HfLA website: Dashboard Roadmap: Issues
    • HfLA website: Dashboard Roadmap: Org Dashboard
    • HfLA website: Dashboard Roadmap: Participant Record
    • [HfLA website: Dashboard Roadmap: Repo Statistics]

List of Repos involved

• https://github.com/hackforla/website
• https://github.com/hackforla/internship
• https://github.com/hackforla/data-science
• https://github.com/hackforla/team-analytics

Dashboard Summary

• skills / productivity ladder: A daily snapshot of a software developer’s journey on the website team. It will show where they are on their ladders for issues, PRs, PR reviews, issue making, and team leadership responsibilities and what specific that are skills obtained not obtained by completing the assignments as well as efficacy of their PR reviews and aggregate performance of peers.
  • users: interns, website volunteers, all open source volunteers (mvp is website/interns, v1 is all hfla projects, v2 is a generic version for any open source project)
  • location: internship and website team project boards
• dashboard (needs to be renamed org dashboard): organizational data about Hack for LA appears at hackforla.org/dashboard
  • users: see doc
  • location: see doc
• issues dashboard:
  • audit of issues, showing where they are on the project board, and any that have anomalies. We use this dashboard to know which issues to clean up.
  • Summary stats of how many issues are in each column by role and size. Which enables us to see where we need to make
    • users: leads
    • location: website team project board
      new issues.
• participant record dashboard: For viewing the amount of time you self reported working on the project. Used in connection with a participant record google form. This dashboard was used in the 2022 Internship team cohort only. The purpose was to teach interns how to use participant records and to incentivize them to put in the time they promised, given that we did not have set hours for the internship.
  • users: interns and people who need verification of their hours by an external entity (school, justice system, visa, etc.)
  • location: Internship project board, in offer letter
• repo statistics: this dashboard shows maturity of repository and areas for improvement
  • users: repository managers (PM, maintainers, etc.)
  • location: Civic Tech Structure website

Dashboard URLs

• skills / productivity
• dashboard
• issues dashboard
  • Spreadsheet: Labels for Weekly Label Check List of labels that have to be updated if labels change or are added
• ladder progress dashboard
• participant record dashboard
  • TWE: IS22 Participant Record - makeup entry - form

Project board for all Dashboard Issues

P: HfLA Dashboards: Project Board (view)

Website

• All Dashboards
  • wiki pages
    • https://github.com/hackforla/website/wiki/Introduction-to-the-Project - contains history of the website and will need to be updated when new dashboards are added to the website.
• skills / productivity dashboard
  • label: feature: skills / productivity ladder dashboard
  • Issues
    • ER: Create a skills dashboard #4532
      • Google Drive folder for the issue 4532
• Dashboard
  • label: p-feature: Dashboard
  • Issues
    • ER: Fix dashboard data script (workflow) #6229
    • ER: Add analytics about how many people we reach to the Dashboard #4537
    • ER: Get Google Data Studio up to date so that we can use it for insights and its ready for launch #4276
    • Create Organizational Dashboard page #542
    • Setup Google Analytics on website #503
• Issues dashboard
  • label: feature: Issues dashboard
  • issues:
    • ER: Fix dashboard data script (workflow) #6229
    • Create a Chart in Looker Dashboard Visualizing Audit of Issues with Missing Labels Over Time #5813
    • Create Landing Page for Anomaly Report in Looker Dashboard #5812
    • Create Label Report in Google Spreadsheet #5810
    • Create Project Board Looker Dashboard for Different Roles  #4921
• ladder progress dashboard
  • label: feature: ladder progress dashboard
  • Issues
    • Analysis: Collecting Data on Issue Completion per Prework Author and Creating Looker Dashboards to Uncover Insights #4152

Internship

• skills / productivity dashboard
  • label: feature: skills / productivity dashboard
  • wiki pages general
    • https://github.com/hackforla/internship/wiki/Business-Analyst-Data-Science - landing page for business analyst on internship programs to find links relevant to their work.
    • https://github.com/hackforla/internship/wiki/The-2022-Internship-Program-Process-Overview - history and improvements to the internship project. Update this WIKI page when needed to add information about the skills dashboard.
  • wiki pages
    • RP016: https://github.com/hackforla/internship/wiki/Research-Plan-16:-Intern-Productivity-Dashboard-Survey
      • Issues:
        • none
  • wiki page
    • RP017: https://github.com/hackforla/internship/wiki/Research-Plan-17:-Activity-Dashboard-Interviews
      • Issues
        • Interns Skill dashboard requirements #7460
        • TWE: Research: RP017: Data: Analyze internship#493
        • [TEST] TWE: IS22: RP017: Presentation Slide Deck: Create internship#475 (if this issues results in a finished presentation of findings artifact, we will need to review that)
      • TWE: Create Research Plan for RP017 internship#442 (we should review this plan to see what other research about the dashboard is needed)
      • RP017: Productivity Dashboard Intern 005 Interview Upload internship#271 (relevant because it has a link to the one recorded interview)
  • wiki pages
    • RP002: https://github.com/hackforla/internship/wiki/Research-Plan-2:-Hack-for-LA-volunteers-transferrable-skills
      • Issues
        • Extrapolate the skills for the interns internship#63
  • Issues general
    • TWE: Research Structure for RP017: Productivity Dashboard Interviews internship#291
• ladder progress dashboard
  • label: [feature: ladder progress dashboard]
  • will be used by the internship project when it's working on website team activity
• participant record dashboard
  • label: feature: participant record dashboard
  • Issues
    • TWE: IS22: Create a customized time card dashboard internship#254
    • Set up intern time card Data Studio dashboard and Google Sheet  internship#213
    • TWE: Draft time card setup solution for interns internship#193
    • It's possible that there are research findings for the participant record that would have been collected during the exit interviews. Review with internship research lead when appropriate.

Data Science

• All Dashboards
  • wiki pages
    • https://github.com/hackforla/data-science/wiki/Introduction-to-Keeping-Confidential-Information-Safe-on-GitHub%3A-GitHub-secrets-and-.env-files - developer resource for all dashboards.
• Issues Dashboard
  • label: feature: Issues Dashboard
  • wiki pages
    • https://github.com/hackforla/data-science/wiki/Our-Work - every dashboard that is completed should be linked to this page
    • https://github.com/hackforla/data-science/wiki/Interactive-Looker-Dashboard-for-the-HackforLA.org-Website-Team - related to issues dashboard
  • Issues
  • CoP: Data Science: Survey: Repo Labels data-science#160

team-analytics

• org dashboard
  • label: [P-Feature: Dashboard]
  • Issues
    • MVP Requirements for Type of Data team-analytics#2
    • MVP for GitHub Actions (GHA) team-analytics#1
    • MVP User Stories for Issue/PR Velocity Analytics via GitHub API team-analytics#3

---

All dashboard epics

Participant Record

• Epic: Epic: Participant Record Dashboard #7509
• Assignee: Sofiat

Org

• Epic: Epic: Org Dashboard #7506
• Assignee: Eleftherios

Skills/Productivity Dashboard

• Epic: Epic: Skills/Productivity Dashboard  #7539
• Assignee: Phalguni

Issues Dashboard

• Epic:Epic: Issues Dashboard #7505
• Assignee: Amen