X to the Z (or ∑)
One of the things you learn as you start to get comfortable with DAX is that what you thought was …
Power BI
006: Video Games are here
Dataset 006 is deliberately simple, Video Games and their sales. While there is no Date dimension to it, there is …
Power BI is 5 and our next step
So with Power BI hitting five years old, I’ve been looking back at what I’ve done in Power BI. I …
That Cycle of Continual Improvement
Continual Improvement isn’t a dirty word, instead it is the gateway to a better way of thinking, stop pushing to …
005: Stacking it up
The ability to use Dataflows to collate your data and spread the load on your production or report servers is …
Performance Enhancing Tools
Power BI Continuous Improvement cycle invariably has an element that looks at improving the performance of your queries. DAX can …
Is it time to call time on Visual Studio?
It’s definitely an emotive topic this one. Visual Studio does a lot of what Power BI Desktop does (in the …
Dataset 007: Loans, Process Loans
Dataset 007: Loans Loans is going to be about ensuring that what you report is what you’re doing. KPI’s are …
Dataset 006: Power BI’s dangerous mindset
I’m going to get such a reputation, I love KPI’s but I’ve seen them used badly too many times. A …
006: I can write DAX in Power BI
Suddenly it’s time to move on from the easy world of drag and drop and quick