Select Page

## Ben Moss

Ben became interested in data analysis whilst studying his undergraduate degree at Coventry University. He was introduced to how data is used to improve the objectivity in the decision making process.

From this point he decided data was his future and went on to study a postgraduate degree in Performance Analysis in Sport.

Ben has worked in Healthcare and Sports and was becoming tired of using poor data visualisation tools to create analysis solutions when he fell upon the Data School, Tableau and Alteryx.

He enjoys sports (particularly football and his beloved Les-tah City) and visiting Europe’s cities.

He also combines his two biggest hobbies of sport and data analysis to write research and hopes to use his Tableau and Alteryx training to enhance his research profile further.

## #VizLikeAnArtist – Circles in Circles

One of my favourite ways to learn Tableau is to find visualisations I like and recreate them (or try to) in Tableau. I have an ever expanding 'viz library' which I use as inspiration. My latest purchase 'Infographica' by Martin and Simon Toseland inspired my latest...

## From R to alteryx

Earlier in the week I posted a blog on my first adventure with R. Well today I took this a step further and tried (successfully) to transfer the code I wrote to create the below visualisation into the alteryx R tool to see if I could produce the same output. I'm going...

## From Excel to alteryx – COUNTIFS and SUMIFS

In Excel the COUNTIF(S) function counts the number of cells in a range that meets a single or multiple criteria. The SUMIF(S) is identical apart from it summing the values rather than counting. Both these functions are extremely useful to Microsoft Excel Users. The...

## #VizLikeAnRRRRRRRRRRRtist – 7 starter tips

So at the beginning of the week I discovered this visualisation from a university friend now working as a sports analyst over in America. Viz courtesy of Chris Fry (@ChrisAFry). To me this is a beautifully simple piece which I instantly wanted to recreate in Tableau...

## Tableau Server – Accessing the PostgreSQL database

Last week as part of our project I was asked to create a landing dashboard that allowed our users to better find content that was related to them. Between myself and the client we defined 'related to them' in four ways; the last 5 previously accessed reports, the top...

## Tableau tooltip tip week – Other chart types in tooltips

So this morning I was thinking of what other aspects of tooltips I could blog about. Thinking of the content I had already produced I thought to myself 'hold on, is it possible to use other chart types in tooltips'... well with some yes, others no. But here are my...

## Tableau tooltip tip week – Bar charts in tooltips

YOU CAN DO BAR CHARTS IN YOUR TOOLTIPS...WTF. How awesome does that sound? Why is it awesome? It is an opportunity to provide your users with additional information, without taking up any space. When they are used well they can be extremely effective in adding detail...

## Tableau tooltip tip week – Removing your tooltips…on dual axis charts

This blog links directly to my blog form yesterday focussing on removing your tooltips. Now what I didn't know then (but I do know) is that the ability to remove tooltips is slightly different with dual axis charts. Watch my video below to see the work around! Ben...

## Tableau tooltip tip week – Removing your tooltips

Sometimes tool tips just aren't right for the viz that you are producing, for example in an infographic that should be static and tell the story without additional information, or you have a scatter plot between two variables but solely want the user to focus on the...

## Tableau tool tip tip week – Dynamic symbols in tool tips

Tool tips are an extremely useful way to provide your users with additional information which help further or provide context for any points that you are tying to make within your visualisation. So to celebrate blog-a-day week here at The Data School I have decided to...

## #VizLikeAnArtist – Using a parameter to switch between table calculations

Last Friday on the train home to Leicester I came across the following tweet from Brit Carva (@databrit)... I responded with the following... Now what Brit probably doesn't know was that no workbook actually existed at the time of me saying this, I was lying; however...

## #VizLikeAnArtist – Using actions to navigate between dashboards

Last week in The Data School (week 9), a client asked for something that we had never been asked before. They wanted to be able to move from one dashboard to another, based on the object they select from the original dashboard. In other words, they wanted to be able...

## #VizLikeAnArtist – Creating Pareto Charts in Tableau

One of the learning methods that we use at The Data School is through teaching others. Andy will give us a subject to teach, with little to no detail, and we are asked to produce a session to teach to our group. Why do we learn in this way? Well at The Information Lab...

## #VizLikeAnArtist – Adding labels to Tableau polygon maps

Getting from this... to this... in Tableau may not be quite as simple as you believe. What you probably think i've done is put 'Local Authority Short' on the Label shelf. I would if I could, but when using the polygon mark type (note the map type in the image is a...

## #VizLikeAnArtist – Removing axis marks

Sometimes axis marks aren't necessary for a visualisation. They can in fact distract from the story that you are trying to tell. This was exactly the case in my 'life expectancy and deprivation in London' visualisation. In this case I used small multiples to show the...

## From Excel to alteryx – IF statements

Everybody uses IF statements in Excel. EVERYBODY. It is one the most popular decision making functions on the platform. Fortunately in alteryx they are just as simple as in Excel. So using the dataset outlined in the 1st blog of this series (with all our player...

## #VizLikeAnAtrist – Multicolour box plots

Below is an image of one part of my Data School interview viz. I was looking to tell the story of the variation of life expectancy between different London Boroughs and also between genders. And one method I thought of doing so was by using a box plot showing changes...

## From Excel to alteryx – VLOOKUP and INDEX MATCH

Like many millions of us about 3 months ago I was entirely dependant upon Microsoft Excel for data preparation. And like many millions of us I got continually frustrated with how slow it can become when working with large (by excel standards, tiny to others) data...