Icon

4. Creating a Dashboard

<p>Here, I create a dashboard on KNIME.</p><p></p><p>To begin the workflow, I am reading from the data table cleaned in a previous workflow with the <strong>Table Reader</strong> node. The <strong>Group Loop Start</strong> and <strong>Loop End</strong> nodes are then used to run a loop through the countries to see how many companies were founded per country.</p><p></p><p>For context, a loop is a repetitive task that runs automatically, which is more efficient than doing it manually one by one, especially with large data sets.</p><p></p><p><em>Note that the end results can simply be achieved with the Row Aggregator and Row Filter nodes, the Loop nodes used are simply to see how dataset reacts (countries are looped in alphabetical order).</em></p><p></p><p>I then created a donut chart using the <strong>Pie Chart </strong>node that shows the number of large companies each countries has (countries with fewer companies have been aggregated as 'Others'). As I am from Singapore, I have also created a list using the <strong>Table</strong> <strong>View </strong>node which tabulates a list of large Singaporean companies.</p><p></p><p>Two other analytics methods are created below to produce visualisations using a <strong>Heatmap </strong>node and <strong>Bar Chart</strong> node for a dashboard, which are condensed into one <strong>component</strong>.</p><p></p><p>Finally, I include a <strong>Text Output Widget</strong> within the component to create the heading for the dashboard.</p>

URL: Kaggle dataset used https://www.kaggle.com/datasets/soumyodippal000/top-2000-companies-financial-data-2024-dataset

Nodes

Extensions

Links