The Data School Blog
Follow along with my thought process and ideas for my Makeover Monday this week on teacher salary disparities.
The latest challenge we were assigned here at the Data School involved completing a #MakeoverMonday, which focused on the gender pay gap amongst teachers at state-funded schools across the UK. In this blog post, I will highlight what I liked and disliked about the original Viz, as well as elaborating on my own version of this week’s #MakeoverMonday. Here is the original Viz:
This Monday I have critiqued the #MakeoverMonday viz and made some iterations to it
Our task for today was to complete this weeks Makeover Monday, and to analyse what we liked and didn't like about the original visualisation. Here's the original viz: What I liked: Its relatively straight forward, and so easy to understand.Focused on most recent data....
Hey Everyone!! So today I will walk-through my thought process for my latest Makeover Monday. I usually like to spend a bit of time on Makeover Monday (~3hr) to iterate on all the smallest, and probably pointless, design quirks. But not today. I gave myself a strictly...
This weeks Makeover Monday provided data to see how there is a difference in salaries between Male and Female workers, irrespective of job level. I decided to explore the gap between salaries using a dumbbell chart.
#MakeoverMonday Week 37 looks at the average pay of teachers in state-funded schools across England.
Our task was to makeover a visualisation based around the mean pay of classroom, leadership and head teachers in England by gender.
This blog touches on the difference between Live data connections and Extracts. It focuses on the question of when you go to refresh your data source, what do all the different options mean?
In order to collaborate effectively, maximise storage economy and standardise versions, it is good practice to publish data sources to Tableau Server.
It really annoys me in Tableau when one of two things happen The table you make doesn't label what the measures are (see below) 2. Using a chart title doesn't centre the description to the axis (also see below) There are two neat tricks to alleviate both of these...
Day 3 was my favourite day of dashboard week. Everything seemed to fall into place and I was really happy with the outcome of the dashboard. Not only that, but the data was extremely topical and interesting as well
Day 2 was certainly a challenge wrestling with some data prep, however, the topic certainly quenched my environmental thirst
So dashboard week has come and gone for DS20, gone by a few weeks so this blog is a little bit late. (I’m sorry!) This series of five blogs will look at the dashboards that I created over the week and what I would improve upon each one now I’ve had some time to reflect. (Maybe I’ll write some update blogs later this week or next week when I’ve made those improvements?)
Within the Maintenance page of Tableau Server, there are a pre-build administrative views which allow you to monitor server and site activity in different ways. But in addition to this, you also have the option to create your own customised administrative views using Tableau Server, to analyse your site or server profile.
Setting up an incremental refresh on Tableau server is very easy. If you are wondering why you should set up an incremental refresh, have a read through this blog by Luke. First of all you will need to use a data source that has either a Unique row ID or a time stamp...
When connecting to data sources that require authentication for access, you're required to input credentials. For example, when connecting to a PostgreSQL data base you'll be presented with this view. While it's not too much information to input, every time you try to...
Adding filters to worksheets can be a particularly laborious task (At least in my experience. Even more so if you’re adding the same filters to multiple worksheets! “If only there was a quicker way!” I hear you ask. Well never fear reader, there is! Let’s use Tableau Superstore to show you how.
In this blog I go through the differences between a full and incremental refresh to not only solidify the knowledge to myself, but also enlighten others to when you should use them and why
The multi field tool makes it easy to carry out a function on various fields. I put it to the test with a weekly challenge and although a very basic use, it was still very useful in understanding its functionality.
For this blog post I will do a guided, step-by-step walkthrough of a solution to Alteryx weekly challenge #193, with a specific focus on the ‘MULTI-FIELD FORMULA’ tool.
This challenge revolves around a new “Meal Deal” being added to a menu and we had to study the potential impact on recent transactions. Here is my solution.
For this blog post I will do a guided, step-by-step walkthrough of a solution to Alteryx weekly challenge #211, with a specific focus on the ‘REGEX’ tool.
For this blog post, I will do a guided, step-by-step walk-through of a potential solution to Alteryx weekly challenge #219, with a specific focus on the ‘CROSS TAB’ tool.
As part of DS21 week on alteryx we had a lesson with Chris Love on using Multirow and multifield formulas, we had come across them briefly before but went into a lot more depth. He recommended Challenge 3, so i thought id give it a go even though it was classed as...
Using Cross Tab tool to solve Alteryx Weekly Challenge #102
In Alteryx, multi-row formulas are powerful tools in data preparation that give us the ability to access future and previous rows to design formulas or replace missing values. This blog post looks at how I used multi-row formulas to solve Alteryx weekly challenge #21!
Hey! So this blog will be looking at Alteryx challenge #219. This challenge focuses on most of the favourites tools as well as cross-tab so this could be of help to a beginner (like me).
This blog explores how you can use the crosstab tool to manipulate data.
This week, we focused on Alteryx. Each day we were introduced to a new tool and learned about its features as well as use cases. I’ll be honest in saying that I still find Alteryx very overwhelming and so this blog post will help me re-affirm my learning and hopefully help others who are new and confused to not give up. I’ll be going through a weekly challenge with screenshots to help.
The aim of this challenge was to switch the format so that the product information was shown in rows as opposed to columns. The input had the Market, Product and Type categories in the first 3 rows, so the first step was to separate the first 3 rows from the data...
Hey! Today I’ll be going through challenge 56 of the Alteryx Challenges – a regex special edition. Now if you’ve got no experience in Regex, don’t worry, this will be a good place to start.
Using Multi-Row Formula tool to solve Alteryx Weekly Challenge #21
The crosstab tool allows us to transform data from a long to wide format. This Alteryx weekly challenge uses this feature to explore the improvement of female students at NYC Public Schools in Maths.
This week DS21 have been focusing on Alteryx, looking at several different topics across the week, we spent Wednesday learning the basics of Regex with Oliver Clarke, and today we were tasked with completing one of the Alteryx weekly challenges that required Regex....
This challenge involved parsing the city name, state and zip code out of an address which was in a non-standard format. Here is my solution using RegEx.
The goal of this challenge was to determine the top 5 based on the count. Here is my solution using the Multi-Row Formula tool in Alteryx.
This Post looks at how Regex can be used to extract useful data from HTML tables.
Using RegEx to solve Alteryx Weekly Challenge #54
RegEx is a tool we can use to extract meaningful information from strings, which meet a set of conditions. This blog walks through my process of completing Alteryx Weekly Challenge #58 with an Alteryx Workflow.
For day three of dashboard week we took on Data on the US Coronavirus Aid, Relief and Economic Security (CARES) Act. We looked at the loans for businesses across the USA. The data can be found here...
It’s the last day of Dashboard Week for DS20 and not only will they get to analyze data about marijuana tests in Washington State, but they will also be joined by DS21.
Teachers are significantly unpaid. By how much? DS20 looks for the answers in Dashboard Week day 4.
This is the second part of a 5 part series of blogs on dashboard week. If you're not sure what Dashboard week is, have a look at my account of day one. For day 2 of Dashboard week we worked with climate data from the National Oceanic and Atmospheric Administration...
It’s here, dashboard week. This is the first entry in a five part series I’m writing about my experiences, thoughts and all the other good stuff surrounding dashboard week each day.
For this blog post, I will be dissecting and suggesting improvements for an old viz created by Head Coach Andy, as well as attempting to create an alternative Viz based on the fundamental principles of data visualization that we have been taught thus far.
My take on Andy’s US Unemployment Viz.
This blog will critically evaluate the visualisation ‘Who’s winning the Cola Wars?’. It is based primarily on Coke and its contenders across a variety of categories. It will explore this across certain visualisation best practice categories presenting a before and after.
First critical viz analysis and makeover
Today we were tasked with evaluating one of Andy's first tableau public posts, so here goes. I was given this dashboard about the impact of drug testing on baseball. There are a few elements that I like and think work well, there are also lots that I don't. My main...
Today for DS21’s project, we were given the assignment of re-designing one of Andy’s old visualisations, taking into account the things we had learnt from his presentation on best practices yesterday. The visualisation I analysed and re-designed was based on preventable disease outbreaks.
Hey everyone! So our task today was to analyse and evaluate one of Andy’s past visualizations across some of the dashboard practices he had taught us so far. The objective was to find areas on which we think we could improve and ultimately, produce a ‘better’...
Today we were asked by Andy to revamp one of his old vizzes using what we have learned so far during our Data Viz 101 sessions.
Let’s hold the US government accountable for day 3 of Dashboard Week and see how they’ve been giving loans to.
In this blog, I explain how I used Mapbox to isolate the map of Scotland and style it, as well as any additional steps I took to create my final map visualisation.
This blog is going to be a 5 part series sharing my personal experience with Dashboard week. Hopefully the challenges that I'm going to talk through and my mindset and actions in overcoming them is helpful to your your own endeavours, in both data and beyond. What is...
This guide will serve as an introduction to taking a chunk of SQL code, or a Stored Procedure, and recreating the logic and analysis within an Alteryx or Tableau Prep Workflow. It will not be a deep-dive into learning SQL or SQL logic, but will provide a good...
It’s day 2 of Dashboard Week for DS20 and they’ll be visualizing 125 years of temperature and precipitation data.
Since recently joining DS21, I decided to compare my experiences with using both R and Alteryx, and offer a sample workflow to explore the strengths of both tools! I found Alteryx handled the exercise incredibly well, while R was slightly more complex to use.
It’s Dashboard Week for DS20 and they’ll be developing KPI dashboards all week. Day 1 starts with data about pitch locations for MLB pitchers.
A few thoughts on the advantages of Alteryx from a complete beginner.
Starting a new career in the midst of a pandemic is not something I ever thought I would do, but this has definitely been both a refreshing and exciting change!
Using a drill down map can offer more detail about a specific location. I’ve used the Tableau Superstore data to create a map that will drill down from Regions to States, shown below.
In this blog, I will explain how you can add dynamic reference lines to a time series data which will allow the user to see the data relative to a selected reference date.
Quick Top N Labelling method using the RANK table calculation.
This is a quick and easy method to return the first value in a concatenated string field without having to get messy with REGEX.
What are the benefits of using a formula tool rather than a spatial tool?
Tableau’s default method of aggregation for a measure is Sum. However, Sum will not always be the most appropriate method of aggregation to use.
An brief (and simple) explanation of what a violin plot is and how to make it in Tableau
When making a dashboard with a compact design space is a precious resource. See the Dashbaord below as an example of having little room to spare without disrupting the layout If we wanted to add filters to the dashboard, it would push everything below it down and go...
DS20 have recently been taking their Alteryx Designer Core Certifications so I wanted to share the tips and tricks I’ve learned that helped me massively in my preparations.
I know that something I’ve been guilty of, especially early on in my training, is adding actions to new worksheets to enable the desired interactivity for users. But wait, that’s a good thing right? Well yes ….. until you move that worksheet into a dashboard and suddenly those beautifully formatted worksheet actions don’t work anymore.
Hiding vs excluding in Tableau is not something I had really considered before, because it’s not something I had used much. But it came up in training the other day and it turns out the difference between these two is really important if you’re using table calculations!
At the end of the day, everyone has their own way of designing dashboard, and there is not necessarily one wrong or right way. In this blog I’ve tried to highlight some practices that I myself have been guilty of doing and has limited the full effectiveness of some of my dashboards without me realising.
The use of the datediff formula in Alteryx makes it easy to count how many days there are between two dates, but what if you only wanted to count the weekdays?
I recently passed the Alteryx Designer Core certification so I wanted to share the tool that helped me out massively, the text input tool as well as some quick fire tips about the certification.
Tooltips are a brilliant way in Tableau to offer extra insight into what your visualization is showing. Having a dynamic tooltip allows users the same flexibility in tooltips that they’d see elsewhere on their dashboards.
There are the 4 things I use in Alteryx to help me keep track of what I’m learning at the Data School or help me track what each tool is doing in a workflow. This blog will take you through each.
There isn’t an immediately-apparent way in Alteryx to populate a drop-down menu from a column in your dataset. But don’t worry, there is a workaround!
Ever wanted to build a chart but didn’t know where to look for advice on how to build it? I go through 5 chart types that will take your analysis to the next level as well as providing sample charts and blogs on how to build them.
If you have a lot of worksheets in a particular workbook, it can be time consuming if you have to format them all the same way. Now I know what you’re thinking:
“If only there was a way to copy the formatting from one worksheet and apply it to another!” Well don’t worry dear reader, there is!
In our client project this week, the dashboards we were looking at had some calculations containing the TOTAL( ) function. It left me wondering, what’s the difference between TOTAL( ) and WINDOW_SUM( )?
This blog follows on from a 5-min video I made with instructions on how to create a Parallel Coordinates chart. If you're not sure how to make one, feel free to follow along here. By the end of the video, I created something that looks like this This blog will take...
Did you know there is a ‘spatial tool’ in Alteryx that is not a Spatial Tool? Say you wanted to combine several spatial objects into one. The quickest way to do that is with a summarize tool.
During my last project I was asked to create a moving 12 months sum of revenue for each month and then compare the sum to the moving 12m sum of the same month one year earlier for each of the displayed last 12 months and display a % change between those values. The...
I've just completed my dashboard for week 27 2020 of Makeover Monday, the topic is on self reporting of the presence of symptoms of mental health experienced over the last week. Like usual, my cohort DS20 dove in to the data to see what we could create in the hour we...
DS20 is underway. The work they created to get into the Data School was quite impressive.
While Sankey charts may seem daunting at first, they’re a great way to show a change of flow between more than one category or condition. For this example we’re looking at how the sum of sales changes between Regions and Categories in the Tableau Superstore data.
Show/Hide container buttons within dashboards help to declutter the view and make it easier to understand the data. But sometimes, it is not always clear to the user that they can click the show/hide button to view more hidden data. There are many ways to resolve this but I wanted to share an idea that I think may prompt the user in a more understandable way.
When you start creating dashboards in Tableau, you may find yourself experimenting with the different options in the 'Layout' tab. Padding is a great way to create space between different elements in your dashboard. It can make your dashboard look less cluttered and...
While basic sparklines can give insight into trends within data, how can we add an additional level of detail to them?
An attempt at trying to explain dimensions and measures without mentioning continuous and discrete fields?
Similar to Sparkline charts, Sparkbar charts are small, lightweight charts that typically do not have axis. They’re a quick and amazing way of visualising your data, without needing the complexity of a full blown chart.
The order that Dimensions are placed in columns or rows will affect how the view is sorted In the view below we have two dimensions, a player name column and a calculation column that indicates whether each player did better in their last season compared to the one...
Use Tableau to create a Pareto chart
Fix the scales of a diverging bar chart with a pair of hidden reference lines.
Sparklines are a tiny chart, usually drawn without axes, that enables you to quickly compare trends over given values. I’ve found they’re a great way to compare trends in values over time. You might use a sparkline to compare seasonal increases or decreases, stock market values or to highlight the maximum (or minimum) values.
Pareto Analysis is used in business to compare the impact of one variable on another variable. It is based on the 80/20 rule – often businesses will find that 80% of an output variable comes from 20% of an input variable. In a positive sense, a company might be able...
Ranking is a great way to not only visualise your data, but also offers some great analysis. I’ll show you how to rank your slope graphs and how to optimise them using colour.
Tableau String Calculation: FINDNTH( ) – Finding the position of a letter or sub-string within a longer string
Today we were given an overview of many of Tableau's functions, one of which was the String Function FINDNTH. It allows you to find the position of a particular letter or sub-string within a string. • Continue reading to learn about how to use it. • Scroll down to...
Apply for The Data School
Our application process is always open. Get started with your application today!