Icon

Data Visualizations - SPLIT

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 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 7: Creating Booking Cost Categories

Lab 8: Normalizing Ticket Scans and Downloads

Lab 9: Deriving Show Timings and Day Segments

Read membership.csv
CSV Reader
Categorize a User intoMembership Category
Rule Engine
Convert string booking_datetimeto date time
String to Date&Time
Remove any duplicatebookings
Duplicate Row Filter
Readbooking.csv
CSV Reader
Read payment.csv
CSV Reader
Join with userfor User Info
Joiner
Convert transaction_datetime to KNIME Date/Time
String to Date&Time
Readuser.csv
CSV Reader
Remove Userswith nophone & email
Row Filter
Adds descriptive gateway information
Joiner
Report Template Creator
Ensures only successful transactions contribute to revenue calculations
Row Filter
Report PDF Writer
Readpaymentgateway.csv
CSV Reader
keep only paymentslinked to valid bookings
Joiner
Sort bytotal_cost
Sorter
Convert string booking_datetimeto date time
String to Date&Time
Remove any duplicatebookings
Duplicate Row Filter
Readbooking.csv
CSV Reader
Extract month& year
Date&Time Part Extractor
Calculate 1. Number of bookings2. Total Revenue3. Average Ticket priceper Genres
GroupBy
Rename Derived columns
Column Renamer
Join show tablefor connectingmovie table
Joiner
Calculate1. Monthly Revenue2. Average Amount/ Transactions3. Successful transactions
GroupBy
Join movie table
Joiner
Read ticket.csv
CSV Reader
Re-organize Columns
Column Resorter
Derive scan_status based on download and scan information
Rule Engine
Calculate1. Number of bookings2. Total Revenue3. Average Ticket Price4. Average Movie Ratingper Movie
GroupBy
show.csv
CSV Reader
Rename Derived columns
Column Renamer
Fill Missing valuesas Mean
Missing Value
Rename Columns
Column Renamer
Read movie.csv
CSV Reader
Convert show_datetimeto KNIME Date/Time
String to Date&Time
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
RenameDerived Columns
Column Renamer
Read booking.csv
CSV Reader
Report Template Creator
Categorize Booking Category
Expression
Dashboard 2
Component
Report PDF Writer
Sort tickets by scan status
Sorter
Remove Duplicate Movies
Duplicate Row Filter
Read ticket.csv
CSV Reader
Readbooking.csv
CSV Reader
Extract Hour of the Day
Date&Time Part Extractor
Categorize ShowSegment
Rule Engine
Convert stringtodate time
String to Date&Time
Remove any duplicatebookings
Duplicate Row Filter
Convert todate and time
String to Date&Time
GroupBy

Nodes

Extensions

Links