Initially, I wanted to create a single report to motivate managers to look at GitHub issues. It didn't help (yet), but I got hooked and added more selectors and features to this report, making it a full-featured website, where you can compare different types of activity on different repositories, find the key team members and their contribution patterns, etc.
Source code: https://github.com/ClickHouse/velocity
(I recommend checking commit messages - I saved every single prompt as a commit)