The Data School Blog

All about parameters part 1 #tableautip

What is a parameter? Parameters are a dynamic field that offers the user the ability to interact with your dashboard, it also adds a degree of flexibility to your dashboard. How is a parameter different from a filter? You can filter a dimension or measure and this...

read more

Friday Project: Reflective Blog

Today was yet another ‘Friday Project’. After a brilliant session by Anna Noble on blogging, we were given a new dataset to work with for the day. Today, we were given the TFL data on bike journeys and bike stations. We then had 3 hours to analyse the data and present...

read more

Demystifying table calculations

It can be hard to wrap your head around how Tableau uses table calculations. You might be content just using the quick table calculations, but if you’re reading this blog you probably want to understand what is happening, not just rely on Tableau’s magic. This blog post will guide you through the process in plain English.

read more

Tip Week #4 – Pareto Charts

What is a Pareto Chart? According to the Pareto Principle 'for many events roughly 80% of the effects come from 20% of the causes'. Or, in more practical terms, 20% of your customers/cities/regions are responsible for 80% of your sales. How do you build one in...

read more

How to create dots at the end of your line #tableautip

In this tableau tip I'm going to show you how to create dots at the end your line graph using the Superstore Sales data in this example: A Line Graph is one of the most frequently used graphs to show trends and analyse how the data has changed over time. When you have...

read more

Tip Week #3 – Sketches

Got an intersting dataset, but struggling to come up with ideas for your viz? Grab a pen and a piece of paper and sketch out your ideas! Divide your sheet into six smaller sections and draw a simple viz into each of them. It doesn't have to be very detailed, but...

read more

Tip Week #2 – Date Calculations

Date calculations are useful if you want to manipulate dates in your data source. To get you started I'm going to cover five of them in this blogpost: DATENAME DATEPART DATETRUNC DATEADD DATEDIFF Before I dive deeper into each function let me clarify a term I'm going...

read more

Tip Week #1 – Ranked Sort

If you've ever used Tableau you're probably familiar with the sort buttons. Clicking them will instantly sort your data in ascending or descending order. And while this is very straightforward in simple usecases, you might come across more complex problems where they...

read more

Tableau Top Tips: Dual axis, infinity and beyond

Most of you have probably seen a chart or a data visualisation with overlapping data, piled one on top of each other. These are made using a dual axis on Tableau. The idea behind a dual axis is to put two different graphs on the same view to allow you to compare two...

read more

Tableau Top Tips: One click away

Have you ever wanted to analyse your data with a higher level of granularity (i.e. through a specific month or day, or either through an average or median)? Well, good news! With this tableau tip, you can skip all these steps and get to where you want to be, with just one click!

read more

Blacking out your map #tableautip

For this map in Tableau, I want to show the top 3 ranked states by region that had the highest amount of profit. For the rest of the states that were ranked below the top 3, I wanted them to be blacked out.

read more

Quick Tip – Using cycle plots for date comparisons

Cycle plots are great for comparing date values over time. Take this chart for example: If we wanted to compare how each month performed in terms of sales over the last 4 years, this would be  difficult to do with this kind of line chart. We would have to find the...

read more

For A Beginner, By A Beginner – Grouping

This blog post is all about groups within your data, and what you can then do with them.   For this example we are, as always using the Tableau sample Superstore dataset. Start by dragging “Orders” into the main pane and go to a new worksheet. Drag both “Country” and...

read more

For A Beginner, By A Beginner – Extracts

Hello and welcome to the Extracts post!   Explaining extracts is very simple indeed, however there are some implications of using them that we must consider and will go through them here. So, on the data source page there are a couple of buttons on the top right of...

read more

For A Beginner, By A Beginner – First Steps

First Steps: Ok so by now you should have the basics nailed, you can set up a simple bar chart, maybe you have played around with the "Show Me" function, and most importantly, have a grasp on what the Tableau Starter Kit has to say. From here we are going to look at...

read more

Quickview summary statistics in your worksheet

Getting a little lost in the detail? Stop, rewind, Worksheet -> Show Summary Understanding the nature of your data will play a huge part in how you process it, your choice of analyses or statistics and, ultimately, what you end up visualising. Exploring key elements...

read more

First DS Project – Alteryx and Custom Regions

Friday is Project Day at DS and in our first week we were lucky enough to be able to work with a familiar dataset: our application. The task was to supplement the first (or second) viz with additional data. I decided to remake my first viz on UK Tourism as it didn't...

read more

Supplementing a viz with a 2nd data set

In this week’s Friday project, we were challenged to use our newly acquired knowledge of Alteryx to supplement our application viz with a new data set. My original data set looked at the Global Peace Index (GPI) and I wanted to supplement this with information on...

read more

Understanding Alteryx as a SQL user: part 1

SQL is one of the most common programming language used for designing, managing and analyzing data. However, it is one of the most complex programming languages to work with and can be incredibly time-consuming and frustrating especially when your query will not...

read more

New in London – Attended the talk of Alberto Cairo

One of the big advantages of moving to London is the huge numbers of amazing speakers who make their appearance in the city. So during my first week in London I already had the opportunity to attend the talk of Alberto Cairo, the author of the very well appraised book the truthful art.

read more

Meet & Greet June 13th

Hello Data School blog readers!! This evening we hosted a meet and greet with recent graduates, DS10 hopefuls, and even some who were just passing through! For all of you who joined us, let me be the first to say thank you and it was lovely to meet those of you I did,...

read more

The Data School Is Expanding

As of this writing, 64 brilliantly talented women and men have graduated from The Data School. When I think about it, it's crazy! 64! Already?? Where has the time gone? As we head full steam into our third year, we have some big news to share. WE'RE EXPANDING!!!   We...

read more

Getting started

With my first entry in this blog I’d like to share my experience of my first day at The Data School and my expectations for the next four months. We started off with an introduction to the history of The Information Lab and The Data School by Tom Brown. This was...

read more

What a start!

  Willkommen, Bienvenue, Welcome! So today was DS9’s first real training day and the focus of our education for today was the all-powerful Alteryx. After a gruelling 8 hours of mind melting data formatting, resulting in our collective understanding barely scratching...

read more

Here’s to new beginnings!

Little did I know what I would be in for during this first day at The Data School. Arriving at the office at 8:45 I was met by Andy Kriebel and a few of my fellow Dataschoolers, there Andy gave us the first gift of many we would receive that day.

read more

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

read more

Reflections and Advice for Future DSers

Well that was quick, the last four months of training at the Data School went by crazy fast. We are all already off to our respective first placement. Tomorrow, I will go work for 6 months at JLL with Laura, onto my first experience in a corporate environment, really...

read more

Data School Cohort 8 Reflective Blog

Reflecting back at 4 months of Data School - learning curve, blogs, personal development. Our time at the Data School has come to an end, so it's time to sit down and look back at the experience as a whole.   1. Learning Curve For me the first few weeks had an...

read more

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.

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

read more

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!

read more

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.

read more

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.

read more

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. 

read more

Dashboard Week Day 5: where it all comes together

A recap of Dashboard Week Day 5 with tips and tricks used throughout. Dashboard Week has come to a successful end, with Friday being particularly hectic. 9 am: present Thursdays work 10 am: start on the new London Air project 1:30 pm: should probably move from Alteryx...

read more

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!

read more

Dashboard Week Day 4: Dashboard Week in Practice

Some quick points on why I think daily projects such as Dashboard Week can be massively useful to prepare you for client work. Dashboard Week Day 4 was a little different than usual as I had a Shadow day, following fellow Dataschoolers Neil Lord @LordNeilLord and Dan...

read more

Dashboard Week Day 3 Over

Day 3 is over! This time we were tasked by Andy to download data from Rick and Morty API and build up a viz from there. I had to specifically work with the different locations to be found in the show. It took me a good part of the day working in Alteryx to get the...

read more

Apply for The Data School

Our application process is always open. Get started with your application today!