Interactive Looker Dashboard for the HackforLA.org Website Team
Timeline: ...
Partners: Kimberly Tan
Tools Used: Jupyter Notebook, Libraries/packages (requests, pandas, json), GitHub REST API documentation
The purpose of this project was to create an interactive dashboard in Google Looker for developers to see number of issues per complexity level and their status in each project board column. The dashboard can be updated automatically and allows issues to be filtered by complexity, role, and progress labels, in order to review the overall status and anomalies detected among issues.
The high level process overview is as follows:
-
Create a GitHub token to maximize REST API requests allowed per hour
-
Use Python to retrieve data from GitHub using GitHub REST API
-
Explore the retrieved data
-
Design the dashboard and datasets needed
-
Clean and manipulate data to create datasets
-
Use Google Developer Console and Google Sheets API to populate blank Google Sheets with Python DataFrame
-
Connect Google Sheets to the Looker dashboard
-
Create the Looker dashboard
-
Check the accuracy of data and metrics in charts
-
Set up GitHub Action to run scripts on schedule and on-demand
Interactive Looker dashboard that tracks the number and status of issues in specific columns of HackforLA’s GitHub Kanban project board and detects anomalies, making life for developers a little easier!
