Epic: Skills/Productivity Dashboard

[mayankt153]

Dependency

• Updating the Interns Skill dashboard requirements #7460 issue

Overview

We need to manage the work for the skills/productivity dashboard, so that we can prioritize and recruit.

Action Items

• Go the skills tab for skills/productivity dashboard and copy all the links in the issue to a comment in the bottom of the issue and indicate whether they are public or private.
• Copy all the link lists from the issues into a comment on this issue
• Remove duplicates
• Remove the intern numbers and add back the respective GitHub handles to all spreadsheets in Google Drive HfLA Dashboard, folder: Skills Dashboard
• Clear all PII from Google Drive HfLA Dashboards so that it can be made public
• Revise Skills/Productivity Dashboard Roadmap

Resources/Instructions

Related Issues

• Project Board HfLA Dashboards: Project Board skills
• All Dashboards Epic: Initiative: Dashboards planning #6614
• Requirements Issue: Interns Skill dashboard requirements #7460
• Extrapolate the skills for the interns: Extrapolate the skills for the interns internship#63
• TWE: Create Research Plan for RP017: TWE: Create Research Plan for RP017 internship#442
• TWE: Research: RP017: Data: Analyze: TWE: Research: RP017: Data: Analyze internship#493

Roadmaps

• Roadmap HfLA website: HfLA Dashboard Development Roadmap
  • Roadmap HfLA website: Dashboard Roadmap: skills/productivity ladder
  • Skill / Productivity roadmap: HfLA website: Dashboard Roadmap: Skills / Productivity Ladder

Google Drives and Folders

• Google Drive, Dashboard Skills Dashboard Drive Folder
• Google Drive, HackforLA.org website, 5-Data Analytics > GitHub Data Analysis Folder
• Google Drive, Internship, Internships >
  • IS21 cohort - brentwood only >
    • folder: LinkedIn Analysis
    • folder: Skill Analysis
    • folder: Intern Drive
  • Research > 1. Research by Participant Type > 2. Intern >
    • RP017 - Intern Activity Dashboard Interview
• Google Drive, Internship PII
  • Recording: Interview Recording on 2022-07-13

Prototype Dashboard

• V1
  • Internship Dashboard
    • View
    • Edit
• V2
  • CTJ : HfLA Skills and Experience Matrix - Labels will come from this spreadsheet

Prototype Data

• Internship data set
  • Spreadsheet: IS21: Skill Audit
    • located in Internship > Internships > IS21 cohort - brentwood only > Skill Analysis (has PII, and we will need Rabia to make a version and relink it to the current demo so that it's movable to the new dashboard drive)
    • New spreadsheet link without PII: IS21: Skill Audit - PII removed
    • This spreadsheet was created by analyzing the files in the LinkedIn Analysis folder - see Google drives above
      • IS21: UI/UX and Software Engineering Interns Value Delivered
      • IS21: Project Management Intern Value Delivered
  • Spreadsheet: IS21 Stand Up Roll Call, IS21: productivity results for engineering and ui/ux
    • located in Internship Google Drive > Internships > IS21 cohort - brentwood only, Intern Drive
• Website team data set
  • Spreadsheet: Prework_Analysis_2 (Complete)(03/26/2023)
    • located in Google Drive, website > 5-Data Analysis > GitHub Data Analysis > Prework Analysis
    • Spreadsheet with accurate numbers as of 03/26/2023

Hack for LA GitHub Actions that support Dashboard

• Repo: live-dashboard-automation, tab: Actions
• schedule_run_to_update_data.yaml] confirm that these workflows are part of the org dashboard and are not used in the issues dashboard, or are they used in both
  • Repo: live-dashboard-automation, tab: code /.github/workflows/schedule_run_to_update_data.yaml
  • Repo: live-dashboard-automation, tab: code /.github/workflows/schedule_run_to_update_data.yam#L56-L58
  • Linguist: https://github.com/github-linguist/linguist

Code

• Internship Repo, Label Page

Documentation about prototype building process

• Slides: GitHub Class on Dashboard Creation 11/13/2023 - Interactive Looker Dashboard using GitHub Data (presented by Kimberly Tan)
• Google Doc: Documentation: GitHub API and Dataset Analysis - written by Kimberly Tan

Tutorials, Help files and Community Discussion boards

The below links are from all issues that have been worked on that are related to the dashboard. Because we have several dashboards being developed we have organized a list of all tutorials on the Hack for LA Data Science repo wiki, called Dashboard Resources. If you add a new tutorials to any issues related to this dashboard, make sure they get added to the wiki.

• GitHub Docs: GitHub REST API documentation
• GitHub Docs: GitHub REST API endpoints for rate limits
• YouTube: Using Google Sheets API to add and refresh dataframe in Python to Google Sheets
• YouTube: Google Sheets API Automation in Python
• Medium Article: Write and Append Dataframes to Google Sheets in Python

Research related to Dashboard

• Google Drive Folder: RP17 Google Folder this folder will be made public in the future.
  • Google Doc: TWE: Research Roadmap: Interns
  • Google Doc: TWE: RP017: Intern Activity Dashboard Interview Research Plan
  • Google Doc: TWE: IS22: RP017: De-identified Interview Transcript
  • Google Doc: TWE: IS22: RP017: Intern Activity Dashboard Case Study Report
• WIKI page: Repo: Internship, WIKI RP017 Activity Dashboard Interviews
• Recording folder Interview Recording on 2022-07-13 - this requires access to the PII drive

Examples of how to organize Research, when we later do research on this dashboard

Examples of how to organize Research

• WIKI template - Template for presenting research on wiki
  • related to how the Internship team structures their research wiki pages
• Research Output Overview wiki page
  • all research for the Internship team. We have linked the relevant research above.
• UX Research Guides Templates
  • templates for doing research.

[ExperimentsInHonesty]

Yingie from the TWE (internship) project let us know that the intern number on the dashboard does not match the intern roster. When we start making cleanup issues, we will need to sort that out.

[ExperimentsInHonesty]

All old issues for this dashboard

• ER: Create a skills dashboard #4532
• Analysis: Collecting Data on Issue Completion per Prework Author and Creating Looker Dashboards to Uncover Insights #4152
• TWE: Research Structure for RP017: Productivity Dashboard Interviews internship#291
• Extrapolate the skills for the interns internship#63
• RP017: Productivity Dashboard Intern 005 Interview Upload internship#271
• TWE: Create Research Plan for RP017 internship#442
• [TEST] TWE: IS22: RP017: Presentation Slide Deck: Create internship#475
• TWE: Research: RP017: Data: Analyze internship#493
• Interns Skill dashboard requirements #7460
• Epic: Skills/Productivity Dashboard  #7539 - this link is this issue

[ExperimentsInHonesty]

This has been processed into an organized list and added to the top of the issue.

All the links from above issues

• Task List Dev Leads
  • Have access, its located in ____
  • public
• Dashboard Drive Folder
  • have access, its located in HfLA Dashboards -> Skills Dashboard
  • public
• IS21: Skill Audit
  • I don't have access - located in Internship > Internships > IS21 cohort - brentwood only > Skill Analysis (has PII, and we will need Rabia to make a version and relink it to the current demo so that it's movable to the new dashboard drive)
  • public
• live-dashboard-automation
  • Have access, its located in ____
  • public
• GitHub API Documentation
  • Have access, its located in ____
  • public
• GitHub Rate Limiting
  • Have access, its located in ____
  • public
• Link to GitHub Data Analysis Folder
  • Have access, its located in HackforLA.org website folder -> 5-Data Analytics -> Github Data Analysis
  • public
• Spreadsheet with accurate numbers as of 03/26/2023
  • Have access, its located in HackforLA.org website folder -> 5-Data Analytics -> Github Data Analysis -> Prework Analysis
  • public
• Documentation: GitHub API and Dataset Analysis
  • Have access, its located in someones private drive
  • public
• Google Sheets Tutorial Links:
  • Using Google Sheets API to add and refresh dataframe in Python to Google Sheets
  • Write and Append Dataframes to Google Sheets in Python
  • Google Sheets API Automation in Python
    • Have access, its located in ____
    • public
• Slides: GitHub Class on Dashboard Creation 11/13/2023 - Interactive Looker Dashboard using GitHub Data (presented by Kimberly Tan)
  • Have access, its located in ____
  • public
• Internship Repo, Label Page
  • Have access, its located in ____
  • public
• TWE: Research Roadmap: Interns
  • I do not have access - located in Internship> Internships > Research > Research by Participant > Intern (this document will be made public in the future.
  • public
• Repo: Internship, WIKI RP017 Activity Dashboard Interviews
  • public
  • Have access, its located in ____
• WIKI template - Template for presenting research on wiki
  • public
  • Have access, its located in ____
• Research Output Overview wiki page
  • public
  • Have access, its located in ____
• UX Research Guides Templates
  • public
  • Have access, its located in ____
• Linkedin Analysis folder
  IS21: UI/UX and Software Engineering Interns Value Delivered
  S21: Project Management Intern Value Delivered:
  • I do not have access, located in Internship Google Drive > Internships > IS21 cohort - brentwood only, LinkedIn Analysis
  • public
• Intern Drive folder
  • I do not have access, located in Internship Google Drive > Internships > IS21 cohort - brentwood only, Intern Drive
• Spreadsheet: IS21 Stand Up Roll Call, IS21: productivity results for engineerin and ui/ux
  • I do not have access, located in Internship Google Drive > Internships > IS21 cohort - brentwood only, Intern Drive
  • public
• Skill Analysis folder
  • I do not have access, located in Internship Google Drive > Internships > IS21 cohort - brentwood only, Skill Analysis
  • public
• IS21: Skill Audit Spreadsheet
  • I do not have access, located in Internship Google Drive > Internships > IS21 cohort - brentwood only, Skill Analysis
  • public
• Internship Dashboard - skills
  • Have access, its located in ____
  • public
• Tech Work Experience
  • Have access, its located in ____
  • public
• RP17 Google Folder
  • I do not have access, located in Internship Google Drive > Internships > Research > 1. Research by Participant Type > 2. Intern > RP017 - Intern Activity Dashboard Interview
  • public
• Internship Wiki, Join the team page
  • Have access, its located in ____
  • public
• Research Plan Creation - Issues Tagged
• Google Drive Research by Type Folder
  • I don't have access
• TWE: Research Plan Template
  • Have access, its located in ____
  • public
• TWE: How to Write a Research Plan
  • Have access, its located in ____
  • public
• Wiki Intern Research Overview Page
  • Have access, its located in ____
  • public
• RP017 Research Plan
  • I don't have access
• RP017 De-identified Transcript
  • I don't have access
• Google Drive Folder: Research by Plan # and Name
  • I don't have access
• TWE: Slide Deck Template
  • I don't have access
• TWE: Research: RP017: Data: Analyze internship#493
  • Have access, its located in ____
  • public
• Project Board: Initial Setup internship#2
  • Have access, its located in ____
  • public
• Research by Participant Type Folder on Google Drive
  • I don't have access
• Overview of writing a case study analysis in business
  • Have access, its located in ____
  • public
• Sample case study analysis
  • Have access, its located in ____
  • public
• Article that provides background/definition of case study - It also includes example case studies as well as a checklist for assessing the quality of a case study report;
  • Have access, its located in ____
  • public
• Case Study Methodology of Qualitative Research: Key Attributes and Navigating the Conundrums in Its Application
  • Have access, its located in ____
  • public
• Case Study Method: A Step-by-Step Guide for Business Researchers
  • Have access, its located in ____
  • public
• Methodology or method? A critical review of qualitative case study reports
  • Have access, its located in ____
  • public
• UCSF libraries case studies research guide - It includes books, resources/examples, and latest articles on case studies as a research method
  • Have access, its located in ____
  • public
• TWE: Research: Checklist for Case Study internship#492 (comment) - This issue comment provides more context on the checklist this issue is following
  • Have access, its located in ____
  • public
• RP017 De-identified Transcript
  • I don't have access
• RP017 Case Study Report
  • I don't have access
• IS21 Skill Audit
  • I don't have access
• HfLA website: Dashboard Roadmap: Skills / Productivity Ladder-
  • I have access
  • Public
• HfLA Dashboards: Project Board, skills
  • Have access, its located in ____
  • public
• HfLA website: HfLA Dashboard Development Roadmap
  • I have access
  • Public
• All Dashboards Epic: Initiative: Dashboards planning #6614
  • Have access, its located in ____
  • public