Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Query: Not Your Type

27 November 2019

Welcome to our Power Query blog. This week, I look at assigning types to columns.


Power Pivot Principles: Understanding functions for parent-child hierarchies in DAX – Part 1

26 November 2019

Welcome back to the Power Pivot Principles blog. Start from this week, we are going to understand some functions for parent-child hierarchies in DAX.


A to Z of Excel Functions: the GAMMA Function

25 November 2019

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


Charts and Dashboards Blog: Chart Design Best Practice – Part 2: Colours and Compositions

22 November 2019

Welcome back to Charts and Dashboards blog series. This week, we are going to look at colour and the variable aspects of a chart.


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

21 November 2019

Welcome back to this week’s Power BI blog series. This week, we are going to look at producing some customised categories for the NSW Food Authority’s register of penalty notices data.


Power Query: Time for a List

20 November 2019

Welcome to our Power Query blog. This week, we take a look at how list() functions can take you to a whole new dimension (time).


Power Pivot Principles : Introducing the CROSSFILTER Function

19 November 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to introduce a new function CROSSFILTER.


A to Z of Excel Functions: the FVSCHEDULE Function

18 November 2019

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


Charts and Dashboards Blog: Chart Design Best Practice – Part 1: Which Chart When?

15 November 2019

Welcome back to our Charts and Dashboards blog series. Before moving on to working with charts, over the next three weeks, we will look at the best practice to create an effective chart. This week, we are going to have an overview of multiple chart types and...


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.


Newsletter