case study
Budget: £10 – £20 GBP
- I want to highlight and show the top 5 highest total sale in 3 individual city sorted by User ID
- Top 10% highest sale in all city combines sorted by User ID and Country
- Lowest sale in individual city
- Total amount of voucher used in each city
- Biggest number of order regardless of average order amount
On finding this, I want a pivot table to add on presentation.
Idea is, it will then create a presentation including:
- Highlight any facts or finding I have looked into
- Any key problems
- Possible solutions/ changes needed
- Proposal/ recommendation
- Ask for any extra data that would have helped in more insight.
- Top 10% highest sale in all city combines sorted by User ID and Country
- Lowest sale in individual city
- Total amount of voucher used in each city
- Biggest number of order regardless of average order amount
On finding this, I want a pivot table to add on presentation.
Idea is, it will then create a presentation including:
- Highlight any facts or finding I have looked into
- Any key problems
- Possible solutions/ changes needed
- Proposal/ recommendation
- Ask for any extra data that would have helped in more insight.