Icon

01 Data Export and Reporting - Solution

01 Data Export and Reporting - Exercise (Solution)

This workflow shows a solution to a hands-on exercise in the L2-DW Introduction to KNIME Analytics Platform for Data Wranglers - Advanced course

Task 2: Create a BIRT Report1. Execute the provided workflow. It aggregates and visualizes population and travel riskinformation on the different continents. 2. Send the output of the top branch, the pivot table, to BIRT for use in a report3. Send the bar chart to BIRT4. In the BIRT Report editor, use a grid to layout the following elements:- A report title- A pivot table- A bar chart Task 1: Write Data to a FileRead the JoinedCountryTable.table file by executing the Table Reader node. This table containsinformation about the demographics, geolocation, and travel risks in the different countries/territories in 2020.1. Filter the data to the countries/territories in the travel risk category 1 (Exercise normalprecautions)2. Filter these data to countries/territories with a maximum one million inhabitants in 20193. Write the filtered data into a “SmallSafeCountries.csv” file in the data folder. Overwrite the file if italready exists. Travel risk category 1Population>= 1 millionNumber of countriesby continent andincreasing/decreasingpopulationto 0Show distributionof travel riskcategories withincontinentsNumber of countriesby continent andtravel risk categorypopulation tabletravel risk graphWriteSmallSafeCountries.csvJoinedCountryData.table Row Filter Row Filter Pivoting Missing Value Bar Chart Pivoting Data to Report Image to Report CSV Writer Table Reader Task 2: Create a BIRT Report1. Execute the provided workflow. It aggregates and visualizes population and travel riskinformation on the different continents. 2. Send the output of the top branch, the pivot table, to BIRT for use in a report3. Send the bar chart to BIRT4. In the BIRT Report editor, use a grid to layout the following elements:- A report title- A pivot table- A bar chart Task 1: Write Data to a FileRead the JoinedCountryTable.table file by executing the Table Reader node. This table containsinformation about the demographics, geolocation, and travel risks in the different countries/territories in 2020.1. Filter the data to the countries/territories in the travel risk category 1 (Exercise normalprecautions)2. Filter these data to countries/territories with a maximum one million inhabitants in 20193. Write the filtered data into a “SmallSafeCountries.csv” file in the data folder. Overwrite the file if italready exists. Travel risk category 1Population>= 1 millionNumber of countriesby continent andincreasing/decreasingpopulationto 0Show distributionof travel riskcategories withincontinentsNumber of countriesby continent andtravel risk categorypopulation tabletravel risk graphWriteSmallSafeCountries.csvJoinedCountryData.table Row Filter Row Filter Pivoting Missing Value Bar Chart Pivoting Data to Report Image to Report CSV Writer Table Reader

Nodes

Extensions

Links