Optimizing GitHub License Usage for a Fortune 100 Enterprise
By integrating GitHub, HR, and SSO data into a unified Tableau dashboard, a Fortune 100 company uncovered inactive users and streamlined license management, saving over $270,000 annually.
88.000+
Company size
Pharmaceutical
Industry
AWS, Python, Snowflake, Tableau
Technology
$270.000
Saved
Challenge
Managing over 9,000 GitHub licenses across 20 GitHub organizations became costly. At $21 per user per month, there was no easy way to see who was active, and what “activity” means. From commits to reviews to occasional logins, there was no simple way to determine it.
Solution
We integrated GitHub REST and GraphQL data with internal SSO and HR sources and brought it to Snowflake. This data is also used for other use cases. We built a Tableau dashboard that shows user activity and enriched it with HR data. Managers could filter, review, and trigger license revocation requests directly from the insights.
Results
The dashboard immediately identified ~1,100 inactive accounts. Their licenses were revoked, saving to Pfizer over $270,000 per year while improving visibility and governance across all development teams.
Tired of doing data on your own?
You can book a free consulting call with us.
Let's discuss the problem and come up with a solution.
