Icon

01_​Swiss_​Actuarial_​Example

Actuarial Tables: Creation, Exploration, and Dynamic Report Generation
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

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2019-07-12
Last update: 2024-04-18
Created with KNIME version: v3.1.3
Tags: Actuarial tablesMortality tablesLife expectancyDynamic Report GenerationInsurance

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!