Analysing Customer Sales by RANKX() and “What If” Parameters

This post aims to show how to use a combination of the RANKX() function and the Power BI “What-If” parameters to analyse monthly sales to find out which customer has the highest, lowest, and average sales/spending growth. The formula used to calculate the sales trend is: the margin of the current month sales to the […]

Business Intelligence is not a Competitive Advantage, it’s a MUST HAVE

It is no secret that in order to make intelligent business decisions, all business data needs to be effectively sorted through and analysed. More and more organisations are realising the strategic importance of data quality which has led to new classes of data analysis tools emerging. When it comes to data quality, we must remember that “you can’t fix what you can’t measure”. This is why Business […]