Dashboard week: finding a story

by Soha Elghany

Day 3 was food hygiene data from the food standard agency first we had to download the data and XML parse it because the data is in XML like this:

We used an XML Parse tool and included Child Values and Outer XML to include all the data in the outer XML code and inner XML code, I discovered if I didn’t include outer XML code some of the data for geocoding wouldn’t show, this parsed the data in a clean format that didn’t need much extra work. Only Food Scores, as well as longitude and latitude, needed some additional parsing and cleaning.

Following this, I wanted to have a good story to visualise my data so as a huge coffee advocate and regular consumer of Starbucks I decided to compare ratings between major coffee chains and independent coffee shops:

My visualisation detailed this comparison: click here for the interactive viz


Tips for the Tableau Desktop Qualified Associate exam!

3 mins read

Sat 25 Aug 2018

How to visualise missing dates? #tableautip

1 mins read

Tue 21 Aug 2018

Dashboard week: calculating distance

1 mins read

Mon 20 Aug 2018

Dashboard week: knowledge is key

2 mins read

Fri 17 Aug 2018