How This Workflow Works
This workflow merges historical Olympic event results with athlete demographic data to analyze age-related insights and identify athletes with birthdays matching the current date. It demonstrates how to calculate athlete ages at the time of competition, group athletes into age ranges, and highlight those celebrating birthdays today.
Key Features:
- Calculate athletes' ages at the time of Olympic participation
- Group and visualize athletes by age categories
- Identify athletes with birthdays matching today's date
- Present results in clear visual and tabular formats
Step-by-step:
1. Merge Athlete and Event Data:
The workflow combines Olympic event results with athlete demographic information by matching unique athlete identifiers. This creates a unified dataset that links each athlete's performance with their date of birth and other personal details.
2. Calculate Athlete Age at Event:
For each athlete-event record, the workflow computes the athlete's age at the start of the Olympic Games in which they competed. This involves converting the date columns into type Date, so that the Date&Time-related functionalities of KNIME can be leveraged. Then, the difference between the event date and the athlete's date of birth is calculated.
3. Group Athletes into Age Bins and Visualize:
The calculated ages are grouped into defined age bins to facilitate analysis of age distribution among participants. The workflow then visualizes these groupings in a bar chart, making it easy to see which age ranges are most commonly represented.
4. Identify and Display Today's Birthdays:
The workflow checks for athletes whose birthdays fall on the current date. This includes extracting the relevant date parts and then filtering the dataset accordingly. It presents the list of these athletes in a table view for easy reference.