Please note javascript is required for full website functionality.

Blog

Power Query: Emerging from a Muddle

3 March 2021

Welcome to our Power Query blog. This week, I look at a more efficient way of merging the data from last week, again when there is not a clear link between the tables


Power Pivot Principles: Sensitivity Analysis

2 March 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll perform a sensitivity analysis for different rates of Goods & Services Tax (GST) on the Sales transactions.


Monday Morning Mulling: February 2021 Challenge

1 March 2021

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI 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.


Final Friday Fix: February 2021 Challenge

26 February 2021

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!


Power BI Blog: Different Coloured Columns in a Chart

25 February 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will look at how to create different coloured columns in a column chart.


Power Query: Merging Muddles

24 February 2021

I have some sales contact data for my imaginary business. Unfortunately, I have some complaints and I want to allocate them to the correct salesperson.


Power Pivot Principles: Creating a Disconnected Table for GST

23 February 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll continue last week’s example, and build on the mistake of not including a Goods & Services Tax (GST) on the Sales transactions. For this week, we will create a disconnected table for GST.


Charts and Dashboards: Bullet Charts – Part 2

19 February 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we continue our review of Bullet Charts.


Power BI Blog: Dynamic Headings for In-Between Variables

18 February 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we’ll discuss another approach to dynamic headings, this time for variables between two periods using a time slicer selection.


Power Query: Don’t Miss Out

17 February 2021

Welcome to our Power Query blog. This week, I look at the Excel.Workbook() M function


Newsletter