Balanced Tree Clothing Company prides themselves on providing an optimised range of clothing and lifestyle wear for the modern adventurer!
Danny, the CEO of this trendy fashion company has asked you to assist the team’s merchandising teams analyze their sales performance and generate a basic financial report to share with the wider business.
balanced_tree.product_details includes all information about the entire range that Balanced Clothing sells in their store.
balanced_tree.sales contains product level information for all the transactions made for Balanced Tree including quantity, price, percentage discount, member status, a transaction ID and also the transaction timestamp.
The following questions can be considered key business questions and metrics that the Balanced Tree team requires for their monthly reports.
High Level Sales Analysis
Transaction Analysis