Attached is a workbook containing sales transactions for a retail store for the first 5 months of the year. On sheet Revenue_cost_profit you will see that in May revenues dropped significantly along with costs, yet profits remained consistent with previous months due to a rise in gross margin.
I'd like some help investigating the hike in the gross margins.
e.g. which customers, products, pricing type etc. is responsible for the increase.
More over I'm interested to see which visualizations people come up with to demonstrate their findings.
Also, if anyone discovers and other obvious trends or issues with the data I'm also interested.
Look forward to your feedback.