Breaking down the way DAX works The DAX engine is a complex beast. How it stores the data, then works through it to calculate answers is quite spectacular. Let’s step back for a moment though and try to distill it down into some simple steps, that we can memorise and intuitively start iterating over when
Category: Enterprise DNA
One of the key concepts in DAX Context transition is one of the tougher concepts to know and understand well in the DAX language. Why do you even need to know it? Well, if you want to create calculations within calculated columns that reference columns from another table or if you want to run a
The growth opportunity for Power BI is massive I am basically convinced that Power BI is about to explode into the most used enterprise analytical tool around the world in no time. I’m imagining we are out the back of a set of waves, the crest has only just appeared on one, but it will
We’ve all heard the buzzword “Big Data“ and frankly you maybe even a bit tired of hearing it. Although the term is too generic and often improperly used, it is not just a hype. It’s a quiet revolution. The age of data-driven management has already arrived and those that don’t adapt will be stomped out
Just a decade or two ago we were running weekly, monthly and quarterly reports, at the end of each reporting period. Based on previous years and current trends we would try to forecast our revenue, calculate customer churn rate and some even dared try to calculate marketing campaign ROI relying on hefty amount of assumptions.