Dan discovered a passion for data analysis and visualisation whilst researching the role of the brain in exercise during his Masters degree. This led to analysing client data for some of the UK’s top law firms at a research consultancy.  At the Data School Dan wants to hone his storytelling skills to make data accessible to a wider audience.

At the same time, Dan strives to make a name for himself in the world of distance running, competing for Kent at cross country and getting ever closer to the dream of a sub 2h30 marathon.

 

If I walked this path again

Part of reflecting in the New Year is looking back at what you would have done differently. I'm certain that I made the right choice in joining the Data School and have really enjoyed my time so far. If I had the chance to repeat the last few months, however, there...

read more

How to succeed in the Data School

Feedback is the breakfast of champions In the Data School I have been surrounded by colleagues with some exceptional skills and knowledge. The atmosphere is such that nobody should be afraid to give or receive feedback about their work. Sometimes the coaches have...

read more

Uphill battles at the Data School

As a new year begins, I'd like to share with you my biggest challenges of being in the Data School. Working as part of a big team In my previous job roles I was very independent. I worked as part of an organisation but was given the freedom to drive projects along...

read more

Using the Include function in Tableau calculations

In Tableau, the default behaviour is for all data to be aggregated by whatever dimensions are in the view. This includes and dimensions which are on  the rows and columns shelf as well as the marks card. There are occasions however, when we need to aggregate by a...

read more

Editing Tableau Server Project Permissions

When Tableau Server is deployed in a large organisation management will want to allow users to have specific privileges or restrictions with regards to projects, workbooks and data sources. Users can be set with specific roles and privileges and we can also set...

read more

Taking apart quick table calculations in Tableau

Taking something apart and putting it back together is a great way to understand how something how something works. This is true for engines, computers and quick table calculations in Tableau. When I started out using Tableau I would use the quick table calculations...

read more

Creating a Pareto chart in Tableau

If an event follows Pareto's law then 80% of the effects come from 20% of the causes. To test whether superstore sales follow Pareto's law we need to check if 80% of the sales come from 20% of the customers.  In Tableau, we can do this visually by creating a Pareto...

read more

Hex bins in Alteryx: Part 2

In part one of this blog I showed how to create the coordinates of the hex bins. The next thing we need to do is join these coordinates to the table with locations and counts.  For this example I will use countries and 2016 Olympic gold medals. Country Gold UNITED...

read more

Use the DateName function to make time charts interactive

In Tableau, Parameters can be used in a dashboard to change how the date is displayed in a time chart.  This is a great way to give users some control so they can drill deeper into the data without having to create extra charts, using valuable screen space.  The below...

read more

Hex bins in Alteryx: Part 1

This week Nicco Cirone showed me a viz he had created to show the US election results.  It was a remake of a visualisation in the FT. The FT used hexagons to represent the number of voters in each state. I was inspired to see if I could find a way to use Alteryx to...

read more

Dashboard design: test and review

Good dashboard design involves feedback loop between the designer and the final user. If you ask your user for general feedback they may focus on more the look and feel when the dashboard is not succeeding in more important aspects.  So rather that general feedback ,...

read more

Dashboard design: space saving in Tableau

Designing a dashboard can feel like trying to cram your hold luggage into your hand luggage - you need to pack carefully if you want to zip it up.  Assuming you have already cut down the data and metrics to the bare minimum, here are some Tableau functions that can...

read more

Dashboard design: What is a dashboard?

I come from a sea-faring family, so when I hear the word dashboard the image that comes to my mind is the view of the nautical instruments the skipper or pilot sees at the helm.  The pilot can see the sea and a series of displays which convey a large amount of...

read more

Using Alteryx to find the nearest alternative

This week at Data School we've been building a new viz each day from a different data source.  The topics varied from weapons confiscated at airports to the British National Food survey. My personal favourite was visualising farmer's markets in the US.  We were given...

read more

Data preparation in Alteryx: where to start?

When you get in a car, you have usually have one goal in mind to get you, your passengers and your cargo to you destination. There are certain things you need to do before you can begin your journey  (eg. start the car, take the handbrake off) and there are certain...

read more

How to dynamically update field names in Alteryx

Occasionally you will receive a data set without any headers and you will need to find the header names from a different data set.  Here is an example of data without a header row from the current Premier League standings. F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 1 Man City 9 6...

read more

How to repeat row labels in Alteryx

Gender Name Weight IQ Salary Height Men Tim 64 100 28380 169 Bob 66 99 18024 186 James 78 80 45755 166 Dave 88 88 30761 144 Mike 49 120 38652 174 Subtotal 345 487 161572 839 This is my first week using Alteryx and I am enjoying finding ways to automate the tedious...

read more

How can I reshape data in Alteryx?

When working with data to create visualisations in tableau it often helps to pivot the data.  This means that we go from having a separate column for each metric to a column for metric name and a column for values. In this example we want to go from data shaped like...

read more