hackforla
Interns Skill dashboard requirements
Dependency
- [x] https://github.com/hackforla/website/issues/6614 - While this issue is not closed, it has transitioned the work for this dashboard to this issue
Overview
We need to identify and list out the requirements for the Skill dashboard in order to facilitate the work for a developer.
Details
We will recruit a developer to help us with creating labels (via GitHub Action) for the skills that interns develop during their internship.
Action Items
- [x] Provide list of data (see below)
- [x] Identify which data will require prep work before it will be available, and sort into two lists
- [ ] Identify what additional help will be needed on the project (see prep work)
- [ ] Review all the links and organize them into the Resources section below
- [x] Create Spreadsheet (version analysis feature sets)
- [ ] Go through the Roadmap and find any features/requirements it mentions, adding to a comment below
- [ ] move the data to the sheet
- [ ] Review V1
- [x] find additional features
- [x] indicate all the features it has and write any notes
- [ ] Get sign-off
- [ ] Review V2
- [x] find additional features
- [x] indicate all the features it has and write any notes
- [ ] Get sign-off
- [ ] Review each open and closed issue to determine if there were other requirements, not developed, but talked about (even if they were dismissed)
Production
Phase 1
- Released for production - https://github.com/hackforla/ai-skills-assessor/issues/3
Resources/Instructions
- Data IS21: Skill Audit - PII removed
- Dashboard Internship Dashboard
- Find WIKI page for your role Internship Wiki, Join the team page
- HfLA website: Dashboard Roadmap: Skills / Productivity Ladder
Related Issues
- Epic Dashboards planning: https://github.com/hackforla/website/issues/6614
- https://github.com/hackforla/internship/issues/442 is the research plan to find out how an intern received the dashboard tour
- https://github.com/hackforla/internship/issues/493 will have the findings from the data analysis.
Github references
- https://github.com/github-linguist/linguist
Epic
- https://github.com/hackforla/website/issues/7539
List of data needed (review to divide up into two categories - ready and needs prep work)
- Group (e.g. IS22)
- Intern #
- Name of Intern
- GitHub handle
- Issue (Issue #)
- Complexity
- PR (null/pr #)
- Is Review
- Suggested changes (null/T/F)
- Missed something (null/T/F)
- Description
- Value
Needs prep work
- Skill Type
- This will need a label
- Skill
- This will need a label
Requirements documents
- Issue related to this issue: Extrapolate the skills for the interns hackforla/internship#63
@ExperimentsInHonesty Provide Update
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (if necessary): "Add any pictures that will help illustrate what you are working on."
@bonniewolfe Please provide update
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (if necessary): "Add any pictures that will help illustrate what you are working on."
- hackforla/internship#442 is related to this issue, and hackforla/internship#493 will have the findings from the data analysis.
- Progress: I met with Neema from the Data Science Community of Practice, and she will work on this.
- Blockers: I need to make time to meet with her, and find out if anyone else on the team wants to be part of these conversations
- Availability: None, I will pick it next week.
- ETA: 1-2 months
I need to meet with Neema again and the Data Science community of practice on 2024-02-19
Starting to put together a Roadmap for this dashboard HfLA website: Dashboard Roadmap: Skills / Productivity Ladder
- [ ] All the links in this issue will need to be checked to see if we have access
- Epic: Dashboards planning #6614
- [ ] Have access, its located in ____
- [x] public
- IS21 Skill Audit
- [x] need access, located in Internship Google Drive > Internships > IS21 cohort - brentwood only, Skill Analysis
- [ ] public
- Internship Dashboard
- [ ] Have access, its located in ____
- [x] public
- Internship Wiki, Join the team page
- [ ] Have access, its located in ____
- [x] public
- HfLA website: Dashboard Roadmap: Skills / Productivity Ladder
- [x] I have access located in HfLA Dashboards -> Skills Dashboard
- [ ] public
@Mayank2808sharma
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, October 8, 2024 at 12:05 AM PST.
@Mayank2808sharma
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, October 15, 2024 at 12:04 AM PST.
@Mayank2808sharma
Please add update using the below template (even if you have a pull request). Afterwards, remove the '2 weeks inactive' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, October 22, 2024 at 12:04 AM PST.
Hi @bonniewolfe : I have updated the Dashboard. Please take a look and share any feedback or comments you may have Dashboard - Skills - Competitive or Comparative Analysis Template
@Kphalguni
Please add update using the below template (even if you have a pull request). Afterwards, remove the 'To Update !' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Monday, January 6, 2025 at 11:04 PM PST.
Hi Bonnie Please find my comments: Progress: I have updated the Dashboard. Please take a look and share any feedback or comments you may have Dashboard - Skills - Competitive or Comparative Analysis Template Blockers: Availability: ETA: Pictures (optional):
As discussed today, - I have updated dashboard
Dashboard - Skills - Competitive or Comparative Analysis Template
Progress: a) Dashboard Intern Skills: Provides high level update on the Dashboard. b) Added a new tab "overall skills Type" describing the different performed tasks on each page. Blockers: Availability: ETA: Pictures (optional):
@Kphalguni
Please add update using the below template (even if you have a pull request). Afterwards, remove the 'To Update !' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Monday, February 3, 2025 at 11:04 PM PST.
Status update:
Progress: I have completed mapping of skills under "overall skill types & skills performed" tab - Dashboard - Skills - Competitive or Comparative Analysis Template Blockers: Availability: ETA: Pictures (optional):
Status update:
Progress: I have completed mapping of skills under "overall skill types & skills performed" tab - Dashboard - Skills - Competitive or Comparative Analysis Template Blockers: Availability: ETA: Pictures (optional):
-
[x] Please review this comment and see if all of the items in here are on the epic
-
Comment to resolve (on this issue): https://github.com/hackforla/website/issues/7460#issuecomment-2381254595
-
https://github.com/hackforla/website/issues/7539
@Kphalguni
Please add update using the below template (even if you have a pull request). Afterwards, remove the 'To Update !' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Monday, February 17, 2025 at 11:04 PM PST.
Status update: Progress: (a) Skills Dashboard is complete - Dashboard - Skills - Competitive or Comparative Analysis Template (b) Issue copied to the main epic- Epic: Skills/Productivity Dashboard #7539
- https://github.com/hackforla/website/issues/7460#issuecomment-2661607467
- https://github.com/hackforla/website/issues/7460#issuecomment-2351739555
- https://github.com/hackforla/website/issues/7460#issuecomment-2351739567
- https://github.com/hackforla/website/issues/7460#issuecomment-2351739573
Blockers: Availability: ETA: Pictures (optional):
Questions
Q: How often does the data refresh now?
A: 15 min
Q: How often do we want it to refresh?
A: 15 min during testing, 12 hours during actual use, unless we learn that it could be refreshed earlier without utilizing too many resources, which might cost us money, or make the system work slower for other users in our network.
Testing
- I tried adding a fake row to the IS21: Skill Audit - PII removed, NEW FORMAT tab - row 98 but it didn't refresh on reload.
- I went to ChatGPT and executed these instructions in looker Open your Looker Studio report. Click on Resource in the top menu. Select Manage added data sources. Locate your data source and click Edit. Click the Refresh Data button (circular arrow) in the report toolbar to manually reload the data.
Screenshots
- So, I think that means this is not the spreadsheet that is connected to the data. Is that the PII version?
- Also, where are we at, on cleaning up the version we were working on (to remove the tabs that are unnecessary for the people on the project moving forward).
Added two resources to https://github.com/hackforla/data-science/wiki/Dashboard-Resources#looker
- Looker Studio Help: Refresh data source fields
- Looker Studio Help: Manage data freshness
Any users that authored tickets or contributed to tickets, and then delete their GitHub account, will have their issues attributed to https://github.com/ghost This means that we will no longer be able to display their data on our dashboard.
- warning on dashboard, that if a GitHub account is deleted, we can no longer display the data.
Also... if a user types a GitHub handle that does not exist (e.g., typo), we should have some kind of error message if possible. If not possible in looker, have a warning message that says if you see zero hours for a GitHub handle, confirm its a active user with Hack for LA, by going to their GitHub profile and looking for the Hack for LA logo, under Organizations
- [ ] We need to make an issue to review the CTJ engineering matrix against the (skill type/skill task) matrix we have
@Kphalguni
Please add update using the below template (even if you have a pull request). Afterwards, remove the 'To Update !' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, March 11, 2025 at 12:05 AM PST.
Status Update on (skill type/skill task) matrix
Progress: I have updated the columns A & B by matching with the file CTJ engineering matrix
Blockers: A few rows are left blank in columns(A&B) - need help in assigning them to the right category
Availability: ETA: Pictures (optional):
@Kphalguni
Please add update using the below template (even if you have a pull request). Afterwards, remove the 'To Update !' label and add the 'Status: Updated' label.
- Progress: "What is the current status of your project? What have you completed and what is left to do?"
- Blockers: "Difficulties or errors encountered."
- Availability: "How much time will you have this week to work on this issue?"
- ETA: "When do you expect this issue to be completed?"
- Pictures (optional): "Add any pictures of the visual changes made to the site so far."
If you need help, be sure to either: 1) place your issue in the Questions/In Review column of the Project Board and ask for help at your next meeting, 2) put a "Status: Help Wanted" label on your issue and pull request, or 3) put up a request for assistance on the #hfla-site channel. Please note that including your questions in the issue comments- along with screenshots, if applicable- will help us to help you. Here and here are examples of well-formed questions.
You are receiving this comment because your last comment was before Tuesday, March 25, 2025 at 12:05 AM PST.
Status Update : Progress: Completed aligning and labeling of task items in "all labels" tab. Rows marked in yellow are line items picked from "overall skills type & skills performed tab" -Dashboard - Skills - Competitive or Comparative Analysis Template Blockers: Availability: ETA: Pictures (optional):