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:
Import files to KNIME Workflow (Excel Reader and List Files)
Join all gaming reports from LA. (Table Row Variable Loop Start and Loop End)
Fix Year Column in Global Sales Report, delete suffix ".0" (String Manipulation)
Merge joint report to Global Sales Report - Only pick up columns LA_Sales and Owner column (Joiner) - Tip: Use column ID and inner joiner.
Resort the columns, put LA Sales besides other Regions. (Column Resorter)
Create star rating using this matrix: (Rule Engine)
0-20 = 1 Star
20-40 = 2 Stars
40-60 = 3 Stars
60-80 = 4 Stars
80-100 = 5 Stars
Tip: $Critic_Score$ > = 0 AND $Critic_Score$ <= 20 => "1 Star"
Fill in Missing Values with "UnRated" (Missing Values)
Add LA Sales Column to Global Sales; Add LA_Sales to Other_Sales; Add JP_Sales to Other_Sales; (Math Formula)
Remove LA and JP Sales Column (Column Filter)
Create a pivot using Platforms and get the summation for All Regions - NA-EU-Other-Global (GroupBy) Tip: Create an alternative path
Write the report with 2 Sheets
Output from number 9 is sheet 1
Output from number 10 is sheet 2