Please note javascript is required for full website functionality.

Blog

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.


Power Query: Join or List – Part 1

30 November 2022

Welcome to our Power Query blog. This week, I begin a series of blogs comparing alternative approaches to extracting data from another table.


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

29 November 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 CROSSJOIN.


Monday Morning Mulling: November 2022 Challenge

28 November 2022

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: November 2022 Challenge

25 November 2022

On the final Friday of each month, we are 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 are playing for bragging rights only!


Power BI Blog: Datamarts – Part 1

24 November 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at datamarts, and how they are different from datasets.


Power Query: Flexible Appending – Part 4

23 November 2022

Welcome to our Power Query blog. This week, I explain how to change data types dynamically.


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

22 November 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 CROSSFILTER.


A to Z of Excel Functions: The NOMINAL Function

21 November 2022

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


Charts and Dashboards: Custom Axes – Part 2

18 November 2022

Welcome back to our Charts and Dashboards blog series. This week, we’re going to continue looking at one way to customise our axes as we format the axes we created last week.


Newsletter