TheLook is a fictitious eCommerce clothing site developed by the Looker team. The dataset contains information about customers, products, orders, logistics, web events and digital marketing campaigns. Our job here is to answer business questions, gain insights and provide some recommendations to increase revenue.

• How much are we selling monthly?
• Is it high or low compared to last month?
• Who are our customers?
• What are we selling the most and the least?
• What are we making money on?
• The most canceled and returned brand & product categories.
• What marketing channel are we doing well on?
• We will provide promotions during Chinese New Year celebrations for female customers in China via email. Please provide data on how many customers we should promote each email!
• Provide a list of 10 customer ids with the largest total overall purchase. We will give a discount for campaign 3.3!

Dashboard | Medium article | Report file

Contact me Linkedin