The Data School Blog

Dashboard week: decoding the data

How do Americans spend their time was our dataset this week from Andy Kriebel since 2003, the Bureau of Labor Statistics sponsored the American Time Use Survey who asked thousands of people aged from 15 years and older the question: How do you spend your time? One...

read more

The Alteryx Essentials

Day 2 began with attempting to understand the very basics of Alteryx. Our first day was filled with jokes about how tricky these first few weeks of wrangling new software can be, so we were all expecting a challenge. After a few exercises to help learn the...

read more

Dashboard Week: Day 2 – How Americans Spend Their Time

Today’s data set took us deep into the life of Americans. The American Bureau of Labor And Statistics publishes data about how American spent their daily time. By the minute, the days are broken down into Major Categories e.g Household Activities or Work & Work related activities. These categories are then further broken down into sub-categories.

read more

Dashboard Week – Day 2

Day two was…… tricky……   Today’s mission was to access the data on the ATUS (American Time Use Survey) and present some interesting findings. Well to start with, actually getting the data in Alteryx was the single most difficult and confusing thing I have ever done…...

read more

Dashboard week: generate rows to get more results

For dashboard week: day 1 we had to web scrape the results table of the Prudential ride London from their official site: https://results.prudentialridelondon.co.uk The first step was to be able to download and access the data was to use Alteryx and build a workflow...

read more

Dashboard Week – Day 1

So this week we begin Andy’s favourite part of the dataschool, dashboard week. Where he gets to see us sweat (Andy’s favourite past time) by pointing us in the direction of some data, get us to collet said data, pull it through Alteryx and in the few minutes we have...

read more

Dashboard Week: Day 1, Prudential Ride London

It's been a busy few days here at DS HQ The DS9 squad are all taking the Tableau Desktop Qualified Associate Exam. DS10 has just kicked off (welcome, guys!). We're imminently moving to a new home to accommodate our growing family. It's all go. What better time to get...

read more

Dashboard Week Day 1 – Prudential Ride London

The infamous Dashboard Week has started! Today we looked at results of the Prudential London cycling event which took place at the end of July. Their website contains results of every cyclist who took part in the race, including age group, time needed to complete the...

read more

Dashboard Week Day 1: DNA charts

This blog post talks about the first day of dashboard week. We had to create an alteryx workflow that scraped the data from a website. We then also had to create a dashboard from it and write a blog post.

read more

Tableau Tip: Sets and combined Sets part II

In the first part of the parameter and sets Series I explained how these tools can help us to highlight members of a data set based on one criteria (revenue of companies).
In part 2 I will take this analysis further and demonstrate how we can identify the most shining diamond companies based on 3 criteria: Revenue, Growth and Expenses.

read more

Calculating working business hours in Alteryx

The most common request you will receive is to calculate something based on work hours especially concerning questions around productivity, hours and sales. Laine has a detailed blog post on Part 1 of calculating business hours which you can access: here I will be...

read more

Calculating a variable based on business hours in Alteryx

Have you ever been asked to calculate something based on business or working hours? My guess is that you have. These things are pretty common, especially when working with clients that want to assess their productivity, sales, costs or pretty much anything else that involves working hours. So, in this blog, I will show you the workflow that me and @Soha Elghany made for a client project at the Data School.

read more

Alteryx: Dealing with multiple API’s

This week, our project involved linking to an API, cleaning the data in Alteryx and using Alteryx to launch this dataset into a dashboard we created in Tableau all within an Alteryx App. This blog post will talk about how to use two API’s by linking them together. To...

read more

All about parameters: part 2 #tableautip

In this tableau tip, I'm going to show you how you can link 2 parameters together and get them both to operate together just like in the image below. So for this example, I used the superstore data I calculated 'day of year' by using this calculated field:  ...

read more

Data Gym – keeping in shape: shapefiles and tableau

Integrating spatial files into Tableau is quite a recent addition. It's also an absolutely marvellous addition. You can read, in depth, how to work with them in Tableau here. In today's post I'm only going to focus on the actual architecture of the shapefile.   Quick...

read more

Tip Week #5 – Reflective Blog

With our second week finished, we have learnt so much already – both in Alteryx and Tableau. This week, we focused on Tableau 101. We started off with the basics, learning about different data types and extracts on Tableau. A great thing to get to grips with is the...

read more

Insert Key Word Here. The art of successful blogging.

Things are about to get pretty meta as I blog about DS alumnus Anna Noble talking to us about writing good blogs.   Anna's top tips: Pick a good title Use headings Include a byline Use key words and tags to help search engines pick up content Complete the metadata   ...

read more

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

Apply for The Data School

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