Icon

JKISeason3-20_​Creating a Report on Movies

Creating a Report on Movies

Challenge 20

Level: Medium

Description: For this challenge, you will leverage KNIME’s reporting capabilities to create a neat PDF document containing summaries and visual analyses of a movie dataset. Movies from each decade should be analyzed separately, one decade per page.

Within each decade:
(1) what average budget was spent per genre?
(2) what was the average revenue per genre?
(3) what were the main features of its top 5 movies?

Do your best to enhance the report visualization (e.g., use format managers, colors, and head/footer). Hint: Use the KNIME Reporting extension to solve this challenge.

Author: Armin Rudd

URL: Dataset https://api.hub.knime.com/repository/Users/alinebessa/Just%20KNIME%20It!%20Season%203%20-%20Datasets/Challenge%2020%20-%20Dataset/TMDB_sample.csv:data?version=current-state

TMDB_sample.csvdecadegenres0123456Node 21Node 22Node 23Node 25decadeNode 27Node 44Node 45Node 47CSV Reader String Manipulation Cell Splitter Column Renamer Column Renamer Column Renamer Column Renamer Column Renamer Column Renamer Column Renamer Concatenate Row Filter Column Filter String Manipulation Value Counter Table Row toVariable Loop Start Report TemplateCreator Report Loop End Report Report PDF Writer TMDB_sample.csvdecadegenres0123456Node 21Node 22Node 23Node 25decadeNode 27Node 44Node 45Node 47CSV Reader String Manipulation Cell Splitter Column Renamer Column Renamer Column Renamer Column Renamer Column Renamer Column Renamer Column Renamer Concatenate Row Filter Column Filter String Manipulation Value Counter Table Row toVariable Loop Start Report TemplateCreator Report Loop End Report Report PDF Writer

Nodes

Extensions

Links