SQLBits 2024

Website Analytics in My Pocket Using Microsoft Fabric

Join this session to see how easy it is to create a pocket-sized dashboard for your website analytics. First, learn how to automatically collect statistics from an API and store it in a central location. Then, see how quickly you can visualize the data in a mobile-friendly way using Power BI. 📈
As a technical blogger and event organizer, I'm always curious about my website traffic. How many visitors have I had? Where are they from? What days and times are my websites most popular? Which posts are read the most? 🤔

All of this information is available to me. There's only one gotcha: the data is only available for the past 30 days. That means if I want to compare how my website is doing next year compared to this year, I need to save the data somewhere else so it doesn't get lost - and build my own visualizations on top of it. Luckily for me, that's what I do for a living! 🤓

In this session, I will show you how I've used Microsoft Fabric to create a pocket-sized dashboard for my website analytics. First, I will explain how I automatically collect statistics from an API and store it in a central location. Then, I will show how easy it is to visualize the data in a mobile-friendly way using Power BI. 📈