search

hackforla / data-science

The Hack For LA Data Science team is a Community of Practice within the LA brigade seeking to make analytical and machine learning services available to local communities and organizations.
28 stars 17 forks source link

Refining the Requirements for Skills Match Dashboard #189

Open n2020h opened 1 year ago

n2020h commented 1 year ago

Overview

We need to gather previous relevant documentation of features and functions skills dashboard and refine requirements, so that we can develop it.

Action Items

Resources/Instructions

https://docs.google.com/spreadsheets/d/1SV0j3NKcjOpHuT3okyM36xwWA966hNA4N1zmqRtd8B8/edit#gid=11574199

n2020h commented 1 year ago

image

n2020h commented 1 year ago

image

ExperimentsInHonesty commented 10 months ago

Use Google App Script to poll GitHub label and issue APIs write results to spreadsheet use spreadsheet as data set for looker dashboard views

ExperimentsInHonesty commented 10 months ago

The intern dashboard https://lookerstudio.google.com/s/pvg4HLLgeiM

n2020h commented 8 months ago

Working on this issue on a feature branch: https://github.com/hackforla/data-science/tree/n2020h-issues-to-csv Update: Used GH actions to create csv of issues and labels, see output file - issues.csv

n2020h commented 8 months ago

Connected output "issues.csv" to Google Sheets file: https://docs.google.com/spreadsheets/d/1LVOGU1aVcruOGAhi4C4U1wLqUeVovkx0AOKLnE2gAtg/edit?usp=sharing Connected Google Sheets to Looker report: https://lookerstudio.google.com/reporting/e5a6534d-edb8-41b4-a76a-832824e00d80

n2020h commented 3 months ago

Updating Google Sheets file to mirror source file for original dashboard. Current blockers:

  1. How to access the functions to create the specific charts from original dashboard.
  2. How to automatically connect PRs, projects to relevant issues. Which field(s) connects these? Currently, I've found links to specific issue links in various places in the json: Examples: issue_url, timeline_url, in the Body of PR and in Reactions

Working file: https://docs.google.com/spreadsheets/d/17gmu3U7_BaLMIVT6SfVY7qz-0yApbA1OaO0_3-Ri7Ko/edit?usp=sharing

n2020h commented 2 months ago

Looker dashboard in progress: https://lookerstudio.google.com/s/v1h7xSJvLVs