Please note javascript is required for full website functionality.

Blog

Charts and Dashboards: A Quick Look at Analysis

12 August 2022

Welcome back to our Charts and Dashboards blog series. This week, I look at the Quick Analysis tool.


Power BI Blog: Composite Models and Dynamic M Query Parameters Part 1

11 August 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we create Dynamic M Query Parameters and reference them in an M query.


Power Query: Double Access Savings – Part 3

10 August 2022

Welcome to our Power Query blog. This week, I continue to extract the data from the tables in the two Access databases.


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

9 August 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 COSH.


A to Z of Excel Functions: The MODE.SNGL Function

8 August 2022

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


Charts and Dashboards: Recommended Charts

5 August 2022

Welcome back to our Charts and Dashboards blog series. This week, we’ll look at Excel’s recommended charts.


Power BI Blog: Metric Visuals Updated

4 August 2022

Welcome back to this week’s edition of the Power BI blog series. This week, we look at added support for composite models and Dynamic M Query Parameters.


Power Query: Double Access Savings – Part 2

3 August 2022

Welcome to our Power Query blog. This week, I filter and expand the data in the two Access databases from last week.


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

2 August 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 COS.


Monday Morning Mulling: July 2022 Challenge

1 August 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.


Newsletter