How I built a daily-load app for business users in Microsoft Fabric with Rayfin and github copilot

Another year, another FabCon. After Vienna in 2025, it was time for Barcelona in 2026.

Over the past years, I've worked in many different data roles. When I started my consulting career, I was hired as a BI Consultant. The funny thing? I had no idea what BI,  Business Intelligence actually was. My first customers were pure BI consulting engagements. Back then, a BI Consultant was typically defined as someone who:

Never trust a runtime upgrade until you've actually tested it.

I recently decided to put Claude to the test. Build my first skill and challenge it. For the first time!

The Medallion Architecture Unveiled: Why the Business Should Care (And Why AI Still Needs It)

In my previous blogs, I compared several data patterns and discovered something interesting: no matter which architecture we look at, the same recurring pattern keeps showing up.

In my last blog I wrote about the pattern of a core data flow which evolutes from the BI core definition from the 90’s. We also have seen a tradition BI example on SQL server with STG, DWH and DM concepts.

Oke, I'll be honest:

In the previous blog, we explored my data journey to answer one key question: What is BI?Now, let’s continue that journey and see how this connects to broader data patterns and data flows.

So, like everybody I sat down to put Rayfin to the test. The plan? Make an app for our metadata file, simple. Spoiler: it worked. Eventually.