Microsoft Fabric & Power BI

Coastal Analytics: Real-Time Surf Intelligence

Automated data pipeline for predictive recreational planning

A serverless data pipeline built entirely within Microsoft Fabric. Ingests weather API data via Dataflows, processes it with Power Query, and delivers "Go/No-Go" decision metrics through a mobile-optimised Power BI dashboard.

100%
Automated Runs
Fabric
Native Platform
<5m
Refresh Latency
Hourly
Refresh Rate

Project Overview

Problem

Surf conditions are complex and fleeting. Checking multiple weather sources manually resulted in missed optimal sessions.

Approach

Built a "Personal Data Engineer" pipeline using Microsoft Fabric Dataflows to ingest and transform weather API data, applying custom logic (Wind < 15km/h + Swell> 1m) to generate a binary "Surf Score".

Automation

Scheduled refresh via Fabric's built-in orchestration. Power Automate sends mobile notifications when conditions match the "Golden" criteria.

Live Dashboard

Technical Stack

Ingestion

  • Fabric Dataflows Gen2
  • Power Query M
  • REST API Connectors

Orchestration

  • Fabric Scheduled Refresh
  • Power Automate Flows

Visualisation

  • Power BI Service
  • Mobile Layout
  • Real-time Tiles