Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power BI Blog: Sydney’s Register of Food Penalty - Part 3

14 November 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at getting our data to properly display on the map visualisation.


Power Query: Emerging from Merging

13 November 2019

Welcome to our Power Query blog. This week we look at extracting from merged Excel cells.


Power Pivot Principles: Selecting from Multiple Lookup Values

12 November 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to introduce a method to extract a single value from the group text columns.


A to Z of Excel Functions: the FV Function

11 November 2019

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


Charts and Dashboards Blog: Understanding Chart Element

8 November 2019

Welcome back to Charts and Dashboards blog series. This week, we’ll go through all elements in a chart.


Power BI: Sydney’s Register of Food Penalty Notices – Part 2

7 November 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at extracting more information from the NSW Food Authority’s register of penalty notices.


Power Query: Check the List

6 November 2019

Welcome to our Power Query blog. This week, we look at ‘remove error’ for lists.


Power Pivot Principles: Introducing the SAMEPERIODLASTYEAR Function

5 November 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at the function SAMEPERIODLASTYEAR function.


A to Z of Excel Functions: the FTEST Function

4 November 2019

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


Charts and Dashboards Blog: How to Create a Chart

1 November 2019

Welcome back to Charts and Dashboards blog series. This week, we’ll create our very first chart.


Newsletter