Analyze Sales Data

<p><strong>Demo: From Excel to KNIME</strong></p><p>This workflow shows how to access Excel &amp; CSV files in KNIME, how to preprocess the data (concatenate data tables, check for duplicates, and perform a VLOOKUP), how to create a Pivot table, and how to visualize &amp; export the processed data.</p><p></p><p>The three datasets used in the workflow are:</p><ul><li><p><em>CRM1.xlsx:</em> Excel file with information about customers (e.g., Customer ID, Sales Unit, etc.)</p></li><li><p><em>CRM2.csv:</em> CSV file containing customer information from another CRM</p></li><li><p><em>Transactions.csv:</em> Information about transactions from an ERP system (e.g., Customer ID, Product ID, Price, etc.)</p></li></ul>