Please note javascript is required for full website functionality.

Blog

Power Query: Join or List – Part 3

14 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table, this time, with approximate matching.


Power Pivot Principles: The A to Z of DAX Functions – CUMPRINC

13 December 2022

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at CUMPRINC.


A to Z of Excel Functions: The NORM.INV Function

12 December 2022

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


Charts and Dashboards: Vertical Raincloud Chart Part 1

9 December 2022

Welcome back to our Charts and Dashboards blog series. This week, we’re going to look at how to make a bespoke Vertical Raincloud chart by creating the first of three charts that we will need.


Power BI Blog: Datamarts – Part 3

8 December 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the differences between a datamart and a data warehouse.


Power Query: Join or List – Part 2

7 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table.


Power Pivot Principles: The A to Z of DAX Functions – CUMIPMT

6 December 2022

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at CUMIPMT.


A to Z of Excel Functions: The NORM.DIST Function

5 December 2022

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


Charts and Dashboards: Custom Axes – Part 3

2 December 2022

Welcome back to our Charts and Dashboards blog series. This week, we complete this method of customising our axes as we format the Error Bars to create customised gridlines.


Power BI Blog: Datamarts – Part 2

1 December 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the most common forms of datamarts.


Newsletter