SQL for Data Analysts
The core analyst toolkit: retrieving and filtering, aggregation for reporting, joins across real schemas, subqueries and CTEs, window functions for trends and rankings, and the cleaning work that makes numbers trustworthy. Two capstones take you from a raw retail database to a performance review and a customer segmentation that a manager could act on.
1. Tracks
2. Capstone projects
- E-commerce revenue and customer performanceTurn three years of Wadi Market orders into the revenue, channel, customer and returns story the leadership team asked for.
- Customer segmentation and lifetime valueScore every Wadi Market buyer with RFM, size the segments, measure lifetime value and the referral effect, and hand CRM a ready-to-use action list.