Category: Enterprise DNA

How the DAX Calculation Engine Works

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

Continue reading

What is context transition and why does it matter?

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

Continue reading

Why Power BI is very quickly going to get huge!

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

Continue reading

Transformative role of Big Data across Industries

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

Continue reading

Driving Business Results using Customer Data Analytics

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.

Continue reading