Icon

Super Store Sales _​ End to End BI Project

Location Table Create Customer Table Create Product Table Create Sales Table Create Product Table Create Fact Table Historical Create Fact Table 2017 Create Customer Table Create Location Table SourcenodeDimensionTable (Location)DimensionTable (Customer)Unit PriceCOGSSalesAfter DiscountCalculateCOGS per UnitDimensionTable (Product)Node 15Node 17Split Q1, Q2 &Q3, Q4SplitQ3 & Q4Node 21SplitQ1 & Q2Node 23Node 24Node 25Node 23DimensionTable (Product)Node 23Fact Table (2017|Q1)Fact Table (2017|Q2)Fact Table (2017|Q3)Fact Table (2017|Q4)201520172016Node 38Node 39CustomerTerritoriesProductsProducts SubcategoriesProducts categoriesNode 47Node 48Node 51Node 52Node 53Node 54DimensionTable (Product) Excel Reader GroupBy GroupBy Column Rename Date&TimeDifference Math Formula Math Formula Math Formula Column Rename GroupBy Math Formula Column Filter Column Filter Extract Date&TimeFields (deprecated) Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter MISSING GoogleSheets Writer MISSING GoogleAuthentication MISSING GoogleSheets Connection MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer CSV Reader CSV Reader CSV Reader Concatenate Concatenate CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader DuplicateRow Filter Rule-basedRow Splitter DuplicateRow Filter DuplicateRow Filter Concatenate DuplicateRow Filter MISSING GoogleSheets Writer Location Table Create Customer Table Create Product Table Create Sales Table Create Product Table Create Fact Table Historical Create Fact Table 2017 Create Customer Table Create Location Table SourcenodeDimensionTable (Location)DimensionTable (Customer)Unit PriceCOGSSalesAfter DiscountCalculateCOGS per UnitDimensionTable (Product)Node 15Node 17Split Q1, Q2 &Q3, Q4SplitQ3 & Q4Node 21SplitQ1 & Q2Node 23Node 24Node 25Node 23DimensionTable (Product)Node 23Fact Table (2017|Q1)Fact Table (2017|Q2)Fact Table (2017|Q3)Fact Table (2017|Q4)201520172016Node 38Node 39CustomerTerritoriesProductsProducts SubcategoriesProducts categoriesNode 47Node 48Node 51Node 52Node 53Node 54DimensionTable (Product)Excel Reader GroupBy GroupBy Column Rename Date&TimeDifference Math Formula Math Formula Math Formula Column Rename GroupBy Math Formula Column Filter Column Filter Extract Date&TimeFields (deprecated) Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter Rule-basedRow Splitter MISSING GoogleSheets Writer MISSING GoogleAuthentication MISSING GoogleSheets Connection MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer MISSING GoogleSheets Writer CSV Reader CSV Reader CSV Reader Concatenate Concatenate CSV Reader CSV Reader CSV Reader CSV Reader CSV Reader DuplicateRow Filter Rule-basedRow Splitter DuplicateRow Filter DuplicateRow Filter Concatenate DuplicateRow Filter MISSING GoogleSheets Writer

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: PhyoMinThant(MC)
Created at: 2021-05-15
On NodePit since: 2021-05-16
Last update: 2024-04-27
Created with KNIME version: v4.4.0

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

Try NodePit Runner!