Ollie Clarke

Ollie Clarke

Ollie Clarke

Ollie studied Philosophy and then Natural Sciences at the University of Cambridge, before spending a couple of years in the wilderness as a professional singer. After sinking hours into Excel and SPSS trying to make his final research project look perfect, discovering the ease with which he could achieve this in Tableau was a thrilling moment. He instantly knew that this was where he wanted his career to go, and the Data School was the best place to make that happen.

Ollie splits his free time between going to the cinema, cooking and baking, playing football and singing in a number of choirs. He is also permanently available should anyone need an extra for a pub quiz.

Catablog

Here I thought I'd collate all the blogs I've written over the past 4 months into one place - mainly so that I can find them more easily later. Think of it as a catalogue of blogs or a #Catablog. School's In - my background and first impressions of the Data School...

The End of DS8 – Reflective Blog

I thought I’d reflect on the months I’ve shared with the other inhabitants of the DS. After each client project we did a ‘start/stop/continue’ where we went through what we should have done, what we should not have done and what we should continue to do. I’m going to structure this blog in a similar way looking at what I’ve done/liked and what I should have done more.

Filtering Table Calculations

Today we spent a bit of time talking about filtering table calculations. This is obviously a pretty useful thing to want to do, but doesn’t immediately work. In this blog, I’ll show you an example of filtering table calculations, give you the preamble explaining why it’s slightly tricky, and then give you a solution.

Just The Tips 6 – Stacked Labels

It’s been a while since the last JTT, so I thought I’d get back in the groove of things by showing a quick and easy way to show total labels as well as composite labels on your stacked bar charts. No LODS or dual axes needed!

Multi Row Formula in Tableau

This week was Teaching Week in DS8, and Jevon took it upon himself to educate us in the ways of Data Densification. He had a cool exercise looking at ways of counting how many lightbulbs were on at one moment, but I’ll leave him to explain that. As part of his exercise he wrote a calculated field which ‘filled in’ rows a lot like the Multi Row Formula tool can do in Alteryx. We immediately got to put  this calculation into practice helping someone out on our CoE. They wanted to be able to count how many tickets were open any given month. In this blog I’ll walk through how I went about solving this problem.

Drilldown Worksheet Actions

In this blog, I’m going to walkthrough and explain the calculations required to make Week 41’s dashboard. This uses worksheet actions to allow the user to see Sales by Profit for all US States, and then click a State to see the Sales by Profit of all the Cities in that State.

Dashboard Week – Lessons learned

Dashboard week is over! The past five days have been undeniably intense, but also incredibly rewarding and enjoyable. As a sort of #ReflectiveLog I thought I’d look back over the past week, show all my dashboards in one place and also talk about what I’ve learned this week. 

Dashboard Week Day 4 – Throttle Tool

We’re over the hump of Dashboard Week. 4 days done and 1 more to go. It’s been a long week, but I’ve learnt an awful lot in it. In this blog I offer a quick introduction to the Throttle Tool. I’d never heard of this before Monday, and on the off chance that you’re in a similar position, then read on to find out more!

Dashboard Week Day 3 – Rick and Morty

Dashboard Week continues, and Andy gave us some great data this morning using the Rick and Morty API. We all had a lot of fun going through the data, although we were lucky that a few of us watch the show which helped a lot with checking that our data was correctly...

Dashboard Week Day 2 – Los Niños

Today's task in Dashboard Week was to look at NOAA data surrounding both El Niño and La Niña. You can see my dashboard about this here, but in this blog I thought I'd share a very very quick tip that Laura showed me today. If you've seen any of my stuff on Tableau...