Icon

SAP x KNIME Global Sales Exercise

SAP x KNIME -Global Games Exercise

Scenario:

We are a research company and we are tasked to analyze the Sales Reports of all gaming companies from different regions. Majority of the regions use the same system and format of preparing the report, however, one region is still using an old system making the output different from the others. Our task is to merge the data from that one region, clean up the data and create a star rating system.


Step-by-Step:

  1. Import files to KNIME Workflow (Excel Reader and List Files)

  2. Join all gaming reports from LA. (Table Row Variable Loop Start and Loop End)

  3. Fix Year Column in Global Sales Report, delete suffix ".0" (String Manipulation)

  4. Merge joint report to Global Sales Report - Only pick up columns LA_Sales and Owner column (Joiner) - Tip: Use column ID and inner joiner.

  5. Resort the columns, put LA Sales besides other Regions. (Column Resorter)

  6. Create star rating using this matrix: (Rule Engine)

    1. 0-20 = 1 Star

    2. 20-40 = 2 Stars

    3. 40-60 = 3 Stars

    4. 60-80 = 4 Stars

    5. 80-100 = 5 Stars

      Tip: $Critic_Score$ > = 0 AND $Critic_Score$ <= 20 => "1 Star"

  7. Fill in Missing Values with "UnRated" (Missing Values)

  8. Add LA Sales Column to Global Sales; Add LA_Sales to Other_Sales; Add JP_Sales to Other_Sales; (Math Formula)

  9. Remove LA and JP Sales Column (Column Filter)

  10. Create a pivot using Platforms and get the summation for All Regions - NA-EU-Other-Global (GroupBy) Tip: Create an alternative path

  11. Write the report with 2 Sheets

    1. Output from number 9 is sheet 1

    2. Output from number 10 is sheet 2

Nodes for the Exercise:

Global Sales Report
Excel Reader
1
List Files/Folders
2
Table Row to Variable Loop Start
Consolidated LA Report
Loop End
3
String Manipulation
4
Joiner
7
Missing Value
5
Column Resorter
6
Rule Engine
11
Excel Writer
Add LA to Global
Math Formula
9
Column Filter
10
GroupBy
11
Excel Writer
Latin America Report
Excel Reader
Add LA and JP to Other
Math Formula
Webpage Retriever

Nodes

Extensions

Links