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.

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.

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!

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

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.

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.

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

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.

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

Welcome back to the Power Pivot Principles blog. This week, we’ll continue last week’s example, which we are going to turn into a large case study over the next few weeks.