0 ×

01_​Swiss_​Actuarial_​Example

Workflow

Interactive Exploration with Histogram (Interactive) nodes and Interactive Table node for hilighting Dynamic Report Generation with Quickforms using age as parameter Example works interactively via the KNIME GUI but also via the KNIME Web portal. data tables provided by www.mortality.org. The data in the Human Mortality Database (HMD) are provided free of charge to all individuals who request access to the database. This metanode uses quickforms to select theage parameter value.To configure the metanode, right click it. You will be shown a customizedconfiguration window generated by thequickform nodes within the metanode.This configuration step is also available viathe KNIME Web Portal for web end users. Actuarial Tables: Creation, Exploration, Dynamic Report GenerationThe example workflow, named “Swiss Actuarial Example”, implements two tasks:- An interactive exploration of the mortality counts by age and gender for the three year ranges;- A report that selects a given age value, displays the mortality rate evolution over time (1876-2009) for the selected age, and shows the actuarial figures for all ages over the most recent How to open the reportIn order to see the report execute the entire workflow and then click "Open the report" button in the toolbar. DeathsCounts per yearPopulationCounts per yeardeathsand populationred = femaleblue = malegreen = totalDeathsPopulationEvolution of mortality rateover timefor a given agejoinimage andselected ageyear range1876-19001900-19501950-20091876 - 1900vs. rest1900 - 1950 vs.1950 - 20091876-1900sum(# deaths)1900-1950sum(#deaths)1950-2009sum(#deaths)1950-2009actuarial tablesage vs. genderactuarial figuresbygender, age, year range Metanode Metanode Joiner Color Manager File Reader File Reader Line Chart(JFreeChart) Actuarial Selection Image To Table Data to Report Interactive Table Joiner Numeric Binner Row Splitter Row Splitter Histogram(interactive) Histogram(interactive) Histogram(interactive) Row Filter Data to Report Pivoting Actuarial Calculationyear_range ActuarialFigures M/F Interactive Exploration with Histogram (Interactive) nodes and Interactive Table node for hilighting Dynamic Report Generation with Quickforms using age as parameter Example works interactively via the KNIME GUI but also via the KNIME Web portal. data tables provided by www.mortality.org. The data in the Human Mortality Database (HMD) are provided free of charge to all individuals who request access to the database. This metanode uses quickforms to select theage parameter value.To configure the metanode, right click it. You will be shown a customizedconfiguration window generated by thequickform nodes within the metanode.This configuration step is also available viathe KNIME Web Portal for web end users. Actuarial Tables: Creation, Exploration, Dynamic Report GenerationThe example workflow, named “Swiss Actuarial Example”, implements two tasks:- An interactive exploration of the mortality counts by age and gender for the three year ranges;- A report that selects a given age value, displays the mortality rate evolution over time (1876-2009) for the selected age, and shows the actuarial figures for all ages over the most recent How to open the reportIn order to see the report execute the entire workflow and then click "Open the report" button in the toolbar. DeathsCounts per yearPopulationCounts per yeardeathsand populationred = femaleblue = malegreen = totalDeathsPopulationEvolution of mortality rateover timefor a given agejoinimage andselected ageyear range1876-19001900-19501950-20091876 - 1900vs. rest1900 - 1950 vs.1950 - 20091876-1900sum(# deaths)1900-1950sum(#deaths)1950-2009sum(#deaths)1950-2009actuarial tablesage vs. genderactuarial figuresbygender, age, year range Metanode Metanode Joiner Color Manager File Reader File Reader Line Chart(JFreeChart) Actuarial Selection Image To Table Data to Report Interactive Table Joiner Numeric Binner Row Splitter Row Splitter Histogram(interactive) Histogram(interactive) Histogram(interactive) Row Filter Data to Report Pivoting Actuarial Calculationyear_range ActuarialFigures M/F

Download

Get this workflow from the following link: Download

Nodes

01_​Swiss_​Actuarial_​Example consists of the following 54 nodes(s):

Plugins

01_​Swiss_​Actuarial_​Example contains nodes provided by the following 6 plugin(s):