If you need to categorize data, you can use the Grow Tagging Transform to create a new column, that gets filled based on critera you select. You can use combinations of AND OR logic to create accurate tags.
For example if you have 3 sales teams, and want to group by them, but the sales teams are not in your Salesforce info.
You could create a tag set, name the column 'Sales Team' then create 3 tags.
Under the 'Red Team' tag, you would set Salesperson = Josh OR Salesperson = Jake OR Salesperson = Jonny.
This would tag any sale made by one of those 3 sales people as 'Red Team', which you could then use to group and filter by.