The Data School Blog

Using FIND, LEFT and MID to format names

What do you do if you require names in a different format to what you have? For example… All of your names are in the datasource as follows: And you want Well, the key is to use string functions to find the gap between the first name and surname. However, the relative...

read more

Dashboard Week Day 4: United States Drought Monitor

With Power BI day behind them, we move onto day 4 in which the team will be analyzing drought conditions in America. Requirements: They must use the REST API to download the Comprehensive Statistics.They are more than welcome to supplement it with additional data....

read more

Dashboard Week – Intro to Power BI

New day, new tool ! Today, Andy has challenged us to use Power BI to produce a dashboard on data from New Orleans. So I started by getting the data from the NOLA 311 API, cleaned it on Alteryx, changed the format for a more appropriate one - or so I figured - to be...

read more

Dashboard Week Day 3

Today our instructions from Andy were as follows (these are copied verbatim from the original blog post) : The data come from the City of New Orleans Open Data Portal (here). They MUST use the API to get the data. They need to get all data for all years. This should...

read more

Dashboard Week #3 PowerBI and New Orleans 311

Today was our third day of #Dashboardweek and as DS11 did last time, we had to use PowerBI. The data came from the New Orleans .gov site and it was about 3-1-1 calls. This number is a non-emergency phone number that people can call in many cities to find information about services, make complaints, or report problems like graffiti or road damage. Hence, the data was about different incidents, their nature and location.

read more

DS12’s Dashboard Week, Day 3

Head Coach Kriebel has tasked DS12 to investigate City of New Orleans calls, and we're to use Microsoft Power BI. No Tableau! I'll be honest, I am not a big fan of Power BI. After using Tableau for a few months, I have definitely developed an attachment and some sort...

read more

Dashboard Week – Day 3

Introducing Power BI Day 3 brings us a very different challenge as we are tasked with using Power BI to build our dashboards. Today's data comes from the City of New Orleans open database, covering 311 call history (the local government's information and non-emergency...

read more

Macros; they aren’t as scary as they sound

Macros; what are they and why should we use them? A macro is a workflow that you can create within Alteryx to then drop into another Alteryx workflow. These also exist in similar veins within other products or even from other items within the PC space, they...

read more

Tableau server permissions part 1 – Assigning permissions

So, you’ve setup everyone onto Tableau server from your organisation to the correct ‘Site’ but now you have a problem: some of the content on the server is sensitive and should not be accessed by everyone. With Tableau’s server permissions, you can a make sure that the correct people are seeing the content that is right for them.

read more

Dashboard Week Day 2

It's day two of dashboard week for DS12 here at TIL. If you don't know what dashboard week is then allow me to explain, dashboard week is a week long period during which each cohort member must produce one dashboard and an accompanying blog post daily. Each day of...

read more

My First ‘Dashboard Week’ Day

This is my first day doing the famous Dashboard week with my fellows DS12... and the least I can say is that it is a great exercise to see how bad I am at time managing... ! . So it is 9.45AM and is it the starting point for us. The challenge for today is to create a...

read more

Dashboard Week – Day 2

Day 2 was actually day 1 for me after taking the day off on Monday - and I could feel the cobwebs from that additional 24 hour period as I started on today's challenge. Looking at London Marathon data seemed promising for me, since I have an interest in running but I...

read more

Dashboard Week, Day 2. London Marathon Runners

I've only got 10 minutes to write this so its' going to be a short one. For Day 2 of Dashboard Week, we were tasked with visualizing historical London Marathon data, runners with the letters "bo" in their surname for me specifically. The first thing to do was to...

read more

Dashboard Week Day 2 – London Marathon #oneinamillion

The second day of dashboard week had DS12 exploring the finishers data from every year of the London Marathon. Each of us were assigned a two letter code from either our first or last name to narrow down the searches for our web scraping, for me this was ‘ja’. My...

read more

Dashboard Week #2 London Marathon

Today was our second day of #Dashboardweek and the task this time was to look at the historic results of the London Marathon website. Because the results span all the way from 1981, Andy limited our search to only those entries that start with the first two letter of my surname -PA.

read more

DS12’S Dashoard Week, Day 2

Second assignment: retrieve all the data for every year for all participants in the London Marathon using the below website. https://www.virginmoneylondonmarathon.com/en-gb/event-info/race-results/ We had to collect all historical data for all participants that had...

read more

How does Tableau Web Editor compare to Tableau Desktop?

Last week we (DS13) spent a day running through the basics of Tableau Server with JMac. We also had a go on Tableau Web Editor to understand how it compares to Tableau Desktop. This involved building graphs with all sorts of features e.g. filters, dual axis, to see...

read more

Dashboard Week Day 2 – London Marathon Runners

This morning, Andy directed us to https://www.virginmoneylondonmarathon.com, and told us to scrape every London Marathon result from 1981-2018, for information about individuals that shared the first two letters of our surnames. Weird enough task. The Alteryx workflow...

read more

User information icons

Add information icons to your dashboard to provide users with additional content and/or instructions to help them navigate your visualisations.

read more

DS12’s Dashboard Week, Day 1

Head Coach Andy set DS12 Star Wars as our theme for our first dashboard in dashboard week. As someone who is totally unfamiliar with Star Wars (oooops), I decided to tackle the film section of the API. We have been granted more time today than we will for the rest of...

read more

Dashboard Week, Day 1 – Star Wars

I picked to attempt a visualization of the Starships in the Star Wars universe. Once I connected to the SWapi in Alteryx, I noticed that I was only getting 10 results which was a little unusual. On further inspection, the api call was only getting the first page worth...

read more

Dashboard Week Day 1

The week that is famous for bringing out the best (It’s not uncommon for a DSer to achieve Viz of the Day during dashboard week) and worst (Nick DS10 we’re looking at you) in people at TIL, has arrived.

read more

Dashboard Week #1 Star Wars API (SWAPI)

Today was our first day of #Dashboardweek and the task set by Andy consisted on using the Star Wars API (SWAPI). As there were only six of us today and six different topics in the API, each of us had to choose one. I have the habit of letting everyone choose before me and therefore I was left with “Vehicles”

read more

Week 3 Project Public Trade Companies Stocks

Last week DS13 project involved the creation of a dashboard using historical shares data downloaded from finance.yahoo.com. Each of us was assigned a public-listed company with the aim of producing a visualisation which would convince the audience to invest in this company.

read more

Dashboard Week Day 1 – Star Wars API

Today marked the first day of dashboard week for DS12 which believe it or not I was looking forward to as a break from client projects (I’ll let you know whether this was the right way to be feeling later on in the week). The challenge today was to connect to the Star...

read more

Dashboard Week Day 1 – Star Wars

For Dashboard Week day 1, Andy asked us to use the Star Wars API to download data. The API allows you to obtain data about various aspects of the Star Wars universe, such as characters, vehicles, planets and species. I went with characters. Here's what I came up with...

read more

Dynamic Chart Titles in Tableau

There are plenty of times in Tableau where I have charts that would change due to dashboard interactivity via filter or highlight, and etc. Sometimes it is hard to remember which filter/highlight option I had opted for if my dashboard is quite long and I am way down,...

read more

Creating Dashboard Alerts in Tableau Server

Tableau Server can be used to send email Alerts to predefined users if a threshold is met. This is only possible on a view that has a continuous (green pill) numeric axis. To do this on a dashboard, click on a continuous axis of the view that the Alert will be set on....

read more

Jon’s DS13 Week 3 Recap

Week 3 covered a real spread of Tableau products including Desktop, Prep, and our first real glimpse into Tableau Server! It was also filled with other exciting (scary) news such as finding out the date for our first teaching-the-public event, as well as finding out...

read more

How is Tableau server organised?

Yesterday, we had our introduction to Tableau server and covered quite a lot in a day. One of the things we looked at in the beginning was how Tableau server was structured. The above shows an example of how things can be arranged in Tableau server. At the lowest...

read more

Dynamic axis and sorting with parameters PART 2

If you have read part one, then you already know how to build a dynamic axis, and, in this post, I will explain you how to create a parameter to let your user sort between ascending descending. I recommend you that if you haven’t read about how to create a dynamic axis, you can read about it here as I will build upon that post.

read more

Dynamic axis and sorting with parameters PART 1

Parameters are one of the most useful tools that Tableau has. They allow the user to input their own values, which allow us to create self-served dashboards and dynamic dashboards that won’t require a constant update. In this blog post I will guide you through the steps of two different uses of parameters. In the first part, I will show you how to create dynamic axis that allow the user to select a different measure. In the second part, I will show you a small trick to create an ascending/descending parameter for a better user experience.

read more

Diego’s journal (DS12) – Week Six

Week Six (14/01/19 – 18/01/19) As we are currently in week 11, I must confess I have fallen behind on my journaling. However, before the memories fade completely I’ve decided to write a small recap of the things that we did and learnt during week six. The week was...

read more

Tableau Tip – Swapping entire views using a parameter

Given that I haven’t posted a blog in a while, I thought I’d ease back into it with this handy tip which I used recently on a client project here at the Data School. In some scenarios, you may want to free up some space on your dashboard by providing the option to...

read more

Asymmetric Drill Down using Set Actions

In order to create a drill down the data set needs to have hierarchical information . Superstore will be used in this example to make a Tree map, using Sales on the Size mark. To create a hierarchy drag the 2nd level dimension of the hierarchy onto the 1st dimension....

read more

We Need to Talk About Density Marks

Or: how knowledge is power when it is shared Act 1: on dealing with "busy" data On inspecting a dataset it becomes clear that the insight might be lost in how tightly packed together the data points are. It becomes difficult to separate the signal from the noise. Take...

read more

Dynamic Reference Lines

There are certain times where I would like to see a chart in a general overview and then drill down in the same space. I am going to walk you through how to make a dynamic reference line, have reference only appear on a certain condition. In this exercise we'll be...

read more

Jon’s DS13 Week 2 Recap

Week 2 was focused on what brought us all to the Data School in the first place – Tableau Desktop. Almost an entire week dedicated to data visualization best practices, design methodology, and practical Tableau learning

read more

Clustering continuous and categorical data in Alteryx

For this weeks client project at The Data School, one of my objectives was to group the clients customers based on the types of services that they were purchasing from the client. This is also known as customer segmentation. The business case for customer segmentation...

read more

Combined axis vs dual axis.

For most visualisations that I have created, if I have wanted to add in other measures into the view, I have generally used a dual axis to do this. However, there are reasons why you should use a combined/shared axis in some cases. What is a dual axis? A dual axis...

read more

Data Preparation… for Dummies

Last Friday DS13 was assigned a project. In the time span of 2 hours (which became 4 afterwards), we had to re-create our application viz. It was also required to find a new dataset, preparing it with Alteryx or Tableau Prep, and adding it to the original Viz. In this post, I would like to describe how I used to clean up the data before joining DS and how this process can be streamlined using a tool such as Alteryx or Tableau Prep.

read more

Bars need their space too.

In this post I’m going to show you a simple method for adding extra spacing between certain bars in your chart. This can be useful to make groups or categories clearer.

read more

Data Visualisation… using crayons?

At the beginning of this week, Andy informed us that an upcoming session was composed of over 200 slides. Due to this all I was expecting was a long theoretical session, instead, Andy gave us some crayons and large paper canvasses.

read more

The dangers of rounded bar charts.

Rounded. Bar charts. Just look at those curves. As a newcomer to Tableau the discovery of rounded bars is ground-breaking. Making your first rounded bar chart feels like you’ve transcended from using your Grandad’s clunky square bars to the world of sleek, futuristic...

read more

Triskaidekaphobia

Hey everyone, my name’s Paul and I make up one ninth of the new Data School cohort. I’ve spent my whole life feeding my vague irrational fear of the number 13. This has ranged from not putting my gym bag in locker #13 even though it’s the only one free, to...

read more

So far so good!

I just want to preface this by saying I have no idea how to write a blog so apologies in advance. Anyway. as it’s my first blog, I’ll start with a little bit about me. It’s fair to say I’ve followed a pretty normal life so far, coming from the Home Counties to study...

read more

My application Viz: Pokémon, a guide to beginners.

The first Viz I’ve published on Tableau Public, Pokémon: A Guide to Beginners, was a great, and unexpected, success.
In this post, I would like to describe the first step of the Data School application process, focusing on the techniques I have used to build such a successful Viz, which guaranteed me the access to the next stage of the process.

read more

Apply for The Data School

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