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 …
Data Processing; why?
Power BI uses Tabular Data Models, these are models that are optimised in a very different way to traditional database …
Power BI’s not so dirty secret
When this feature first came out in 2018 it was a complete game changer. It wasn’t until 2019 when data …
DAX – Not as easy as it looks
Learning DAX has some real hurdles to overcome, here is some real sage advice. https://sqlbi.com are a great source of …