Icon

JKISeason3-20

Description: For this challenge, you will leverage KNIME’s reporting capabilities to create aneat PDF document containing summaries and visual analyses of a movie dataset. Moviesfrom 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. OK to generate $$ adjusted budget butnot Revenue -- unless there's table ofrevenue / year Node 1Node 6Node 7Node 20Genre ListDecadeNode 1552024 Inflation adjusted budget $$Node 164Node 167Node 168Node 169Node 170Node 171Concatenate thereportsNode 511Node 522Node 540Node 541 CSV Reader String to Date&Time Extract Date&TimeFields Joiner Cell Splitter Data Viz Math Formula Group Loop Start Math Formula Report TemplateCreator 2024$ adjustedbudget Cell Splitter Column Renamer Column Filter Counter Generation Report Loop End Report PDF Writer Round Double Cell SplitterBy Position Column Renamer Description: For this challenge, you will leverage KNIME’s reporting capabilities to create aneat PDF document containing summaries and visual analyses of a movie dataset. Moviesfrom 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. OK to generate $$ adjusted budget butnot Revenue -- unless there's table ofrevenue / year Node 1Node 6Node 7Node 20Genre ListDecadeNode 1552024 Inflation adjusted budget $$Node 164Node 167Node 168Node 169Node 170Node 171Concatenate thereportsNode 511Node 522Node 540Node 541CSV Reader String to Date&Time Extract Date&TimeFields Joiner Cell Splitter Data Viz Math Formula Group Loop Start Math Formula Report TemplateCreator 2024$ adjustedbudget Cell Splitter Column Renamer Column Filter Counter Generation Report Loop End Report PDF Writer Round Double Cell SplitterBy Position Column Renamer

Nodes

Extensions

Links