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. π
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. π
Speakers
Cathrine Wilhelmsen's previous sessions
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. π
Β
Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory
Learn the pros and cons of Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory, and how to choose the right Data Integration solution for your project.
Β