Please note javascript is required for full website functionality.

Blog

Power BI Blog: Analysing our Bins

19 November 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau dives deep into bins and spouts his usual rubbish.


Power Query: Recent Dates

18 November 2020

Welcome to our Power Query blog. This week, I show how to only extract the dataset for the last two years, say.


Power Pivot Principles: Using Measures to Define Target Value in KPIs

17 November 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about using measures to define target values for KPIs.


A to Z of Excel Functions: The IMREAL Function

16 November 2020

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


Charts and Dashboards: Multiple Bullet Charts – Part 1

13 November 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we begin looking at creating multiple bullet charts in Excel.


Power BI Blog: Group Type – Bin (Grouping Numerical Values in Power BI)

12 November 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau explores using the Data Groups functionality in Power BI… again!


Power Query: More Searching Questions

11 November 2020

Welcome to our Power Query blog. This week, I answer some (even) more searching questions.


Power Pivot Principles: Introduction to Key Performance Indicators (KPIs) in Power Pivot

10 November 2020

Welcome back to the Power Pivot Principles blog. So far, we have discussed only about using measures in Power Pivot. This week, we will move away from measures and talk about Key Performance Indicators (KPIs).


A to Z of Excel Functions: The IMPRODUCT Function

9 November 2020

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


Charts and Dashboards: Linking Excel Charts to Power Point

6 November 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we will consider how to link charts from Excel to a presentation in Power Point.


Newsletter