Trea McElhone

Originally from Ireland, Trea is a Neuroscience graduate from the University of St Andrews, where during her studies she was introduced to data analysis and its powerful capacity to communicate information. Throughout her final year when she focused on researching neurodegenerative disease and potential therapeutics, she experienced firsthand the utility of data analysis as it took her research from masses of unclear and messy data to clear, succinct, and easily communicable insights.

Following this she sought out opportunities to further explore this field, dabbling in some python and R, and she was led to the Data School.

Trea spent her first and second placement at IAG Cargo, where she worked extensively with SQL in both Snowflake and Oracle to efficiently prepare, transform, and optimise large datasets. Leveraging Tableau alongside this, she tailored dynamic reports to varied business requirements, presenting intricate data in visually compelling formats.

For her third placement, Trea joined Cordavis, a biosimilars company, where she took on a range of Data & Analytics responsibilities. This included managing relationships with third-party vendors and collaborating with data architects and engineers to understand the end-to-end data acquisition and pipeline processes involved in setting up data analytics and warehousing for a growing company in the pharmaceutical industry. Her hands-on exposure to data pipelines encouraged an interest in pursuing data engineering, leading her to apply for the for the first cohort of the TIL Data Engineering School.

Since starting the TIL Data Engineering School, Trea has been working on developing her skills in building data pipelines, working with cloud platforms, and mastering tools like SQL, Python, and Airflow.

When not working with data, Trea enjoys more creative endeavours such as baking and anything vaguely crafty - from crochet to watercolours.

Certifications

Blog Posts

Avatar
Tue 28 Jan 2025 | Trea McElhone
Loading Data from Cloud Platforms into Snowflake: Part 2 - COPY commands
Following on from my last blog post, where we walked through how to create an external stage, in this post, we’ll cover how to use that external stage to copy data into a table within your Snowflake schema. Prerequisites for this walkthrough: 1
Avatar
Fri 17 Jan 2025 | Trea McElhone
Loading Data from Cloud Platforms into Snowflake: Part 1 - Stages
In our last blog we covered loading local data files into Snowflake via the GUI, in this blog we're going to get a little more advanced and look at how to bring in data from external cloud storage services, of which Snowflake supports three; Amazon S3, Microsoft Azure, and Google Cloud Storage
Avatar
Thu 16 Jan 2025 | Trea McElhone
Snowflake SQL School: Creating & Loading Tables
Snowflake is a cloud based data platform within which users can store, process, and analyse their data. Its SQL based interface for data querying is simple and easy to use, with a number of more commonly utilised functions also built into the graphical user interface (GUI)
Avatar
Mon 06 Jan 2025 | Trea McElhone
TabPy: Integrating Python with Tableau
TabPy (Tableau Python Server) is an extension with the Tableau Desktop program that allows you to integrate and execute python scripts directly within Tableau itself via calculated fields and table calculations
Avatar
Fri 02 Jun 2023 | Trea McElhone
Dashboard Week Day 4: Boy Band Data Base
For our final day of dashboard week we were tasked with creating a dashboard using the Internet Boy Band Data Base, with their data from here
Avatar
Thu 01 Jun 2023 | Trea McElhone
Dashboard Week Day 3 - NASA API
For our penultimate day of Dashboard week we were tasked using an API of our choice from the NASA site and using this to pull data to then use in either a Tableau Dashboard, Alteryx app, or PowerBI report
Avatar
Mon 29 May 2023 | Trea McElhone
#HowTo - Circular Calendar Chart - Part 2: Building in Tableau
Welcome to Part 2 of my #HowTo on how to build a circular calendar chart in Tableau - before following this blog, please make sure you are up to date with Part 1.
Avatar
Wed 31 May 2023 | Trea McElhone
Dashboard Week Day 2 - Power BI Recreation
For our second day of Dashboard week we were tasked with recreating a chosen dashboard from the list on this post - with one particular catch, we had to recreate it in PowerBI.
Avatar
Tue 23 May 2023 | Trea McElhone
#HowTo - Circular Calendar Chart - Part 1: Calculations
How to create a circular calendar chart - Part 1
Avatar
Tue 30 May 2023 | Trea McElhone
Dashboard Week Day 1: UK Crime Data
Dashboard week is upon us and for our first day with have been tasked with creating an Alteryx app to produce a data set that we can then feed into either a Tableau dashboard or a Power BI dashboard
Avatar
Thu 04 May 2023 | Trea McElhone
#HowTo - Create a Connected Dot Plot (Peas in a Pod)
In this #HowTo, I will be walking you through how to make a connected dot plot, also know as a peas in a pod chart, in Tableau Desktop - with this walkthrough demonstrating how they can can be used as a timeline.
Avatar
Wed 19 Apr 2023 | Trea McElhone
#HowTo - Jitter Plot
In this #HowTo, I will be walking you through how to make a simple Jitter Plot in Tableau Desktop - using the Superstore data set.
Avatar
Mon 17 Apr 2023 | Trea McElhone
#HowTo - Barcode Plots
In this #HowTo, I will be walking you through how to make a simple and straightforward Barcode Plot in Tableau Desktop - using the Superstore data set.
Avatar
Wed 29 Mar 2023 | Trea McElhone
#QuickTips - How to Find Your Calculated Fields Quickly
If you're like me, when using Tableau desktop, you may find yourself creating numerous calculated fields with titles that may not be concise or intuitive
Avatar
Tue 21 Mar 2023 | Trea McElhone
From Chaos to Coordination: My Week as Project Manager
Being a project manager for the first time can be a pretty daunting experience, which is exactly how I felt when I was tasked with being the first project manager in my cohort for our first internal client project
Avatar
Sat 04 Mar 2023 | Trea McElhone
#How To - Add Start & End Dots to Sparklines
Sparklines are a frequent component of dashboard KPIs as they provide a helpful bite-sized visualisation of a trend. The addition of start and end dots to the spark lines are a useful way to mark the most recent and least recent data points, as well as being a nice aesthetic feature
Avatar
Tue 07 Mar 2023 | Trea McElhone
#HowTo - Calculate a Moving Average in Tableau
In this #HowTo, I will be showing you how to create a moving average in Tableau Desktop, using the classic Sample-Superstore dataset and creating the moving average with sales data, so you can follow along if you wish.
Avatar
Thu 02 Mar 2023 | Trea McElhone
Key Tips for Dashboard Design
Your dashboard is essential for communicating important information and insights, although it's not always easy to design a dashboard that is both aesthetically appealing and effective at communication.
Avatar
Wed 01 Mar 2023 | Trea McElhone
Thinking Outside the Alteryx Canvas
When working with Alteryx and Tableau it can useful to plan out workflows and dashboards on paper and to force yourself to think outside the box, or in this case, the Alteryx canvas.
Avatar
Tue 21 Feb 2023 | Trea McElhone
Revamping my Application Viz
After one week of tableau training we were given our project wherein we were tasked with revisualising our original application viz. Which seemed fairly straightforward - although there was one slight caveat - we only had around 3 hours
Avatar
Fri 17 Feb 2023 | Trea McElhone
Exploring the DS Library - "An Infographic History of the World"
In our first week at the Data School Cohort 38 and myself were tasked with choosing a book The Data School UK library and either reading the first 50 words or skimming the first few pages of each chapter - and determine whether we would recommend it to others
Avatar
Fri 17 Feb 2023 | Trea McElhone
String Functions Simplified
Simplifying string functions in a quick cheat-sheet
Avatar
Fri 10 Feb 2023 | Trea McElhone
#HowTo - The Basics of Pivoting in Tableau Prep
How to use to pivot tool in tableau prep for columns to rows
Avatar
Tue 07 Feb 2023 | Trea McElhone
Things You Absolutely Do Not Need to Worry About for your First Day at the Data School
The first day of anything is almost always a little nerve-wracking, whether it’s your first day of school, your first day in a new country, or like me, your first day at the Data School.
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