The Data School Blog
Last week, I sat the Alteryx Designer Core Certification and finally passed after many attempts. I received a lot of messages from others on how they should prepare and how to start their Alteryx learning journey. This blog post should answer just that and guide you through some things I learned to do and not to do along the way whilst providing many links to resources that helped me.
A step-by-step guide into making a dynamically shifting date slider.
Hey! Today we learned about bullet charts. It seemed like a great way to cram in lots of information into a single chart so I thought I’d run through the process of making it so the public can also benefit. Bullet graphs are essentially a bar chart of a single measure...
In this blog I explore two different methods for building Density Maps, and why using a Hex Bin method might be beneficial.
Learn how to swap two fields in Tableau Desktop keeping the rest of the view intact.
I will be showing how to create a dynamic reference line with a parameter action. We will also look at how to colour before and after the line.
Turning Reference Lines into Calculations: Using window functions and how they can add context to your visualisations
This blog looks at how we can turn reference lines into calculations, using the ‘window’ suite of functions within Tableau. I have offered an example, which adds context to the graph and provides a good example of when this conversion may be useful!
How to measure distance with maps This week in the Data school we have been going through a lot of different chart types and features within Tableau, one of them that I thought was particularly interesting was the ability to measure distance between closely located...
Last week was Tableau Conference-ish, as well as being my first TC ever – needless to say, I was very excited.
This blog post explores the most recent Makeover Monday dataset (Week 41), which initially uses a radial chart.
This week for #MakeoverMonday, we were asked to makeover a visualization by DataIQ regarding a survey and the industry sector breakdown of the participants.
I tuned into the session on how to make your own interactive resume on day 2 of Tableau Conference and then decided to use the resources provided and make my own. This was presented by Melody Cheung who is an Academic Programs Coordinator at Tableau. Follow along my process through this blog.
After watching an incredibly useful session at the Tableau Conference 20, I decided to create my own. Here is how I did it…
A detailed breakdown of the session. In case you missed it, one of the anticipated releases to come that was announced at TCish was map layers! If you’re anything like me, at the moment I rely on Mapbox with anything map related and then go into Tableau. Here’s everything we learned about map layers that we all have to look forward to.
When starting your Tableau journey remember that everyone was once a beginner.
At Tableau Conference 2020, Tableau announced that it would be integrating Einstein Analytics into its’ suite of products. This blog covers highlights from talks given today about this topic, and a brief overview of day one of TC20!
A solution to Preppin Data Challenge 2019 Week 43…
Our final challenge before beginning full-time at the Data School was to complete either a Workout Wednesday, Macro-related Alteryx Weekly Challenge, or a Preppin' Data challenge. I chose to tackle a previous challenge that I was unable to complete to see whether I...
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( )?
Apply for The Data School
Our application process is always open. Get started with your application today!