Level 1: Beginner

• Users present in all categories
• Top 3 highest selling products by category
• Users with no purchases
• Cumulative total amount spent by each user
• Users with highest spending in each category
• Users in the top 50% of total spending
• Difference in amount spent between consecutive transactions

Level 2: Intermediate

• Products either discounted or on sale but not both
• Products priced higher than the average price
• Top 3 highest-rated products in stock
• Products expiring within 30 days
• Products with stock below average quantity
• Products unsold for more than 30 days
• Total stock for categories with average rating > 4.0

Level 3: Advanced

• Unique products with price changes in 6 months
• Customers with no purchases in 6 months
• Average transaction amount for customers with > 5 transactions
• Top 5 customers by average purchase amount in the last year
• Customers with multiple transactions and total spending in the last month
• Sales representatives with above-average new customer additions
• Customers with no purchases in a year but with pending balances