Fatimah Adnan

• Task 1: Data Cleaning

  Handled missing values, deduplicated records, and generated age brackets from DOB fields.

• Task 2: SQL Analytics

  Aggregated revenue trends and customer segmentation using multi-table JOIN queries.

• Task 3: Interactive Dashboards

  Built visual KPIs and real-time category slicers for stakeholder review.

• Task 4: Statistical Validation

  Executed two-sample t-tests to validate conversion shifts across customer cohorts.

SELECT 
    c.category_name,
    COUNT(t.transaction_id) AS total_orders,
    ROUND(SUM(t.amount), 2) AS total_revenue,
    ROUND(AVG(t.amount), 2) AS avg_order_value
FROM transactions t
JOIN categories c ON t.category_id = c.id
WHERE t.status = 'COMPLETED'
GROUP BY c.category_name
ORDER BY total_revenue DESC;

Hypothesis: Customer segment target campaigns yield higher Average Order Value (AOV) compared to standard promotions.