Troy Stephenson
Troy holds degrees in Science, IT, and Education. These have equipped him with a multidisciplinary foundation combining analytical thinking, problem-solving, and technical proficiency. During his graduate studies at CSIRO, where he analysed genetic sequence data and gene expression profiles as part of a broader research project, he developed a deep interest in uncovering insights through data.
After several years as a STEM educator, Troy has transitioned back to being data-focused, bringing a unique perspective shaped by his teaching experience and ability to convey complex ideas effectively. His skills cover the entire data lifecycle, from data cleaning and analysis to creating effective visualisations that support decision-making.
In his free time, Troy enjoys trail running and staying active, relishing the chance to clear his mind and explore the outdoors.
Creating Iterative Macros in Alteryx
Introduction This tutorial is a continuation on the previous posts on the various types of macros in Alteryx, as well as, creating standard and batch macros in Alteryx. This time we will move on to iterative macros. To recap, an iterative macro allows you to loop...
Creating Batch Macros in Alteryx
Introduction This tutorial is a continuation on the previous posts on the various types of macros in Alteryx, as well as, creating standard macros in Alteryx. This time we will move on to batch macros. To recap, a batch macro in Alteryx allows you to run a workflow...
Creating Standard Macros in Alteryx
Introduction This tutorial is a continuation on the previous post on the three types of macros in Alteryx. Here we will focus on the first type - the standard macro. To recap, a standard macro in Alteryx allows you to encapsulate workflows into reusable components to...
Dashboard Week: Day 5 – Pixar Films
On Day 5, the dataset provided was a comprehensive view of Pixar films, covering box office performance, critical and audience reception, awards, genres, and key contributors. This dataset contained six tables: Genre Table – Categorises each Pixar film by genre,...
Dashboard Week: Day 4 – National Institute on Alcohol Abuse and Alcoholism
On Day 4, the latest consumption surveillance report published by The National Institute on Alcohol Abuse and Alcoholism (NIAAA) was used as the data source. This was a single table containing the following 14 fields: Year: 4-digit calendar year. Geographic ID code:...
Dashboard Week: Day 3 – The Met. Museum of Art Collection API
On Day 3, the Metropolitan Museum of Art Collection API was used as the source of data. The API contains four endpoints: Objects: A listing of all valid Object IDs available for access. Object: A record for an object, containing all open access data about that object,...
Dashboard Week: Day 2 – Women’s Football
On Day 2, the dataset was the English Women's Football (EWF) Database. The database contains three tables: ewf_matches contains all matches that have been played and has one observation per match per season. ewf_appearances contains all appearances by a team and has...
Dashboard Week: Day 1 – Mountaineering Expeditions
On Day 1, the provided dataset focused on mountaineering expeditions. It contained four tables: Expeditions Table - Details about each mountaineering expedition, including routes, success rates, hired personnel, accidents, and logistics. Members Table – Information on...
An Introduction to Macros in Alteryx
What is a Macro in Alteryx? When learning to use Alteryx, you may come across tasks that feel highly repetitive, using the same tools, in the same order with only slight modifications. This is where learning to use macros becomes beneficial. A macro in Alteryx is a...
Categorising Geographic Data with Alteryx
Introduction Latitude and longitude values are essential for mapping in a data visualisation. However, they are less useful for other visualisations, such as bar charts where categorical data is used. Categorising geographic data can be tedious, but Alteryx can...