RevOps & Sales Analytics Path

Your forecast is off by $1.2M. Closed-Won reopens again.
Six deals got reassigned mid-cycle and your pipeline report lies.

The SQL patterns RevOps, Sales Ops, and Revenue Analytics teams actually write — OpportunityHistory SCD2 point-in-time snapshots, pipeline stage regressions, mid-cycle owner reassignments, Closed-Won reopens that inflate pipeline, top-N-per-region rep rankings, sales cycle velocity, ARR waterfall bridges, and forecast-accuracy backtests — against a Salesforce-shaped dataset with realistic dirty history. Written for career changers with any bachelor’s degree — SaaS B2B analytics roles (Sales Ops Analyst, RevOps Analyst, Revenue Analyst) pay $75–110K entry-level and hire on portfolio work like this.

See All Missions

30 missions (10 free · 20 Pro incl. 5 Master) · 6 tables · OpportunityHistory SCD2 + Closed-Won reopens

How It Works

1

Read the briefing

A Slack message from your manager

2

Explore the schema

5 tables in a star schema

3

Write your query

Full SQL editor with autocomplete

4

Get expert feedback

Graduated hints, not just pass/fail

Why This Path

Salesforce-Shaped Schema

Account, Contact, Lead, Opportunity, OpportunityHistory, User. The exact table shape you’ll see on day one of any Sales Cloud shop, with the field names you’ll recognize from real Salesforce exports.

OpportunityHistory SCD2

Every stage change, amount change, owner change logged as a row. Point-in-time reconstruction (“what did the forecast look like on March 15?”), stage regression detection, and the Closed-Won reopen anti-pattern that invalidates 80% of naive pipeline reports.

Sales Cycle + Velocity SQL

Stage-duration windows, rep win-rate by region, top-N per group, quarter-over-quarter bookings waterfalls, forecast accuracy as a backtest. The full RevOps analyst toolkit.

Interview + Job-Ready

Every mission maps to a published RevOps / Sales Ops analyst prompt (Salesforce, Gong, Outreach, ZoomInfo, HubSpot, Databricks, Zscaler). Pair with a Salesforce Admin cert (~$200, 1 month) and you have a hiring edge.

The Missions

Each mission is a real request from someone at the company. Difficulty increases as you go.

Starter5 missions
1
Meet the opportunities tableFrom: VP of Sales Operations
What stages exist in the pipeline?From: Sales Operations Manager
Open opportunities by ownerFrom: VP of Sales Operations
Drop the Closed-Lost dealsFrom: Sales Operations Manager
Deals over $50K by accountFrom: CRO
Easy5 missions
Pipeline value by stageFrom: CRO
Deals by close quarterFrom: FP&A Partner to Sales
Win rate by sales repFrom: Sales Operations Manager
Average deal size by regionFrom: VP of Sales Operations
Leads with no account matchFrom: Marketing Ops Lead
Medium5 missions
Deals that reopened after Closed-WonProFrom: RevOps Director
Stage regressions — deals that moved backwardProFrom: Sales Operations Manager
Mid-cycle owner reassignmentsProFrom: RevOps Director
Top 3 reps per region by closed-won revenueProFrom: CRO
Pipeline velocity — avg days per stageProFrom: RevOps Director
Hard5 missions
Most recent opportunity per accountProFrom: Sales Operations Manager
Point-in-time forecast snapshot (SCD2)ProFrom: RevOps Director
Closed-Won cohort retention by monthProFrom: CRO
Quarterly bookings waterfall — new vs expandProFrom: FP&A Partner to Sales
Amount discount — committed vs closedProFrom: FP&A Partner to Sales
Expert5 missions
Pipeline hygiene — issue count per opportunityProFrom: Sales Operations Manager
ARR bridge — starting + new + expand per quarterProFrom: FP&A Partner to Sales
Sales cycle segmentation by deal-size bucketProFrom: CRO
Rep performance dashboardProFrom: CRO
Board-ready sales operations summaryProFrom: CRO
Master5 missions
Discount slippage by close-quarterProFrom: RevOps Director
Stage conversion funnel with drop-offProFrom: CRO
Regional pipeline scorecardProFrom: Sales Operations Manager
Account expansion analysis — multi-opp customersProFrom: FP&A Partner to Sales
RevOps board capstone — quarter close panelProFrom: CRO

The Database

A Salesforce-shaped RevOps schema with planted history-table realism. Opportunities move forward and sometimes backward through stages, deals get reassigned mid-cycle, Closed-Won deals occasionally reopen and inflate the active pipeline, regions and reps have uneven quota attainment, and the OpportunityHistory SCD2 captures every stage / amount / owner change with timestamps. The exact data shape RevOps analysts see on day one at any SaaS company on Sales Cloud.

revops_users (10)revops_accounts (25)revops_contacts (0)revops_opportunities (43)revops_opportunity_history (52)revops_leads (10)

●dimension tables  ● fact tables

Your forecast is off and the CRO wants to know why

Write the SCD2 snapshots, the stage-regression detection, and the waterfall bridges that actually tie the number.

Looking for something different?

|