Website Analytics in My Pocket Using Microsoft Fabric

on YouTube ↗20m

" summary

Builds a pocket-sized website analytics dashboard using Cloudflare GraphQL API to pull daily and hourly stats, stores raw JSON files in a OneLake lakehouse with year/month/day folders, and flattens nested data via Data Factory copy activities into tables. Removes Google Analytics for a privacy-first setup, collects data since September 2023 because Cloudflare only retains 30 days, and visualizes trends with Power BI mobile layout that updates nightly — shows views down but unique visitors rising, and the pipeline and dashboard work as demoed.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 1:13What is Microsoft Fabric
3. 3:01Moving from Google Analytics to Cloudflare
4. 4:49Cloudflare’s GraphQL API
5. 8:26Setting up the data pipeline
6. 13:22Loading and transforming data
7. 15:55Visualizing in Power BI
8. 18:04Mobile dashboard summary

" related talks

• 38mMeasure performance with web-vitals.js, Google Analytics, and BigQueryTony Conway · Google I/O 2022
• 47mData analytics for the era of AIPatrick Baumgartner, Amir Netz, Swetha Mannepalli, Miwa Monji, Arun Ulagaratchagan, Justyna Lucznik, Ron Chang, Thasmika Gokal, Nimrod Shalit, Nandini Srinivasan · Microsoft Build 2023
• 26mReal Time analytics - Sense analyze generate insights with FabricKevin Lam, James Hutton, Tzvia Gitlin · Microsoft Build 2023
• 50mFabric: What's new and what's nextAmir Netz, Arun Ulagaratchagan, Flavien Daussy, Adam Penhaul · Microsoft Build 2024
• 39mEmbedded Analytics through Data APIDionizas Antipenkovas · Big Data Conference Europe 2019
• 31mAction-Packed AnalyticsSteve Ganem · Firebase Dev Summit 2016
• 37mMeasuring 2.0 – Building the next generation webanalytics ...Niels Basjes · Berlin Buzzwords 2016
• 49mExtend and enhance your analytics applications with Microsoft FabricDipti Borkar, Teddy Bercovitz · Microsoft Build 2024