Brian Scally

Brian Scally

Brian Scally

Brian developed an affinity for data analytics and visualisation while studying cognitive neuroscience. During his PhD, he analysed brain activity from older adults and individuals with dementia. While searching for opportunities that would afford him more data and a wider variety of projects, he found The Data School, applied, and hasn’t looked back. He is excited to get stuck into the world of visualisation and consulting.

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

Dashboard Week Day 4 – USA Drought Monitor

Today's task was to use data from the United States Drought Monitor API, in particular the comprehensive statistics. Raw figures of square mileage affected by drought, as well as the percentage of area affected by drought were available at different spatial levels of...

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

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

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

Publishing to Tableau Server with tabcmd

Last week I got acquainted with tabcmd, the Tableau Server command line utility. With tabcmd, you can automate various Tableau Server processes from your local machine. In this post, I'll document some of the publishing processes and automation that are possible with...

How to make a correlation matrix in Tableau

A correlation matrix is handy for summarising and visualising the strength of relationships between continuous variables. Essentially, a correlation matrix is a grid of values that quantify the association between every possible pair of variables that you want to...

Web Scraping JavaScript Content

Introduction Web scraping is an extremely powerful method for obtaining data that is hosted on the web. In its simplest form, web scraping involves accessing the HTML code (the foundational programming language on which websites are built) of a given website, and...

Chaining apps in Alteryx

I hit a wall in my previous post when trying to dynamically update a drop down interface tool with the field names of a given input dataset. The issue was that if the field names in the incoming dataset were different to the field names of the dataset that I built my...

Filter by fields from connected tools in Alteryx macro/app

Today I encountered the following scenario in Alteryx when we were building our first macros and apps. Let's say we want to take the Sample Superstore dataset into our macro and filter by State using a Drop Down Interface tool: The Drop Down Interface tool needs to...

You don’t use E-mail?

We're sitting on the midweek hump of Week 1 here at The Data School as DS12. Day one consisted of digesting some background and history about The Information Lab and getting kitted out with some swag and laptops. On day two, Carl made it much clearer what our...