Lab 07 Report - Customer Segmentation

Project Overview

• This project implements Business Intelligence in the order processing system.
• Customers are grouped into segments based on their purchase behavior.

Customer Segments Defined

• Premium Customers - High spending customers based on total purchase value.
• Frequent Customers - Customers placing orders regularly.
• Bulk Buyers - Customers purchasing large quantities per order.
• At-Risk Customers - Customers inactive for a long period.
• Loyal Customers - Customers with repeated purchase history.
• New Customers - Recently registered customers with recent orders.

System Implementation

• Developed using ASP.NET Web Forms with VB.NET backend.
• Dropdown menu allows selection of segmentation type.
• SQL queries dynamically fetch segmented data from database.
• "Show All Segments" option displays all categories at once.

SQL Usage

• Uses aggregation functions like SUM, COUNT, MAX, MIN.
• Joins CUSTOMER_t, ORDER_t, ORDER_LINE_t, PRODUCT_t tables.
• Handles cases like no data in a segment.