Back

---

Problem 1

Refer to Lab 1 (Problem 2(i) and (iii)). You are required to incorporate business intelligence in your order processing system by adding customer segmentation analysis.

Customer segmentation is the process of dividing a company's customer base into smaller, distinct groups that share similar characteristics, such as demographics, behaviors, or preferences. You are advised to perform segmentation of customer behavior mainly considering purchase habits.

Follow the suggested methodology below:

1. Define and describe customer segments of your own choice (e.g., Frequent Customer, Premium Customer, …). Write your segment definitions below.
2. Draw a prototype interface on paper for segmentation analysis.
3. Write SQL queries to generate segmentation data. Write your queries below.
4. Develop an interface in Visual Studio for segmentation analysis. Write code for a suitable handler that will execute the queries developed in part (c) and display the segmented data to employees of the company. (Develop in Visual Studio.)

Assumption: Sufficient numbers of orders are present in the database.

Problem 2

How can you automate targeted marketing using the segments defined above?

Hint: For all royal customers, send them a complimentary gift through courier and a message of thanks through email/SMS.

Write your approach and any supporting code below.

Problem 3

Develop test cases for your segmentation analysis platform.

Hints:

1. No customer falls in a particular segment.
2. Uneven distribution of customers across segments.

Write your test cases below.