Function Return Types in Power Query

Power Query

This blog is about function return types in Power Query in Power BI. This article may be more technical than our others but it’s a good read for Power Query enthusiasts or people wanting to make their M code bulletproof. Have you ever modified a column with a function in Power Query where that column […]

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 […]

Power BI Design Modes – Live Connection

  SQL Server Analysis – Services Database In this mode the model components and definitions such as tables, columns attributes and datatypes, relationships, hierarchies, calculated tables and calculated columns are implemented in a semantic SSAS model and Power BI is used just for report presentation. The measures can be created either in SSAS model or in […]

Data Analytics in the Retail Industry: Gain & Maintain A Competitive Advantage

The retail industry is experiencing never-seen-before digital disruptions from online and instant shopping to quick home deliveries. In times of new experiences, it is vital to understand the drivers behind the perceived behaviour – especially when it comes to differences in sales revenue. Retailers who use data analytics in their organisations are ahead of the curve when […]

Why Power BI Training is Important

Why Power BI Training is Important It isn’t difficult to understand that businesses are able to improve their everyday decisions when they are armed with business insights from their organisational data. Once data has been processed and visualised in a useful way, it can be properly applied. The latest in data analytics technology – such as Microsoft Power BI […]