In this demo I show you how to get long term statistics in GitHub beyond the short history that is shown in the GitHub portal. With this demo you can see historical data for your GitHub repositories traffic and visualise that with Power BI or consume it in the tool of your choice. We store the data in a SQL Database in Azure and get the data from the GitHub API using a Logic App. This can be useful to see which of your repositories are popular, as well as finding out how many people are using your content and code. Instructions for this demo are at https://github.com/davedoesdemos/gith... if you want to try this for yourself.

0:00 - Introduction to the demo
1:43 - Set up a personal access token in GitHub
2:23 - Create Azure resources Logic App and SQL Database
4:43 - Set up the SQL Database firewall for access
5:09 - Create the database
6:04 - Create the Logic App
15:51 - Example of the PowerBI Dashboard
16:44 - Wrap up

For all of my other demos, go to https://davedoesdemos.com or go straight to the GitHub page at https://github.com/davedoesdemos/Demo.... Also please subscribe to the channel to make sure the latest demos show up in your playlist!