Data visualisation – which diagram should I use?

Here is an excellent web link plus two great books which address the question which diagram or chart should I use to best communicate different types of information visually. With at least 40 types of diagram and new ones/variants constantly being invented this is a hot topic!

Continue reading “Data visualisation – which diagram should I use?”

Instant Customer Data Analysis using Excel: worked example

One of the most useful aspects of Microsoft Excel is its ability to quickly slice and dice customer data from live systems to identify important trends and behaviors which can inform strategy. In this article and screencast I share a 7-step plan, illustrated with a worked example, for Instant Customer Analytics using Excel.

Continue reading “Instant Customer Data Analysis using Excel: worked example”