More VBA optimisation tricks so you can stop reticulating splines.

Utilising Get Data from an MS Access database in Power BI.

Welcome to our Power Query blog. This week, I look at some ways to determine the end (and the start) of a particular date period in M.

Welcome back to our Power Pivot blog. Today, we discuss how to use filters in Power Pivot.

This function converts a text representation of a number in a given base into a decimal number (base 10).

VBA Blog about improving calculation speeds.

One of the neat things about Power BI is the large number of connectors to Get & Transform data. We’ve been working with flat files until now but to realise the full potential of Power BI, we’re going to start having to work with REAL data.

Welcome to our Power Query blog. This week, I look at some useful ways to extract data from dates in M.

Welcome back to our Power Pivot blog. Today, we expand upon our previous blog on PivotTables with Power Pivot.

On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.