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...
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 –...
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...
Understanding the Multi-Field and Multi-Row Formula Tools in Alteryx
Introduction Data preparation often involves repetitive tasks like applying formulas across multiple fields or analysing relationships between records. Alteryx offers two versatile tools, Multi-Field Formula and Multi-Row Formula, to simplify these processes. This...
