Season 2 Case 3: Grand Theft Kusto
The Digitown crimewave continues. Captain Samuel Impson needs our help to find the stolen motors.
The Digitown crimewave continues. Captain Samuel Impson needs our help to find the stolen motors.
Scammers are targeting the citizens of Digitown. But where’s the Mayor?
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....
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?...
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....