In this session, you solved various business problems using SQL. You might encounter similar problems in your daily job role.
Profitability analysis: You performed a profitability analysis on the ‘market star’ schema by identifying sustainable/profitable product categories so that the growth team can capitalise on them and increase sales. You calculated the following metrics:
- Profits per product category
- Profits per product subcategory
- Average profit per order
- Average profit percentage per order
Profitable customers: You also identified the ten most profitable customers and extracted their details in the format given below.
Fraud detection: Finally, you found out the details of fraud customers after retrieving their data in the following columns:
- ‘cust_id’
- ‘cust_name’
- ‘city’
- ‘state’
- ‘customer_segment’
- A flag to indicate that there is another customer with the exact same name and city but a different customer ID.
You must have realised that there are various applications of SQL in the data analytics domain. Hence, it is important for you to have a strong understanding of both basic and advanced SQL concepts to derive useful insights.
You can find the script file used in the demonstrations throughout this session in the link provided below.