Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: Slicing the Bridge

13 April 2021

Welcome back to the Power Pivot Principles blog. This week, we will create a slicer to filter out the summary table.


A to Z of Excel Functions: the IPMT Function

12 April 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the IPMT function.


Charts and Dashboards Blog: Introducing the Camera Tool for Dashboards

9 April 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will introduce a handy tool when creating dashboards – Excel’s Camera tool.


Power BI Blog: Even More on the Decomposition Tree Visualisation

8 April 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will continue his look at the Decomposition Tree visualisation.


Power Query: Flat with a View

7 April 2021

Welcome to our Power Query blog. This week, I look at how to improve the memory used when loading my flat file query to Power BI Desktop.


Power Pivot Principles: How Did I Bridge the Gaps?

6 April 2021

Welcome back to the Power Pivot Principles blog. By popular demand, I will revisit last week’s scenario and show you how to build a so-called “bridging table”.


A to Z of Excel Functions: the INTRATE Function

5 April 2021

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the INTRATE function.


Charts and Dashboards Blog: Conditional Donut Chart – Part 3

2 April 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will get the data label in the “conditional donut chart”.


Power BI Blog: More on the Decomposition Tree Visualisation

1 April 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will continue his look at the Decomposition Tree visualisation.


Power Query: Flat Out

31 March 2021

Welcome to our Power Query blog. This week, I look at ways to improve the memory usage of a query involving flat files.


Newsletter