Capstone projects

Complete business analyses, graded task by task

Each project gives you a business situation, a stakeholder brief and a database, then 8–10 graded SQL tasks that build to a final result. Every task is checked on real data and on a hidden copy, so the finished project demonstrates what you can actually do.

• Project 01Freeintermediate 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.10 tasks · Wadi Market online store · after: Aggregation and Business Reporting, Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics
• Project 02 Membersintermediate Inventory and fulfilment performance reviewCheck stock against reorder levels, find where deliveries miss their promise, and build the warehouse scorecard for Sahra Logistics.10 tasks · Sahra Logistics warehousing and transport · after: Aggregation and Business Reporting, Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics
• Project 03 Membersadvanced Bank reconciliation for the year-end closeMatch two years of bank statement lines to Tahlia Trading's books, explain every difference and prove the reconciliation closes to the riyal.9 tasks · Tahlia Trading ledger · after: Joining Tables, Subqueries and Advanced Filtering, Data Cleaning and Transformation, SQL for Business and Finance
• Project 04 Membersadvanced Workforce and pay analyticsBuild Masar Holding's people report: headcount, turnover, pay against bands, spans of control, pay for performance and workforce mix.9 tasks · Masar Holding HR · after: Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics, SQL for Business and Finance
• Project 05 Membersadvanced SaaS MRR, churn and retention analysisRebuild Mizan Cloud's MRR from subscription history, decompose its growth, and find out who churns, when and why.8 tasks · Mizan Cloud SaaS · after: Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics, SQL for Data Analytics and Business Intelligence
• Project 06 Membersadvanced 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.10 tasks · Wadi Market online store · after: Aggregation and Business Reporting, Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics, Data Cleaning and Transformation, SQL for Data Analytics and Business Intelligence
• Project 07 Membersadvanced Business-intelligence reporting datasetValidate a star schema, respect slowly changing dimensions and the fiscal calendar, and ship a dashboard-ready view with funnel and marketing KPIs.10 tasks · Wadi Market analytics mart · after: Aggregation and Business Reporting, Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics, Database Creation and Management, SQL for Data Analytics and Business Intelligence
• Project 08 Membersadvanced Advanced SQL performance and analysisAnswer real questions on 300,000 events and 100,000 orders, read query plans, add exactly the right indexes and rewrite slow patterns without changing a single result.10 tasks · Sooq Analytics event store · after: Aggregation and Business Reporting, Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics, Performance and Query Optimization
• Project 09 Membersadvanced Hotel revenue managementAllocate room-nights to the right month, compute occupancy, ADR and RevPAR for seven hotels, and explain cancellations, channel mix, seasonality, repeat guests and ancillary spend.10 tasks · Nakheel Hotels bookings · after: Aggregation and Business Reporting, Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics, SQL for Data Analytics and Business Intelligence
• Project 10 Membersadvanced Clinic operations analysisMeasure no-shows, late cancellations, waiting times, physician activity, service-line revenue, claim rejections and payer mix across six outpatient clinics, and hand management a clean scorecard.10 tasks · Shifa Clinics operations · after: Aggregation and Business Reporting, Joining Tables, Subqueries and Advanced Filtering, Intermediate and Advanced Analytics, Data Cleaning and Transformation, Database Creation and Management