41 lines (31 loc) · 790 Bytes

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