Data Analytics & Business Intelligence Entry-Friendly to Moderate ~30 Hours Build

Executive Revenue, Churn & Customer Lifetime Value Analytics Dashboard

Ingest messy raw transaction logs from an e-commerce subscription service, clean and aggregate metrics using SQL, and build an executive-ready interactive BI dashboard.

Required Deliverables

What You Must Build to Graduate

✓ SQL transformation script parsing raw logs into clean dimension and fact tables.
✓ Cohort retention matrix and churn rate calculations by customer acquisition month.
✓ Interactive dashboard in Power BI, Tableau, or Metabase with drill-down filters.
✓ 2-page executive summary memo highlighting 3 data-driven business recommendations.

Verification Rubric

Evaluation & Quality Criteria

Data Modeling & SQL Accuracy (35%): Clean joins, window functions, and no duplicate revenue counting.

Storytelling & Visualization (35%): High-impact charts with intuitive color psychology and clear labels.

Strategic Recommendations (30%): Actionable business insights derived directly from the numbers.

Proof of Work Submission