Dan Booth

Dan has experience working on a range of analytical projects where he has utilised his expertise in SQL, Alteryx, Tableau and PowerBi. His varied work includes being a project manager while working with a national cricket board through to building visualisations on key areas of interest within the public sector. He has also completed a project using machine learning which helped to aid player recruitment for a leading football club.

Dan has a strong foundation in data from his Data Science masters at The University of Sheffield. A highlight of his time here included achieving 95% on the module “Big Data”, which focussed on data analysis in Databricks and AWS. 

In his spare time Dan loves to travel and took the opportunity to study abroad for a year in Australia. Outside of this, Dan also enjoys playing and watching sports, in particular football and tennis.

Certifications

Blog Posts

Avatar
Wed 05 Feb 2025 | Dan Booth
Date Scaffolding in Snowflake
I am currently aiming to complete every 2021 Preppin' Data challenge in Snowflake. The link to my progress can be found at the bottom of this blog In my most recent challenge I ran into an issue that required scaffolding. Scaffolding is used when you have missing rows in a dataset
Avatar
Fri 31 Jan 2025 | Dan Booth
Dashboard Week Day 5- Using Figma in Tableau
Today we were tasked with building a dashboard using data we obtained from an API. For this project I focused on improving my dashboard design skills with the use of Figma. Figma is an open source design software, which can be used to build visually striking dashboard backgrounds
Avatar
Thu 30 Jan 2025 | Dan Booth
Dashboard Week Day 4- Accessibility
Today in dashboard week we were tasked with making an accessibly designed dashboard. Accessibility Guidelines consist of 4 parts (Perceivable, Navigable, Adaptable, Distinguishable). This blog will describe how each can be achieved in Tableau
Avatar
Wed 29 Jan 2025 | Dan Booth
Using API-Football in Alteryx
Today for dashboard week I got set a task to call data from the following API: https://www.api-football.com/documentation-v3?ref=thedataschool.co.uk#section/Authentication. This blog will cover how this was achieved. Step 1: Create an account with API football in order to obtain an access key
Avatar
Tue 28 Jan 2025 | Dan Booth
Dashboard Week- Day 2
Today we were tasked with converting the dashboard below into an insightful infographic of our choice. I decided to focus on a particular show, and after discussing with my coach, we decided that it would be interesting to see if one particular character impacts a shows popularity
Avatar
Fri 17 Jan 2025 | Dan Booth
Preppin' Data 2021 WK01 in Python
Last week I wrote a blog on completing the Preppin' Data 2021 WK01 challenge in SQL. This week I challenged myself to complete it in Python. I am uploading my solutions for each Preppin' Data challenge on Git Hub. Feel free to check it out here: https://github
Avatar
Fri 17 Jan 2025 | Dan Booth
My Three Favourite Things About dbt
This week I completed the dbt fundamentals course. This was my first time using dbt and three particular features really stuck out. The Ref Macro The ref macro is used to reference other models within a project
Avatar
Wed 15 Jan 2025 | Dan Booth
Using Data Sources in dbt
Today marked my first experience with dbt (Data Build Tool). While I’m still getting familiar with the software, I’ve already found several aspects of its data transformation process to be quite intuitive. One feature I particularly appreciate is dbt’s approach to managing data sources
Avatar
Fri 10 Jan 2025 | Dan Booth
Preppin' Data 2021 WK01 in SQL
This blog will talk through my process in solving the 2021 wk1 preppin' data challenge in SQL. I started with this dataset: Task 1: To do this I decided to use the function split_part(), which splits a selected string and generates a new column
Avatar
Fri 10 Jan 2025 | Dan Booth
Rows to Columns Pivots in SQL
Pivoting is a very useful data manipulation technique. This blog will talk through how rows to columns pivots are achieved in SQL
Avatar
Fri 10 Jan 2025 | Dan Booth
Creating and Populating Tables in SQL
To create a table with data in SQL you first build a frame for the data to go into. To do this you list each desired column name along with the data type for that column. The datatype options are as follows: Numeric- * INTEGER: A whole number
Avatar
Fri 10 Jan 2025 | Dan Booth
SQL Subqueries
A subquery in SQL occurs when a query is nested inside another query. They can be used in SELECT, WHERE or FROM clauses and are especially useful when you need to filter or aggregate at a different level from the initial queries results
Avatar
Fri 10 Jan 2025 | Dan Booth
SQL Fundamentals
Recently we had some sessions on SQL as part of our Data School training. It was a language I really enjoyed picking up, and this blog will go over the fundamentals of what we learnt
Avatar
Tue 24 Dec 2024 | Dan Booth
Regex Fundamentals
Recently, DS47 underwent training in Regex (Regular Expression). Although the language initially seemed confusing, it quickly became clear how powerful Regex can be for searching, matching, and manipulating strings of text based on specific patterns and rules
Avatar
Tue 24 Dec 2024 | Dan Booth
Dynamic Parameter Selection in PowerBi
I recently created a Tableau dashboard where the colour of each graph dynamically updated based on a value selected by the user (https://public.tableau.com/app/profile/dan.booth/viz/PremierLeague2425-TeamProfileComparison/GoalkeeperDashboard)
Avatar
Tue 24 Dec 2024 | Dan Booth
Filter Modifiers in PowerBi
Introduction Filter modifiers within PowerBi are incredibly powerful ways of making calculations dynamic and context-aware. In this blog, we will explore three key filter-modifying functions—REMOVEFILTERS(), ALLSELECTED(), and ALLEXCEPT()
Avatar
Mon 23 Dec 2024 | Dan Booth
Machine Learning in Alteryx
Having studied machine learning during my data science degree, I was eager to see how it could be implemented in Alteryx. To test the process, I created an example workflow where I used a gradient boosted model to predict football players transfer values
Avatar
Wed 06 Nov 2024 | Dan Booth
How to Import Custom Colours in Tableau
I have recently finished my first personal project since joining the Data School. My project involved creating a dashboard which analysed the success of new Manchester United Manager, Ruben Amorim, at his previous club Sporting Lisbon
Avatar
Sat 19 Oct 2024 | Dan Booth
Order of operations in Tableau
Understanding the order of operations in Tableau is crucial for ensuring that data is processed and visualised accurately. This blog will demonstrate the importance of this through the use of context filters.  The figure below describes the order in which actions happen within Tableau
Avatar
Thu 17 Oct 2024 | Dan Booth
My Journey to The Data School
Having just completed my first week at The Data School I thought now would be a good time to reflect on the journey of creating my initial application dashboard.  I first learnt of The Data School during a data science careers day while I was at university
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab