Day three of dashboard week was all about the cheese. This inevitably led to puns and an entertaining dashboard, but getting the data was more complicated. We had to webscrape from a cheese website, getting the links to webpages of individual cheeses, before webscraping each of those.

The webscraping was interesting, and for some involved iterative or batch macros. As I had relatively few cheeses assigned to me, I was able to simply input three different URLs in the text input for the three different letters I had been assigned.

The ensuing data was full of interesting facts, from the chosen cheeses family to the different flavours involved. I decided to approach the design of the dashboard as if I was someone who was interested in finding out more about families of cheeses, and put information from number of vegetarian cheeses to the location of origin in the dashboard. This provided a good overview for the user, but to finish it off I decided to input the description of an individual cheese of your choice at the end. This involved making sure that a filter on the dashboard was only filtering relevant values (i.e. the cheeses in that select family). i had never done this before, but it was incredibly easy. Simply right clicking and selecting relevant values meant that it did it automatically, and is something I will use extensively in the future.