The Data School Blog

Introduction to Tableau Server

Server Structure Last week we were learning about the purpose and functions of Tableau Server with Ravi who was a member of DS1. Yes, for those of you that have inundated yourself with Tableau Public and trials with Tableau Desktop...there are more products that...

read more

Introduction to Tableau Server

During week 3 at the Data School we covered Tableau Server. Tableau Server is an online hosting platform that allows organisations to store workbooks and data sources. It provides employees with a safe space where they can collaborate and interact with Tableau content...

read more

Teaching Tableau

My experience with teaching Tableau to others: public and another cohort in person and public via webinar. The Good, the Bad and Lessons Learnt.

read more

Tableau Server Choices.

About: Tableau Server is an amazing hosting platform that allows you to store all your Tableau workbooks and Data Sources. Within a company this means that information can be quickly and clearly explored by those who require it. ----- Chapter I - Who are you? The...

read more

Tableau Server Structure

This week we were introduced to Tableau Server by Ravi. We started by understanding the structure of Tableau Server, as shown below: The way I understand it, we have 4 levels: Level 1: Sites Sites are like partitions or hosts. There is no communication between...

read more

Automating Tableau Server

This week at the Data School, we've been learning about Tableau Server. As all good servers do, you can automate repetitive tasks (much like cron jobs). Within Tableau Server, you can create 'schedules' which specify what type of tasks you want it to do, how...

read more

How to pass your Tableau QA Exam

If you’ve read any of my blogs, you might remember me mentioning that I passed my Tableau QA exam on my 3rd day of training at The Data School. So, I wanted to share my experience, and how I prepared for the exam so that you might find some helpful information here if...

read more

5 Top Tips when creating a dashboard

Hi, I'm Sara (part of DS14). I thought it would be helpful to share some top tips when creating a dashboard on Tableau 1) Have a clear idea/ understanding on what you want to visualise. Ask yourself a few key questions: - What story do I want to tell? - What are the...

read more

Failing Fast

I made an embarrassing mistake during my presentation in week two’s Friday Project. However, it’s definitely helped me

read more

Dashboard Project 2: Exasol Database

On Friday DS14 were given a task at 9:00AM to create a dashboard via an external database, Exasol. The task was to sketch our dashboard on a piece of paper by only looking at the fields in the metadata (as we were not allowed to interact with the data beforehand),...

read more

My thoughts about The Data School

I’m new to the world of blogging and social media, however, there’s always a first for everything! This post will begin with my initial thoughts prior to starting my first day at The Data School and then will be capped off with my thoughts after my first week within...

read more

Project No. 1… The Reviz

Hello! I’m Tom and I’ve recently joined The Data School in DS14. I thought this would be a great time to reflect on my experiences from my first week and tell you a little bit about my first project on Friday. 

read more

My Goals and Expectations of The Data School

Realising I have plateaued in my comfort zone at my previous job, I knew it was time to step out. My main goals for the next step in my career were to: 1) Learn2) Grow (in both professional and personal sense)3) Enjoy One day, while scrolling through my Instagram...

read more

What I hope to get out of the data school

When I first heard of The Data School I instantly imagined myself as Hans Rosling presenting his incredible TED talk - using data visualization to illuminate a story in a way that had never been done before. (Go check it out if you haven’t already!) Though the...

read more

My goals and expectations of The Data School

To be honest, I have fairly high expectations of The Data School and myself only because everyone here is so amazing… There are loads of things I would like to achieve. To name a few: Develop soft skills, so I’m able to present and teach Tableau/ Alteryx to othersPass...

read more

The Data School, what do I want out of it?

Now that I have settled in to The Data School, I want to use this blog post as a chance to document what my goals and expectations are at this point. (Hopefully I'll come back to this later and see how it's gone) So what do I want out of The Data School? 1) Expertise...

read more

Catch-DS14

I started at The Data School on the 1st of April, where thankfully I found out that it wasn’t an April Fool’s joke. I was a little bit nervous on Monday, but this was quickly dispelled as everyone here is really nice and super friendly (even Andy). During the first...

read more

DS14 – Week 1 Recap

Hello! I am Natalia and I can proudly say that I am part of DS14 together with 8 others. I started my journey at the Data School on 1st April and have just completed the first week. Similar to my fellow cohortians, I will be blogging about my experiences and learning....

read more

Dashboard Project Week 8, Web Scraping & APIs

Last week we had another break from usual client projects. Instead, the main topic for all the week has been web scraping and APIs. These topics were taught to us by Andre.
This, of course, was a big hint on what to expect for the Friday project presentation session. In fact, last week, my fellow DSers and I have been given the task to produce a visualisation based on data obtained by either web scraping a site or API calls.

read more

Easy Connections – Alteryx

Often on Alteryx you can find yourself working with lots of different connections, especially when using joins. While this is only sorted with a few mouse clicks; it can get rather tedious, and nothing is worse than missing your connections and having to pull over...

read more

2 Months in – the Half-way House.

It only feels like a week since I wrote my first blog, discussing what I had learnt during my first week at the data school; they do say time flies when you are having fun. I now feel in a much better position to add some perspective to this reflection, and hopefully...

read more

A walk-through guide to the DS application process

If you’re reading this then you’re probably thinking about (or maybe in the process of) applying to the Data School. What a great decision you have made. This may seem like a fairly long post, but I’ve tried to make it easy to navigate by breaking it into different...

read more

My Top 5 DS Moments

With only a couple days before the end of my Data School training I'm feeling prematurely nostalgic. These past 4 months have been a fantastic experience in so many different ways and I thought I'd pick out my own 'top 5' favs. 1. A new (data) world of...

read more

Dashboard Project Week 7, Analysing Strava Account

Last week DS 13 has got a break from client project, so our Friday activity consisted of a dashboard project, as it has been during the first month of Data School.
The project consisted of analysing the data that Andy
downloaded from its Strava Account. Over 1400 sports activities during a 7
years time-span.

read more

Jon’s DS13 Week 7 Recap

Week 7 of DS13 saw us receiving a break from client projects and instead was back to focusing entirely on learning with a particular focus on spatial data and data preparation. Day 1 We spent Monday covering more Tableau Advanced topics with Dan Farmer. This involved...

read more

Tick multiple fields at once in Alteryx Select Tool

Here’s an Alteryx quick tip which might save you a lot of time in the future when using the Select tool. Have you ever had to tick box after box in Select because there is no obvious way to tick multiple boxes at once? Well, the good news is you can tick multiple...

read more

Alteryx Tip: Merge 2 Shape Files

During one of our client projects, we were given a challenge, which consisted of merging 2 different shapefiles, in order to visualise them in Tableau. These files corresponded to the same area, one containing the other (e.g Counties within Regions). In this blog post, I will describe this process, using Italian Regions and Provinces (sub-areas of Regions).

read more

Create a Radial Bar Chart in Tableau

For Makeover Monday this week I decided to try to mimic the original design, a radial bar chart. I had never built a chart like this before so wanted to give it a crack and felt that following it up with a blog would help cement my learnings. You can view and download...

read more

Adding an All Option to a Parameter Filter

A Parameter is defined as a user generated value that allows the user to change the view. A parameter can also be used as a filter. For this example the EU Superstore data set is used. I start by putting the Country in the view. I'll be using Region as my filtering...

read more

Jon’s DS13 Week 6 Recap

Week 6 of the cohort 13 at the Data School was the least lesson-focused week so far, with the focus instead around the project with bursts of teachings sprinkled in. Day 1 Unlike the previous week, this week we were working with clients within our timezone and thus...

read more

Insert a hyperlink onto your dashboard

A simple task that takes a few more steps than maybe you’d think in Tableau. Shout out to Eva Murray (@TriMyData) for this technique. Step 1 Create a calculated field containing the text you want to be clickable. Step 2 Drag the hyperlink field onto a worksheet, more...

read more

Second Client Project, First Imposter Syndrome Case

Last week I wrote a blog post in which I explained the work that my fellow DSers and I have carried out for our first client project at the Data School. This week, instead I will focus on the difficulties I have encountered during our second client project and how these reflected in my actual presentation.

read more

Using Regex to find key information from a free input text field

Preppin data week 5 spoilers ahead. Complete the challenge (you don’t need Regex) before you read! On Tuesday, we learnt what Regex is and how we can use this in Tableau, Tableau Prep and Alteryx. So when I saw that Regex could be used to help solve this week’s Preppin data challenge, I saw this as a great chance to practice using Regex and my Tableau Prep skills at the same time.

read more

Creating a Row Total field in Tableau Prep

Suppose we have a car dealership dataset that has a row for each week of the year and a column for each colour of car indicating how many cars of that colour were sold that week. DATE | Red Cars | Silver Cars | Black Cars | Blue Cars What if we then wanted to create...

read more

DS13’s First Client Project

Last Friday, I and my fellows DSers presented our first client project since the beginning of our studies. So far, every Friday, we had the opportunity to watch DS12 client project presentations, while we would produce a presentation based on some data provided by our coaches, but not linked to any specific client. Hence, this represented an important milestone for our cohort, from now on this will become our weekly routine.

read more

Small tips to reduce changes in Tableau Prep

While completing this week’s Preppin data challenge, I noticed a couple of small things that would reduce the number of changes listed in Tableau prep. I feel this can be useful as I find it is less daunting to look at what is happening in a tool when it has 10 or...

read more

Jon’s DS13 Week 5 Recap

This week was a bit of a milestone week for a number of reasons including the fact that it was our first client project and also the week where we all signed up to take the Tableau Desktop Qualified Associate exam! I think one of the trickiest things we encountered...

read more

How to recreate Tableau’s INDEX function in Alteryx

In Tableau, table calculations are a quick and easy way to manipulate data in the view to gain insights and also organise the data. The INDEX function is one example of the latter. Essentially, INDEX() ranks each row. Crucially, as it is a table calc, the ranking can...

read more

Project Week 4 – Table Calculations in Alteryx

Last Friday’s project challenged us to practice the two main topics covered during week 4, Table Calculation in Tableau and Macros in Alteryx.
The task aim was to reproduce as many table calculations as possible in Alteryx, transforming them in dynamic macros.
In this post, I would like to show the calculations I’ve managed to reproduce in the time span of 4 hours.

read more

Jon’s DS13 Week 4 Recap

Day 1 This week kicked off with two days of learning about Alteryx Macros with Phil Lowe. In short, Macros are a workflow packaged into a single tool. The purpose of this can be to provide interactivity to a workflow, make a complex process simple to use, or allow a...

read more

Dashboard Week #5 United States Interstate Traffic

Today was our last day of #Dashboardweek, what a week has been! The data was about United States Interstate Traffic. Because Friday is presentation day at the DS, we only had until one to prepare the data and create a visualisation. This time the data was already...

read more

Dashboard Week, Day 5 US Highway Traffic

Today's challenge was to visualise one month of hourly traffic counts at stations across the U.S in Tableau Prep. Joining and prepping the data in Prep has reinforced my preference in Alteryx. Every new action in Prep causes the workflow to run which leads to a lot of...

read more

The Final Countdown (Dashboard Week Day 5)

Today our challenge issued by Andy via his blog was as follows: Metrocosm is a great resource for interesting data sets. For their final day of Dashboard Week, DS12 will need to visualize one month of hourly traffic counts at stations across the U.S. There are two...

read more

Dashboard Week Day 5 – US Interstate Traffic Flow

Finally. The the last day of dashboard week had DS12 looking at interstate traffic flow in the US. Check out what I came up with here. No web scraping or APIs to be called today, but that meant that any data prep that needed to be done, had to happen in Tableau Prep....

read more

Dashboard Week – Day 5

The final challenge of DW is an abridged one, with blogs needing to be published and Dashboards complete by 1pm to be ready for an afternoon of presentations. Andy's weapon of choice today was a dataset containing a month's worth of US interstate traffic records,...

read more

Dashboard Week Day 5 – US Interstate Traffic

Under serious time pressure to write this one. We had to make something with data concerning the number of cars passing particular stations on interstate routes in the US. The data is from here: http://metrocosm.com/get-the-data/#interstatetraffic I guess eyeballing...

read more

DS12’s Dashboard Week, Day 5

What do you do when your date columns are split into three different columns? In other words, you have three columns: Year, Month, Day. To put them together in Tableau (or Prep), create a calculated field and write as seen in Image 1. Image 1: Creating a date by...

read more

Dashboard Week, Day 4. USA Drought Statistics

So yeah, this one didn't go as well as planned. It took a while to work out the correct api call, since not all the parameter options were laid out in the documentation. I decided to look at the Weather Forecast Office Statistics data on drought using the drought...

read more

Apply for The Data School

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