Season 2 Case 3: Grand Theft Kusto

The Digitown crimewave continues. Captain Samuel Impson needs our help to find the stolen motors.

June 18, 2023 · 3 min · 475 words

Season Two Case Two: Here Phishy Phishy

Scammers are targeting the citizens of Digitown. But where’s the Mayor?

June 4, 2023 · 2 min · 397 words
Continuous Delivery Boxes

Fabric Power BI CI/CD with Azure DevOps

CI/CD Comes to Power BI with Microsoft Fabric Super excited about this one. WIth the recent announcement of Microsoft Fabric, Power BI now has git integration. We can now version control our reports and datasets, and use Azure DevOps to deploy them to the service. How cool is that? Check out the doco at https://learn.microsoft.com/en-us/fabric/cicd/git-integration/intro-to-git-integration So let’s take a look at how this works. A Simple Report First, let’s make a simple report....

June 2, 2023 · 4 min · 753 words

Season Two Case One - I've Got The Power

The Case Mayor Gaia Budskott is facing an electoral calamity. Utility prices are surging, voters aren’t happy and the outlook for the upcoming election is not good. Once again, Mayor B has turned to us to bail them out solve the problem. The billing system is super legacy, has very questionable data quality and is running something called “SQL”. Never heard of it, must be from the 70s. So, a political crisis bought about by out of control utility bills?...

May 25, 2023 · 2 min · 255 words

Season Two Onboarding - Show Me The Money

The Case It’s Kusto Detective Agency time again! And this time it’s Lieutenant Laughter who needs our help. Serously? Lieutenant Laughter? Sounds sketchy, I’ve a feeling LL is going to turn out to be Professor Smoke. So our problem is to find the detective who made the most money in 2022. One nice addition to this year is the “Train Me” button which gives some great examples of how to explore the data....

May 25, 2023 · 2 min · 314 words