8weeksqlchallenge - Week 7

High Level Sales Analysis
The overview numbers of case study always need to be presented first. With first 3 questions of High Level Sales Analysis part, I believe that we already know the overall business picture of the Balance Tree team with 3 numbers of total sold products, total generated revenue, total discount amount.

Transaction Analysis
In this part , beside that overall number in first part, we go in the detail statistic of transaction. These numbers show us about the discount strategy generate the adequate result or we have to improve it.

Moreover , the differentiation between transactions for members vs non-members also give us a sight of the returning customer rate and attracting new customer rate. It depends on the purpose of this strategy, Danny wants to give discount program to attract new customers or appreciate the loyal customers.

Product Analysis
With this part, Case Study gives you a chance to understand customer behavior in regards to the Balanced Tree products and its segments. It supports for the future updates or improvements.

Beside that question relating to the products segmentation, we do the question about product penetration. Market or product penetration measures how much a product or service is used by customers in relation to the total potential market for that product or service. It's a way to see how many people are using your product compared to how many could potentially use it. Companies use market penetration to plan strategies for growing the number of customers using their product or service and increasing their market share.