Icon

Writing to a Database - 6 KPIs for any CEO

<p>This workflow saves the data from the 6 KPIs into a SQLite database.</p><p>Each KPI is computed in its dedicated workflow, which captures the computation of the KPI for all the available years.</p><p><strong>HOW TO USE</strong>:</p><ol><li><p><strong>Select a year </strong>in which you want to compute the KPIs</p></li><li><p>Run the workflow executors, so that they <strong>compute the KPIs</strong>.</p></li><li><p>Save the year on the database. So if it's the first year (no tables are present) use<strong> DB writer </strong>to create the tables. If instead you want to append the tables to already existing ones (i.e., you are adding years) use <strong>DB insert</strong> nodes.</p></li></ol><p>This database will be used in another workflow (<strong>6 KPIs Data App</strong>) to interactively display all the data.</p><p></p><p>Please note that the DB is directly saved in the 6 KPIs Data App "data" subfolder.</p>

This workflow saves the data from the 6 KPIs into a SQLite database.

Each KPI is computed in its dedicated workflow, which captures the computation of the KPI for all the available years.

HOW TO USE:

  1. Select a year in which you want to compute the KPIs

  2. Run the workflow executors, so that they compute the KPIs.

  3. Save the year on the database. So if it's the first year (no tables are present) use DB writer to create the tables. If instead you want to append the tables to already existing ones (i.e., you are adding years) use DB insert nodes.

This database will be used in another workflow (6 KPIs Data App) to interactively display all the data.

Please note that the DB is directly saved in the 6 KPIs Data App "data" subfolder.

Nodes

Extensions

Links