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.

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...

Dashboard Week Day 1 – Rome

#DashboardWeek started not with a bang, but more of a groan as we found out our original brief wasn’t going to work anymore. Hours of working through macros trying to parse out tables into something useful were suddenly deemed pointless in fewer than 140 characters. We received our new brief: make a dashboard on Andy’s food and drink diary from his recent holiday to Rome. Having spent most of the day in Alteryx, I thought I’d stay a bit longer and work out the distances between each of his daily pit stops. You can see my dashboard here, but for this blog I thought I’d walk through my workflow for finding those distances. 

Just The Tips 4 – Slope Charts

Slope charts are essentially line charts, but ones which only show two points. They're really useful for showing overall trends without letting fluctuations disguise the big picture. To make them you want to take a designated start and end date and then cut out...

Predictive Analytics Schema

I’ve made an Alteryx schema based on model comparison which will hopefully help any of you wanting to exploit the power of predictive analytics. What I’ll show is supposed to be a guide for how you might want to set up your own workflow, and so I’ve tried to make it as broadly applicable as possible.