SQL Product Analytics Project

Objective

Analyze user behavior, conversion funnel, and revenue using SQL.

Dataset

Simulated product data including:

• Users
• Events (signup, view, purchase)
• Payments

Key Analysis

1. Conversion Funnel

• Signups → Views → Purchases

2. Revenue Metrics

• Total Revenue
• Paying Users
• Average Revenue Per User

3. Conversion Rate

• % of users converting to paid

4. User Distribution

• Country-wise segmentation

Key Insights

• Conversion funnel drop observed from view → purchase
• Revenue driven by small % of users
• Geographic distribution impacts growth strategy

Tools Used

• SQL (SQLite)
• VS Code

Skills Demonstrated

• SQL Querying
• Product Analytics
• Funnel Analysis
• Business Metrics Interpretation