Using CROSSFILTER and USERELATIONSHIP in PowerBI

Using CROSSFILTER and USERELATIONSHIP in PowerBI

DAX is HARD Another Friday, another day of infinite struggle. To say DAX is not beginner friendly would perhaps be a huge understatement, and while there was a public holiday between days of training, it was still just as brutal. Fortunately, in the mass of...
How to Generate Good Data in Mockaroo

How to Generate Good Data in Mockaroo

For our final week in training at The Data School, we had the opportunity to create our own datasets to answer a question of our own choosing using Mockaroo. This is a fantastic website that can be really tweaked in any way you want, especially in practicing creating...
How to Prepare for a Teaching Session

How to Prepare for a Teaching Session

A few weeks have passed since we were given the opportunity to teach a free session open to the public as part of the Learn What the Data School Learns (LWTDSL) initiative. Predictably, our manager assigned us all topics we were unfamiliar or uncomfortable with as a...
Dashboard Week #5 – Harry Potter

Dashboard Week #5 – Harry Potter

For the final day of Dashboard Week, we were given a light and enjoyable dataset for once, no more depressing data about the state of the world or how crime and inflation are going up. Instead, we were given information on the Harry Potter films. The various sheets...
Dashboard Week #4 – Big Fish, Little Fish

Dashboard Week #4 – Big Fish, Little Fish

Day 4 of Dashboard Week and its back to Power BI, this time however, the data was actually very clean, and didn’t really require any Alteryx work to get into a workable state. The data was also very open-ended, we were given a choice amongst the 17 Sustainable...