In the previous segment, you performed profitability analysis as well as identified the most profitable customers. In this segment, you will be introduced to the final problem statement. Let’s watch the upcoming video and learn more about this.
The problem statement, the required columns and the required tables introduced in this video can be summarised as follows:
Problem statement: Extract the required details of the customers who have not placed an order yet.
Expected columns: The columns that are required as the output are as follows:
- ‘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.
Tables: The tables that are required for solving this problem are as follows:
- ‘cust_dimen’
- ‘market_fact_full’