Introduction
xyz.com is a B2B startup that sells various products not directly to end users but to other businesses/companies. As a data-driven company, every decision making at xyz.com is always based on data. Every quarter xyz.com will hold a townhall where all or division representatives will gather to review the company’s performance during the last quarter.
Data
Table will be used on project this time was as follows :.
Table orders_1 : Data contains sales transactions for the 1st quarter (Jan – Mar 2004)
Table Orders_2 : Data contains sales transactions for the 2nd quarter (Apr – Jun 2004)
Customer Table: Data contains customer profiles who register to become xyz.com customers
Task
Assume the current year is 2004,the manager of xyz.com wants to know :
How sales growth at this time ?
Is the amount of customers xyz.com has been increased ?
And how many customers did transactions ?
What most of the products bought by customers ?
How many customers active transact?
Summary
Based on the data that we have obtained through SQL queries, we can conclude that :
xyz.com performance decreased significantly in the 2nd quarter, as seen from the value of sales and revenue which dropped by 20% and 24%.
The acquisition of new customers is also not very good, and slightly decreased compared to the previous quarter.
The interest of new customers to shop at xyz.com is still lacking, only about 56% have made transactions.
Products categories S18 and S24 contribute about 50% of total orders and 60% of total sales.
xyz.coms customer retention rate is also very low at only 24%.
