The Data School Blog

Dashboard Week #4

Today we had a special task! We had to create a viz using other software different than Tableau. My choice was Power BI, after giving a try to Flourish (and giving up after an hour). We were given Skiddle API to extract events data. I chose to extract events within 50...

read more

Day 4 of Dashboard Week

It was the ‘Don’t Use Tableau’ day of dashboard week. We took data from the Skiddle API about events within a certain radius. I used Power BI for my dashboard. I had been looking at these Viz types and wanted to use some sort of Map/flow chart to filter and compare...

read more

Dashboard Week Day 4

Today's task was to download Skiddle events data from their API and return all events that are within 50 miles of their hometown or from where they currently live, return the distance from their location to the event and return all fields available in the API. Once we...

read more

Dashboard Week Day 4: No-go for Tableau

For day 4 of Dashboard Week, our task was to download data from an API and build a visualisation in a tool other than Tableau. We were to pull every event within 50 miles of our hometown or our current city and return all fields available from the API. The results of...

read more

Dashboard Week Day 4

Today's task was to collect data about local events via an API, request a key, and use the authentication parameter in Alteryx to get the data. The API was found at github. The objectives were as follows. Return all events that are within 50 miles of my hometown or...

read more

Dashboard Day 4 – Cheating on Tableau

So day four is down and the challenge was to use an API call to bring in events near our hometown and create a viz using a visualisation software that wasn't Tableau. Ergh, I miss Tableau. So from my limited knowledge of the products on offer - Power BI, Looker or...

read more

Dashboard Week Day 3

The Data The data was pretty tidy so I just added some columns for the duration of the campaign and the number of pledges / duration. I was focusing on comparing the categories and sub catogories for quite some time when I realised that with the amount of inflation...

read more

Dashboard Week Day 3 – Kickstarter KPIs

Today our project was to create some KPI dashboards for the C-level and Analyst level using data on Kickstarter projects. After downloading and looking at the data the first step was to draw out ideas for the dashboards. Below are my rough sketches. I wanted to focus...

read more

Dashboard Week Day 3: Four KPI Dashboards

Today we were tasked with building four different KPI dashboards as preparation for working with clients on our placements. We needed to build one for a hypothetical C-suite, one for some hypothetical analysts, and a mobile version of each of those. The first...

read more

Dashboard Week #3 – Kickstarter

The third day of our Dashboard week and our task today was to look at Kickstarter data and generate a KPI dashboard and a more analytical one, both of them with its own mobile version. Less challenging than previous days but it was not easy due to time pressure! I did...

read more

Dashboard Week. Day 3

Fast dashboarding was the brief today. Great to working again with simple, clean data, but the time pressure and the need to bring relevant KPI information to the forefront has made this day challenging like day other in dashboard week so far. I ended up with four...

read more

Dashboard Week Day 2

Today's task was to scrape data from a pdf. The Diamond League (athletics events) was the chosen one!!! The data I chose to prep was from the Rabat 2019 meet. To parse pdf's in alteryx I used the following blog which was absolutely essential...

read more

Dashboard Week Day 2: Scraping PDFs with Alteryx

On day 2 of Dashboard Week, our task was to scrape data from a PDF using Alteryx and build a viz with the resulting data set. We each chose a different PDF of results tables from a meet of the IAAF Diamond League (I chose the Monaco 2019 results). According to Andy,...

read more

Dashboard Week – Day #2

Dashboard Week Day 2 Today's task was to choose a city event from the Diamond League Athletics website, download the PDF, clean the data in Alteryx and create a viz. Downloading data from a PDF through Alteryx requires an R tool, which we needed to install some new...

read more

Dashboard Week, Day 2: Diamond League.

I didn't know what Diamond League was this morning but i'm a little more familiar now. Results are available to view online from all Diamond League meets on their website, nicely packaged up in PDF format. See the below blog from Head Coach, Andy Kriebel....

read more

Dashboard Day 2 – Parsing PDF Problems

Day 2 down. Yesterday definitely gave me a false confidence, such a tough one today. We have never been taught how to bring PDFs into Alteryx, but that was exactly what the challenge was today! It was in truth a great experience that I know will serve me fantastically...

read more

Dashboard Week Day 1

First day of dashboard week. I created an iterative macro to scrape data from the Asos website to visualise in Tableau. The two most useful pieces of RegEx I used were: The non greedy expression .*? to get clumps of data between fields: for example <article.*? And...

read more

Dashboard Week – Day 1 – ASOS Web-Scraping

Dashboard week is here for DS15! Day 1 we were tasked with using web-scraping the ASOS website for all the clothing items, brand, cost, description and product types for the Men's and Women's new clothing. Andy posted the details our challenge on the Data School blog...

read more

Dashboard Week Day 1: Webscraping Asos

Day 1 of Dashboard Week was certainly a challenge! Our task was to web scrape all the new men's and women's clothing items from the Asos website in Alteryx and then use that data to build a viz in Tableau. We needed to pull out the brand, cost, description, and...

read more

Dashboard Week #1 – ASOS Web scraping

First day of DS15 Dashboard week and the task was to web script the ASOS website, both for Women and Men and use the information extracted to create a viz. The data preparation has been the part which has taken the longest. The first issue encountered was that the...

read more

Dashboard Week Day 1

Myself and the rest of DS15 included were tasked with web scraping ASOS's New-In Clothing for both men and women. Most of the day was spent in Alteryx, in particular the time was spent on inspecting the page source, regex'ing and making an iterative macro so that all...

read more

Dashboard Week Day #1

The task - to web scrape ASOS new in clothing for men and women. Problem #1 - Error: Download (1) Error transferring data: Failure when receiving data from the peer We had to trick ASOS to think that we were people and not scraping. In order to do so we had to go in...

read more

Dashboard Day 1 – Web Scraping

First day out the way and I am relieved to have it out of the way. I am actually pleasantly surprised with how I managed my time today. I completed the dashboard with around 30 minutes before the 5pm deadline, with enough time to ramble on in the blog. The task was...

read more

Welcome to Dashboard Week: ASOS

A hard start to dashboard week. DS15 were set to web scrape ASOS' website for data on their new items for both male and female clothing lines. (See the blog post!) https://www.thedataschool.co.uk/andy-kriebel/ds15-day1/ Today, I have learned lots about web scraping....

read more

Latitude and Longitude Values from Polygon in Alteryx

During an API refresher session we were looking at pulling data from the Police API using Alteryx. Usually we would pull data using various API calls to extract the data we wanted, however the Police API has an interesting feature which allows data to be pulled from a...

read more

My first 2 weeks at DS

Are you thinking of applying for the Data School or have applied already and are wondering what the first few days will look like? Then this one is for you.

read more

Why attend a Meet & Greet at The Data School?

Almost everyone who currently works at The Data School attended a meet & greet before securing a place. So what is it about our meet & greets that will give you the edge over a fellow candidate? Maybe it's the Pizza... maybe it's the free beer... or maybe it's...

read more

Discrete vs Continuous

During our first couple of days as DS-ers we have been covering Tableau Fundamentals. For my first actual Tableau based blog post I am keeping it super simple with continuous vs discrete dates. The data I have given as an example shows sum of sales by quarter for each...

read more

Create Points and Lines in Tableau

In my last blog posts, I explained how to create points, lines and calculate their distances using Alteryx. In this one, I also want to show how to create points and lines using Tableau. As for calculating the distance, tableau does not have that feature yet, but it...

read more

APIs – Open up to a world of data (Part 2)

So yesterday I did a blog post on APIs, and how you can carry out a URL call to bring in each crime along with there counts. This is great and gives us a basic look at how we can utilise APIs. However, let’s take it a step further. APIs often hold huge amounts of...

read more

My Expectations on joining the Data School

Hi everyone, I'm Ryan and just joined the Data School as part of the DS16 cohort. It's looking like it'll be quite exciting but also daunting in fairly equal measure, so I've put together a short list of some of my expectations for my time here. 1) Up to this point...

read more

Seeing Stars (*) – Asterisks in Tableau

If you've used Tableau even a little you may at some point have been met with an asterisk where your expecting a value. From what I've experienced, the most common cause of this is when using the ATTR() function. So, what is going on? First lets understand what the...

read more

Alteryx – Time Series Analysis

Alteryx uses predictive analytics to identify patterns in historical and transactional data to identify risks as well as opportunities. The predictive tools are built using R (programming language), but there is no need to learn R to execute these predictive tools as...

read more

Scatter Plot Drill Down

Following on from my recent webinar on set actions in which I was unable to finish the whole exercise to drill down two levels in a scatter plot I mentioned there would be a blog post to explain this very soon, so here it is! This also coincides nicely with my first...

read more

My (Great) Expectations

It’s day 2, and Andy has asked us to write down what we expect from our Data School experience. Peering over at the screens of my fellow DS16 members, I’m seeing lots of lists containing specific, tangible expectations, so I’ll try and mix things up a bit with some...

read more

My Expectations of The Data School

Having graduated with a degree in History and an MSC in HR Management, if you had told me 5 years ago that I would be kick starting a career in data at the age of 27, I would have thought you were joking! I was first intro’d to The Data School whilst working at GRB....

read more

APIs – Open up to a world of data (Part 1)

APIs are an essential tool in your search for exciting datasets to go forth and visualise. They allow you to pull in data from a database somewhere in the world, and even better they are often live and will update through each call. For an extensive list of APIs you...

read more

DS16: Expectations

I think the application process for The Data School has given a small introduction as to what to expect from The Data School and life as a data consultant. These are my expectations after Day 1: There will be things I won't grasp immediately but there is no shame in...

read more

Expectations of The Data School

Hi everyone! My name is Joe and I am one of the latest cohort to join the data school. What are my first impressions and what do I expect is to come? In this post I introduce myself and answer these questions.

read more

Clustering Analysis in Alteryx

'Predictive Grouping is an approach that allows users to assess and create the appropriate number of clusters (groups) for their data to be assigned based on their similarity to each other in the same cluster and dissimilar to other data assigned to other clusters.'...

read more

Tableau Desktop Certified Associate Exam: My Top Tips

So, a couple of weeks ago I passed the exam and am now a qualified associate. Along with my new shiny badge on LinkedIn, it’s a real step forward in my Data School Journey. I thought I would share some tips on how I approached the exam for anyone looking to take it....

read more

Sentiment Analysis using a Dictionary

Paul Houghton has a great blog post and webinar on creating a sentiment analysis workflow in Alteryx using either an API, Dictionary, or Custom model. Check them out for a really good guide on how to use each of them! In this blog I will take a deeper dive...

read more

Standard Alteryx Macro Example

What is a Macro and why should we use one? A macro is basically an Alteryx Workflow that is compressed down to be a single tool. They allow you to take a section of a workflow that you need to repeat. You can then use this macro in other workflows. There are 3 types...

read more

Why not give Certified Pro a go?

This week I decided to try my luck with the Tableau Certified Professional Exam. Sure the Exam Prep Guide recommends a year's experience, but it's generally my philosophy that you might as well give it a go! ""What if I fall?"Oh but my darling,What if you fly?” ...

read more

Add a Customizable Point at the End of Your Line!

Here is a quick tutorial on adding a customizable point to the end/start of your line chart. We are aiming to produce the below chart. How to Build 1. Start by building this chart using Superstore data. The chart shows profit over time (continuous months) for the...

read more

Distance between two points using Alteryx

Using fundamental Spatial analysis in Alteryx is pretty easy, thanks to some of the tools, which do all the work for us 😊. This time we are going to calculate the distance between two points on the Earth, a basic measure in the Spatial world, which might come handy...

read more

Using Reg(ular)? Ex(pressions)?

RegEx or Regular Expressions is a sequence of characters that define a search pattern. The example I will show you uses Alteryx, a software that makes advanced analytics accessible to any data user. Why use RegEx? RegEx allows the user to extract specific parts of a...

read more

Ranking in Tableau Prep Builder

Unfortunately, there is no simple tool to rank values in Tableau Prep Builder but the Preppin’ Data Week 16 solution makes this all possible! I have taken data of the life spans of animals and put this into an excel and opened this in Tableau Prep to try and rank...

read more

Quick Tips for Presenting Data

Data analysis is important but if we are not able to communicate and present effectively, it seems like a bit of a waste? During our time at the Data School we have been taught the importance of presenting and have had the chance to practice a lot. I wanted to share...

read more

Joins, Unions, Blending – Combining Data Sources

Joins vs Unions When I first started the data school (way back in April) I would refer to the "coming together" of any 2 data sources as a "join". It wasn't long before I was taught how inaccurate this was and, indeed, the very first page of my data school notebook...

read more

Revising Alteryx Gallery Ahead of the Advanced Exam

You may remember from a previous blog that my first attempt at the Alteryx Advanced Exam was unsuccessful. One of the reasons for this was that I didn't realise there would be questions on Alteryx Gallery (and indeed, didn't even know what Alteryx Gallery was!) This...

read more

Communicating with Colour

A couple of weeks ago we spent some time exploring data visualization best practices - e.g., some of the basic principles of human visual perception, when to use different chart types, use of colour and highlight, etc. A good visualization can help us identify...

read more

Context Filters & Tableau’s Order of Operations

When covering the fundamentals of Tableau Desktop, one concept that jumped right out at me was context filters. I have spent only a little time with Tableau but would have already benefited a lot from understanding this earlier. So.... ask the community for help!!! I...

read more

Create a Control Chart

The control chart is a graph used to study how a process changes over time and determines if a manufacturing or business process is under control. I believe this is a beneficial tool for every company, so in this post, I will try to explain how to create one in...

read more

Machine Learning in Alteryx

Today we had the pleasure of being taught Machine Learning by Bene and it's honestly been one of my favourite days! It's a topic that sounds complicated, but once again Alteryx's drag and drop interface makes it simple. Machine Learning can be broken down into:...

read more

Dashboard Week – Last Day

For the last day of dashboard week we were looking at data from: https://www.openpowerlifting.org/data I wanted to first understand key questions that users may be asking to make my data relevant. Then look at the interations I could go through to produce a dashboard:...

read more

Dashboard Week – Day 5

The task for the final day of Dashboard week did not require any Data Prep and was based on the History of Powerlifting. We had to complete the task by 1pm and present our dashboards from yesterday and today to DS15. Here is my viz: For today's viz, I wanted to...

read more

Powerlifting – Dashboard week Day 5

On the last day of Dashboard week, DS14 and DS15 had the same task - create a dashboard about the history of powerlifting (data can be found here) using a visualisation tool of your choice. I cannot express in words how happy I was to be able to use Tableau Desktop...

read more

Dashboard Week – Day 5 (Power lifting)

Today was the final day for dashboard week and guess what, we were reunited with Tableau Desktop 😊 Lily and Nick found a data set on Kaggle about the history of power-lifting. The data set provided was already formatted correctly, so there was no need to use Alteryx...

read more

Dashboard Week: Day 5

Task https://www.thedataschool.co.uk/andy-kriebel/day-5-powerlifting/ Data Prep Luckily today we didn't have to do any data prep - most probably because we had to be finished with the dashboard and blog post before 1 PM The Viz For today's viz - I wanted to compare...

read more

Dashboard Week: Day 5 – POWERLIFTING

Dashboard week has sadly come to an end. For our last task, we looked at the history of powerlifting. Here‘s the full brief for the task. We had limited time today (only 3 and a half hours) but luckily no data prep was necessary. Here’s the link to my final product...

read more

Dashboard Week – Day 5

The final day is here. Today's data was about powerlifters, and since we only had half a day to produce our dashboard, little (no) data prep was required. Since we only had to focus on dashboarding, I quickly came up with a lot of ideas which took up my first hour....

read more

A Powerful End to Dashboard Week

Today we were looking at the history of powerlifting and we had free rein of which tools we wanted to use! Read more in Andy's blog. This is probably the dataset that I've found most difficult to work with, as it's not one that I'm familiar with at all! So I spent the...

read more

Dashboard Week – Day 4

For Day 4 of Dashboard Week we were tasked with looking at Candy Survey data between 2014-2017. Andy stated that we could only use Tableau Prep Builder to clean our data and Tableau Server's Web Authoring function to build our visualisations. Tableau Prep Tableau Prep...

read more

Dashboard Week – Day 4 (Candy Survey Data)

Day 4 we had to visualise survey data about candy. We were only allowed to use Tableau Prep to clean the data. I was pleased to use Tableau Prep, as I’ve mainly be using Alteryx. Below is my workflow: However, we had to create our visualisation on Web Edit. Web Edit...

read more

Dashboard Week: Day 4 – Candy

Cannot believe it is day 4 of our dashboard week! Today, we were working with survey data about people's favourite candies. Here‘s the full brief for the task. We had to use Tableau Prep Builder instead of Alteryx to clean up our data. It was in a relatively good...

read more

Dashboard Week – Day 4 – Candy!

Today was day 4 of dashboard week and the roller-coaster continues! Yesterday was a good day, so today was due to be a tough one again. The task today was looking at the US Candy Hierarchy from The Science Quarterly Review. There were some rules in place, we couldn’t use Alteryx and we had to complete the dashboard in Tableau Web Edit only.

read more

Dashboard Week Day:4

Task https://www.thedataschool.co.uk/andy-kriebel/day-4-candy/ Data Preparation To prepare the data we were only allowed to use Tableau Prep Builder. Given that the data was coming from a survey - I decided to focus only few fields and ended up with 4 columns instead...

read more

Candy Ratings – Dashboard week Day 4

Our task for the fourth day of dashboard week was to visualise survey data about candy. We got Alteryx taken away from us - only Tableau Prep was allowed to use, and we were still not allowed to use Tableau Desktop. Instead, we had to build our dashboards in Tableau...

read more

Dashboard Week – Day 4

Today was all about Tableau Prep Builder and Web Edit on Tableau Server. We were dealt with pretty harsh limitations for today's data set which was about candy and the sentiment around certain candies. There were 4 different excel files for 4 different years which all...

read more

Apply for The Data School

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