Icon

Data Aggregation Labs Solution

Lab 1: Summarizing Booking Revenue per User with Row Aggregator

Use Row Aggregator to compute running totals and averages for bookings per user, after joining Booking and User tables.

Lab 3: Genre-Based Booking Counts with GroupBy

Use GroupBy to tally bookings and average costs by movie genre, after enriching bookings with movie details.

Lab 7: Reshaping Food Sales by Item with Pivot

Use Pivot to transform food order items into a wide format, showing sales quantities per size by item.

Lab 2: Conditional Running Totals for Points Transactions with Row Aggregator

Use Row Aggregator to compute conditional running totals of points earned per user, factoring in transaction types after joining Pointstransaction and Membership.

Lab 4: Time-Windowed Revenue by Gateway with GroupBy

Use GroupBy with date bucketing to summarize payment revenues by gateway and month, post-joining Payment and Booking.

Lab 8: Multi-Level Pivot for Review Ratings by Genre and Role with Pivot

Use Pivot to create a cross-tab of average ratings by movie genre (rows) and cast role (columns), after aggregating reviews with Movie and Moviecast.

Lab 5: Time-Series for Scanned Tickets

Use GroupBy to normalize aggregated ticket scan data for trend querying.

Lab 9: Multi-Dimensional GroupBy for Seat Utilization by Screen and Show Time with GroupBy

Use GroupBy to compute seat occupancy rates by screen and time-of-day buckets, after joining Showseat, Show, and Screen.

Lab 6: Statistical GroupBy for Review Sentiment by Genre with GroupBy

Use GroupBy to calculate descriptive statistics on movie ratings by genre, enriched with Review and Movie data.

Read showseat.csv
CSV Reader
Convert string booking_datetimeto date time
String to Date&Time
Remove any duplicatebookings
Duplicate Row Filter
Read seat.csv
CSV Reader
Readbooking.csv
CSV Reader
Join with userfor User Info
Joiner
Bar Chart
Readuser.csv
CSV Reader
Remove Userswith nophone & email
Row Filter
Convert string booking_datetimeto date time
String to Date&Time
Remove any duplicatebookings
Duplicate Row Filter
Readbooking.csv
CSV Reader
Calculate 1. Number of bookings2. Total Revenue3. Average Ticket priceper Genres
GroupBy
Rename Derived columns
Column Renamer
Join show tablefor connectingmovie table
Joiner
Join movie table
Joiner
Read foodorderitem.csv
CSV Reader
Calculate1. Number of bookings2. Total Revenue3. Average Ticket Price4. Average Movie Ratingper Movie
GroupBy
Rename Derived columns
Column Renamer
Calculate TotalSpends bya User
Row Aggregator
Read pointstransaction.csv
CSV Reader
Convert to Date&Time
String to Date&Time
Convert Rating Data Type
String to Number
Remove duplicatemovie
Duplicate Row Filter
Renamecolumns
Column Renamer
Enriches reviews with movie genre
Joiner
Extracthour
Date&Time Part Extractor
Associates each review with its related cast
Joiner
string todate time
String to Date&Time
Compute occupied
Expression
Remove Duplicate Movies
Duplicate Row Filter
inner joinresult + Screens on screen_id
Joiner
Calculate Statistics
GroupBy
Categorizes each showtime to morning, afternoon, evening
Expression
average rating across combined dimensions
GroupBy
Fill Missing Ratingas Mean
Missing Value
Creates a cross-tab structure summarizing average review ratings across roles and genres
Pivot
Joiner
Remove duplicatemovie
Duplicate Row Filter
Read movie.csv
CSV Reader
Calculate SentimentScore
Expression
Read ticket.csv
CSV Reader
Creates a binary indicator for whether each ticket has been scanned
Expression
string todate time
String to Date&Time
Extractmonth &year
Date&Time Part Extractor
Convert stringtodate time
String to Date&Time
Convert Rating to Decimal
String to Number
Remove any duplicatebookings
Duplicate Row Filter
Read show.csv
CSV Reader
Renamecolumns
Column Renamer
Summarizes total scans and total tickets per delivery method and month
GroupBy
Rename derivedcolumns
Column Renamer
Read review.csv
CSV Reader
Bar Chart
string todate time
String to Date&Time
string todate time
String to Date&Time
CSV Writer
Bar Chart
Excel Writer
Read payment.csv
CSV Reader
Convert transaction_datetime to KNIME Date/Time
String to Date&Time
Report PDF Writer
Component
Adds descriptive gateway information
Joiner
CSV Writer
Ensures only successful transactions contribute to revenue calculations
Row Filter
Report Template Creator
Readpaymentgateway.csv
CSV Reader
keep only paymentslinked to valid bookings
Joiner
Extract month& year
Date&Time Part Extractor
Calculate1. Monthly Revenue2. Average Amount/ Transactions3. Successful transactions
GroupBy
show.csv
CSV Reader
Fill Missing valuesas Mean
Missing Value
Rename Columns
Column Renamer
Read movie.csv
CSV Reader
Convert rate to decimal
String to Number
Remove MissingValues
Missing Value
Read fooditem.csv
CSV Reader
Read fooditemsize.csv
CSV Reader
Based on the FooditemPivot the Sizesand get the quantity of the orders
Pivot
RenameDerived Columns
Column Renamer
Join foodorderitem& fooditem on item_idto get the Item data
Joiner
Join the orders & items with the size tableon size_id
Joiner
Read review.csv
CSV Reader
Convert Rating to Decimal
String to Number
Read moviecast.csv
CSV Reader
Missing Value
RenameDerived Columns
Column Renamer
Read movie.csv
CSV Reader
Fill Missing Ratingas Mean
Missing Value
Read screen.csv
CSV Reader
Readbooking.csv
CSV Reader
inner join result + Seats on seat_id
Joiner
Aggregates occupancy at a two-level hierarchy
GroupBy
Pivot
Split Rows basedon either PointsPurchased or Earned
Row Splitter
Row Aggregator
Convert todate and time
String to Date&Time
inner join Showseats + Showson show_id
Joiner
Row Aggregator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: adhik
Created at: 2025-10-28
On NodePit since: 2026-06-09
Last update: 2026-06-09
Created with KNIME version: v5.8.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!